Class: ArJdbc::Tasks::MSSQLDatabaseTasks

Inherits:
Object
  • Object
show all
Defined in:
lib/arjdbc/tasks/mssql_database_tasks.rb

Overview

:nodoc:

Class Method Summary collapse

Instance Method Summary collapse

Constructor Details

#initialize(db_config) ⇒ MSSQLDatabaseTasks

Returns a new instance of MSSQLDatabaseTasks.



12
13
14
15
 
# File 'lib/arjdbc/tasks/mssql_database_tasks.rb', line 12

def initialize(db_config)
  @db_config = db_config
  @configuration_hash = db_config.configuration_hash
end

Class Method Details

.using_database_configurations? ⇒ Boolean

Returns:

  • (Boolean) 


8
9
10
 
# File 'lib/arjdbc/tasks/mssql_database_tasks.rb', line 8

def self.using_database_configurations?
  true
end

Instance Method Details

#charset ⇒ Object 



35
36
37
 
# File 'lib/arjdbc/tasks/mssql_database_tasks.rb', line 35

def charset
  connection.charset
end

#collation ⇒ Object 



39
40
41
 
# File 'lib/arjdbc/tasks/mssql_database_tasks.rb', line 39

def collation
  connection.collation
end

#create ⇒ Object 



17
18
19
20
21
22
23
24
25
26
27
28
 
# File 'lib/arjdbc/tasks/mssql_database_tasks.rb', line 17

def create
  establish_master_connection
  connection.create_database(db_config.database, creation_options)
  establish_connection(db_config)
rescue ActiveRecord::StatementInvalid => e
  case e.message
  when /database .* already exists/i
    raise ActiveRecord::DatabaseAlreadyExists
  else
    raise
  end
end

#drop ⇒ Object 



30
31
32
33
 
# File 'lib/arjdbc/tasks/mssql_database_tasks.rb', line 30

def drop
  establish_master_connection
  connection.drop_database(db_config.database)
end

#purge ⇒ Object 



43
44
45
46
47
 
# File 'lib/arjdbc/tasks/mssql_database_tasks.rb', line 43

def purge
  ActiveRecord::Base.connection_handler.clear_active_connections!(:all)
  drop
  create
end

#structure_dump(filename, _extra_flags) ⇒ Object 



49
50
51
52
53
54
55
 
# File 'lib/arjdbc/tasks/mssql_database_tasks.rb', line 49

def structure_dump(filename, _extra_flags)
  args = prepare_command_options

  args.concat(["-f #{filename}"])

  run_cmd('mssql-scripter', args, 'dumping')
end

#structure_load(filename, _extra_flags) ⇒ Object 



57
58
59
60
61
62
63
 
# File 'lib/arjdbc/tasks/mssql_database_tasks.rb', line 57

def structure_load(filename, _extra_flags)
  args = prepare_command_options

  args.concat(["-i #{filename}"])

  run_cmd('mssql-cli', args, 'loading')
end