Class: MysqlAdapter

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

Instance Method Summary collapse

Constructor Details

#initialize(config) ⇒ MysqlAdapter

Returns a new instance of MysqlAdapter.



2
3
4
 
# File 'lib/adapters/mysql_adapter.rb', line 2

def initialize(config)
  @config = config
end

Instance Method Details

#copy(new_db_config) ⇒ Object 



16
17
18
19
20
 
# File 'lib/adapters/mysql_adapter.rb', line 16

def copy(new_db_config)
  ensure_db_exists
  ensure_db_exists(new_db_config[:database])
  Kernel.` "mysqldump -h #{@config[:host]} -u #{@config[:username]} #{'-p' + @config[:password] if @config[:password]} #{@config[:database]} | mysql -h #{new_db_config[:host]} -u #{new_db_config[:username]} #{'-p' + new_db_config[:password] if new_db_config[:password]} #{new_db_config[:database]}"
end

#ensure_db_exists(name = @config[:database]) ⇒ Object 



22
23
24
 
# File 'lib/adapters/mysql_adapter.rb', line 22

def ensure_db_exists(name = @config[:database])
  `echo "CREATE DATABASE IF NOT EXISTS #{name}" | mysql -h #{@config[:host]} -u #{@config[:username]} #{'-p' + @config[:password] if @config[:password]}`
end

#export ⇒ Object 



6
7
8
9
 
# File 'lib/adapters/mysql_adapter.rb', line 6

def export
  ensure_db_exists
  Kernel.` "mysqldump -h #{@config[:host]} -u #{@config[:username]} #{'-p' + @config[:password] if @config[:password]} #{@config[:database]}"
end

#import(sql) ⇒ Object 



11
12
13
14
 
# File 'lib/adapters/mysql_adapter.rb', line 11

def import(sql)
  ensure_db_exists
  Kernel.` "echo \"#{sql}\" | mysql -h #{@config[:host]} -u #{@config[:username]} #{'-p' + @config[:password] if @config[:password]} #{@config[:database]}"
end