Contents

Standup.script :node do
  def run
    install_package 'mysql-server-5.1', :input => ['root', 'root', 'root']
    install_package 'libmysqlclient-dev'
    
    # todo: tune performance
  end
  
  def exec_sql sql, local = false
    command = "mysql -uroot -proot -e \"#{sql}\""
    if local
      local_exec command
    else
      exec command
    end
  end
  
  def create_database name, local = false
    if exec_sql("show databases like '#{name}'", local).present?
      false
    else
      exec_sql "create database #{name}", local
      true
    end
  end
  
  def dump_command database, username = 'root', password = 'root'
    "mysqldump -u#{username} -p#{password} --compact -e --create-options --add-drop-table #{database}"
  end
  
  def load_command database, username = 'root', password = 'root'
    "mysql -u#{username} -p#{password} #{database}"
  end
end

Version data entries

41 entries across 41 versions & 1 rubygems

Version	Path
standup-0.6.5	scripts/mysql.rb
standup-0.6.4	scripts/mysql.rb
standup-0.6.3	scripts/mysql.rb
standup-0.6.2	scripts/mysql.rb
standup-0.6.1	scripts/mysql.rb
standup-0.6.0	scripts/mysql.rb
standup-0.5.14	scripts/mysql.rb
standup-0.5.13	scripts/mysql.rb
standup-0.5.11	scripts/mysql.rb
standup-0.5.10	scripts/mysql.rb
standup-0.5.9	scripts/mysql.rb
standup-0.5.8	scripts/mysql.rb
standup-0.5.7	scripts/mysql.rb
standup-0.5.6	scripts/mysql.rb
standup-0.5.5	scripts/mysql.rb
standup-0.5.4	scripts/mysql.rb
standup-0.5.3	scripts/mysql.rb
standup-0.5.1	scripts/mysql.rb
standup-0.5.0	scripts/mysql.rb
standup-0.4.0	scripts/mysql.rb