class SwarmClusterCliOpe::SyncConfigs::Mysql
Public Instance Methods
pull()
click to toggle source
@return [TrueClass, FalseClass]
# File lib/swarm_cluster_cli_ope/sync_configs/mysql.rb, line 6 def pull resume('pull') if yes?("Confermare il comando?[y,yes]") tmp_file = "/tmp/#{Time.now.to_i}.sql.gz" container.exec("bash -c 'mysqldump -u #{remote.username} --password=#{remote.password} #{remote.database_name} | gzip -c -f' > #{tmp_file}") local_container.copy_in(tmp_file, tmp_file) local_authentication = "-u #{local.username} --password=#{local.password}" command = [] command << "bash -c '" command << "mysql #{local_authentication} -e \"DROP DATABASE IF EXISTS #{local.database_name};CREATE DATABASE #{local.database_name}\"" command << "&&" command << "zcat #{tmp_file}" command << "|" command << "mysql #{local_authentication} #{local.database_name}" command << "'" local_container.exec(command.join" ") end true end
push()
click to toggle source
@return [TrueClass, FalseClass]
# File lib/swarm_cluster_cli_ope/sync_configs/mysql.rb, line 33 def push resume('PUSH') if yes?("ATTENZIONE !!!!!!PUSH!!!!! - Confermare il comando?[y,yes]") tmp_file = "/tmp/#{Time.now.to_i}.sql.gz" local_container.exec("bash -c 'mysqldump -u #{local.username} --password=#{local.password} #{local.database_name} | gzip -c -f' > #{tmp_file}") container.copy_in(tmp_file, tmp_file) container.exec("bash -c 'zcat #{tmp_file} | mysql -u #{remote.username} --password=#{remote.password} #{remote.database_name}'") end true end