Class: DbAgent::DbHandler::MSSQL

Inherits:
DbAgent::DbHandler show all
Defined in:
lib/db_agent/db_handler/mssql.rb

Instance Attribute Summary

Attributes inherited from DbAgent::DbHandler

#backup_folder, #config, #data_folder, #migrations_folder, #schema_folder, #superconfig, #viewpoints_folder

Instance Method Summary collapse

Methods inherited from DbAgent::DbHandler

factor, #initialize, #migrate, #ping, #require_viewpoints!, #sequel_db, #sequel_superdb, #system, #wait, #wait_server

Constructor Details

This class inherits a constructor from DbAgent::DbHandler

Instance Method Details

#backup ⇒ Object 



13
14
15
 
# File 'lib/db_agent/db_handler/mssql.rb', line 13

def backup
  raise
end

#create ⇒ Object 



5
6
7
 
# File 'lib/db_agent/db_handler/mssql.rb', line 5

def create
  raise
end

#drop ⇒ Object 



9
10
11
 
# File 'lib/db_agent/db_handler/mssql.rb', line 9

def drop
  raise
end

#repl ⇒ Object 



17
18
19
 
# File 'lib/db_agent/db_handler/mssql.rb', line 17

def repl
  raise
end

#restore(t, args) ⇒ Object 



27
28
 
# File 'lib/db_agent/db_handler/mssql.rb', line 27

def restore(t, args)
end

#spy ⇒ Object 



21
22
23
24
25
 
# File 'lib/db_agent/db_handler/mssql.rb', line 21

def spy
  jdbc_jar = (Path.dir.parent/'vendor').glob('mssql*.jar').first
  system %Q{java -jar vendor/schemaSpy_5.0.0.jar -dp #{jdbc_jar} -t mssql05 -host #{config[:host]} -u #{config[:user]} -p #{config[:password]} -db #{config[:database]} -port #{config[:port]} -s dbo -o #{schema_folder}/spy}
  system %Q{open #{schema_folder}/spy/index.html}
end