Contents

# Copyright 2006, Bradley Taylor, [e-mail]
# Licensed under the GNU Lesser General Public License.

# CentOS 4.3 install for Rails Machine
# sudo -s
# yum install postgresql-client postgresql-server postgresql-devel
# chkconfig postgresql on
# service postgresql start
# gem install postgres
# su - postgres
# createuser deploy -a -d 
# exit

require 'yaml'
require 'capistrano'
require 'capistrano/cli'

module PostgreSQLMethods
  
  def createdb(db, user)
    run "createdb -O #{user} #{db}"  
  end
  
  def createuser(user, password)
    cmd = "createuser -P -D -A -E #{user}"
    run cmd do |channel, stream, data|
      if data =~ /^Enter password for new user:/
        channel.send_data "#{password}\n" 
      end
      if data =~ /^Enter it again:/
        channel.send_data "#{password}\n" 
      end
    end
  end
  
  def command(sql, database)
    run "psql --command=\"#{sql}\" #{database}" 
  end
   
end

Capistrano.plugin :pgsql, PostgreSQLMethods

Capistrano.configuration(:must_exist).load do
  
  desc "Create PosgreSQL database and user based on config/database.yml"
  task :setup_pgsql, :roles => :db, :only => { :primary => true } do
    # on_rollback {} TODO
    read_config
    pgsql.createuser db_user, db_password
    pgsql.createdb db_name, db_user
  end
  
  desc "Setup database"
  task :setup_db, :roles => :db, :only => { :primary => true } do
    setup_pgsql
  end
  
  def read_config
    db_config = YAML.load_file('config/database.yml')
    set :db_user, db_config[rails_env]["username"]
    set :db_password, db_config[rails_env]["password"] 
    set :db_name, db_config[rails_env]["database"]
  end
  
end

Version data entries

1 entries across 1 versions & 1 rubygems

Version	Path
railsmachine-0.1.2	lib/railsmachine/recipes/pgsql.rb