class Brillo::Adapter::MySQL

Public Instance Methods

dump_structure_and_migrations(config) click to toggle source
# File lib/brillo/adapter/mysql.rb, line 23
def dump_structure_and_migrations(config)
  Dumper::MysqlDumper.new(config).dump
end
header() click to toggle source
Calls superclass method Brillo::Adapter::Base#header
# File lib/brillo/adapter/mysql.rb, line 4
      def header
        super + <<-SQL
        -- Disable autocommit, uniquechecks, and foreign key checks, for performance on InnoDB
        -- http://dev.mysql.com/doc/refman/5.5/en/optimizing-innodb-bulk-data-loading.html
        SET @OLD_AUTOCOMMIT=@@AUTOCOMMIT, AUTOCOMMIT = 0;
        SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS = 0;
        SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS = 0;
        SQL
      end
load_command() click to toggle source
# File lib/brillo/adapter/mysql.rb, line 27
def load_command
  host = config["host"] ? "--host #{config["host"]}" : ""
  password = config["password"] ? "-p#{config["password"]}" : ""
  "mysql #{host} -u #{config.fetch("username")} #{password} #{config.fetch("database")}"
end