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 



39
40
 
# File 'lib/db_agent/db_handler/mssql.rb', line 39

def restore(t, args)
end

#spy ⇒ Object 



21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
 
# File 'lib/db_agent/db_handler/mssql.rb', line 21

def spy
  spy_jar = DbAgent._!('vendor').glob('schema*.jar').first
  jdbc_jar = DbAgent._!('vendor').glob('mssql*.jar').first
  cmd = ""
  cmd << %Q{java -jar #{spy_jar}}
  cmd << %Q{ -dp #{jdbc_jar} -t mssql05}
  cmd << %Q{ -host #{config[:host]}}
  cmd << %Q{ -u #{config[:user]}}
  cmd << %Q{ -p #{config[:password]}}
  cmd << %Q{ -db #{config[:database]}}
  cmd << %Q{ -port #{config[:port]}}
  cmd << %Q{ -s dbo}
  cmd << %Q{ -o #{schema_folder}/spy}
  cmd << %Q{ #{ENV['SCHEMA_SPY_ARGS']}} if ENV['SCHEMA_SPY_ARGS']
  system(cmd)
  system %Q{open #{schema_folder}/spy/index.html}
end