Class: Sequel::MysqlDbCommands

Inherits:
Object
  • Object
show all
Defined in:
lib/sequel_rake_tasks.rb

Instance Method Summary collapse

Constructor Details

#initialize(connection_config) ⇒ MysqlDbCommands

Returns a new instance of MysqlDbCommands.



97
98
99
 
# File 'lib/sequel_rake_tasks.rb', line 97

def initialize(connection_config)
  @connection_config = connection_config
end

Instance Method Details

#create_database ⇒ Object 



105
106
107
 
# File 'lib/sequel_rake_tasks.rb', line 105

def create_database
  execute("CREATE DATABASE IF NOT EXISTS `#{database_name}` DEFAULT CHARACTER SET #{charset} DEFAULT COLLATE #{collation}")
end

#drop_database ⇒ Object 



101
102
103
 
# File 'lib/sequel_rake_tasks.rb', line 101

def drop_database
  execute("DROP DATABASE IF EXISTS `#{database_name}`")
end

#load_sql_file(filename) ⇒ Object 



109
110
111
112
113
114
 
# File 'lib/sequel_rake_tasks.rb', line 109

def load_sql_file(filename)
  commands = base_commands
  commands << '--execute' << %{SET FOREIGN_KEY_CHECKS = 0; SOURCE #{filename}; SET FOREIGN_KEY_CHECKS = 1}
  commands << '--database' << database_name
  system(*commands)
end