Class: ActiveRecord::Tasks::SQLServerDatabaseTasks
- Inherits:
-
Object
- Object
- ActiveRecord::Tasks::SQLServerDatabaseTasks
- Defined in:
- lib/active_record/tasks/sqlserver_database_tasks.rb
Constant Summary collapse
- DEFAULT_COLLATION =
"SQL_Latin1_General_CP1_CI_AS"
Class Method Summary collapse
Instance Method Summary collapse
- #charset ⇒ Object
- #collation ⇒ Object
- #create(master_established = false) ⇒ Object
- #drop ⇒ Object
-
#initialize(configuration) ⇒ SQLServerDatabaseTasks
constructor
A new instance of SQLServerDatabaseTasks.
- #purge ⇒ Object
- #structure_dump(filename, extra_flags) ⇒ Object
- #structure_load(filename, extra_flags) ⇒ Object
Constructor Details
#initialize(configuration) ⇒ SQLServerDatabaseTasks
Returns a new instance of SQLServerDatabaseTasks.
20 21 22 23 |
# File 'lib/active_record/tasks/sqlserver_database_tasks.rb', line 20 def initialize(configuration) @configuration = configuration @configuration_hash = @configuration.configuration_hash end |
Class Method Details
.using_database_configurations? ⇒ Boolean
16 17 18 |
# File 'lib/active_record/tasks/sqlserver_database_tasks.rb', line 16 def self.using_database_configurations? true end |
Instance Method Details
#charset ⇒ Object
42 43 44 |
# File 'lib/active_record/tasks/sqlserver_database_tasks.rb', line 42 def charset connection.charset end |
#collation ⇒ Object
46 47 48 |
# File 'lib/active_record/tasks/sqlserver_database_tasks.rb', line 46 def collation connection.collation end |
#create(master_established = false) ⇒ Object
25 26 27 28 29 30 31 32 33 34 35 |
# File 'lib/active_record/tasks/sqlserver_database_tasks.rb', line 25 def create(master_established = false) establish_master_connection unless master_established connection.create_database configuration.database, configuration_hash.merge(collation: default_collation) establish_connection configuration rescue ActiveRecord::StatementInvalid => e if /database .* already exists/i === e. raise DatabaseAlreadyExists else raise end end |
#drop ⇒ Object
37 38 39 40 |
# File 'lib/active_record/tasks/sqlserver_database_tasks.rb', line 37 def drop establish_master_connection connection.drop_database configuration.database end |
#purge ⇒ Object
50 51 52 53 54 |
# File 'lib/active_record/tasks/sqlserver_database_tasks.rb', line 50 def purge clear_active_connections! drop create true end |
#structure_dump(filename, extra_flags) ⇒ Object
56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 |
# File 'lib/active_record/tasks/sqlserver_database_tasks.rb', line 56 def structure_dump(filename, extra_flags) server_arg = "-S #{Shellwords.escape(configuration_hash[:host])}" server_arg += ":#{Shellwords.escape(configuration_hash[:port])}" if configuration_hash[:port] command = [ "defncopy-ttds", server_arg, "-D #{Shellwords.escape(configuration_hash[:database])}", "-U #{Shellwords.escape(configuration_hash[:username])}", "-P #{Shellwords.escape(configuration_hash[:password])}", "-o #{Shellwords.escape(filename)}", ] table_args = connection.tables.map { |t| Shellwords.escape(t) } command.concat(table_args) view_args = connection.views.map { |v| Shellwords.escape(v) } command.concat(view_args) raise "Error dumping database" unless Kernel.system(command.join(" ")) dump = File.read(filename) dump.gsub!(/^USE .*$\nGO\n/, "") # Strip db USE statements dump.gsub!(/^GO\n/, "") # Strip db GO statements dump.gsub!(/nvarchar\(8000\)/, "nvarchar(4000)") # Fix nvarchar(8000) column defs dump.gsub!(/nvarchar\(-1\)/, "nvarchar(max)") # Fix nvarchar(-1) column defs dump.gsub!(/text\(\d+\)/, "text") # Fix text(16) column defs File.open(filename, "w") { |file| file.puts dump } end |
#structure_load(filename, extra_flags) ⇒ Object
82 83 84 |
# File 'lib/active_record/tasks/sqlserver_database_tasks.rb', line 82 def structure_load(filename, extra_flags) connection.execute File.read(filename) end |