Class: MysqlAdapter
- Inherits:
-
Object
- Object
- MysqlAdapter
- Defined in:
- lib/adapters/mysql_adapter.rb
Instance Method Summary collapse
- #copy(new_db_config) ⇒ Object
- #ensure_db_exists(name = @config[:database]) ⇒ Object
- #export ⇒ Object
- #import(sql) ⇒ Object
-
#initialize(config) ⇒ MysqlAdapter
constructor
A new instance of MysqlAdapter.
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 |