Sha256: 39299c38d7a1cb4095ef1183308be7e0cad65fba96bd6f347d448cd84711c66d

Contents?: true

Size: 1.09 KB

Versions: 16

Compression:

Stored size: 1.09 KB

Contents

namespace :db do
  desc "Reset DataBase for environment and test"
  task :reset do
    Rake::Task['db:drop'].invoke
    Rake::Task['db:create'].invoke
    Rake::Task['db:migrate'].invoke
    Rake::Task['db:seed'].invoke
    sh "rake db:test:prepare"
  end

  desc "Backup the database tp tmp/db.sql file"
  task backup: :get_db_config do
    sh "export PGPASSWORD=#{@password} && pg_dump #{@database} --host #{@host} -U #{@username} -f #{@default_filename}"
  end

  desc "Restore the database from tmp/db.sql file if no one is passed"
  task restore: [:drop, :create, :get_db_config] do
    sh "export PGPASSWORD=#{@password} && psql -d #{@database} -U #{@username} -h #{@host} < #{filename}"
  end
end

task :get_db_config do
  config   = Rails.configuration.database_configuration
  @host = config[Rails.env]["host"]
  @database = config[Rails.env]["database"]
  @username = config[Rails.env]["username"]
  @password = config[Rails.env]["password"]

  @default_filename = "tmp/db.sql"
end

def filename
  name = ARGV[1]
  task name.to_sym do ; end unless name.nil?
  return name ? name : @default_filename
end



Version data entries

16 entries across 16 versions & 1 rubygems

Version Path
prun-ops-0.2.15 lib/tasks/db.rake
prun-ops-0.2.14 lib/tasks/db.rake
prun-ops-0.2.13 lib/tasks/db.rake
prun-ops-0.2.12 lib/tasks/db.rake
prun-ops-0.2.11 lib/tasks/db.rake
prun-ops-0.2.10 lib/tasks/db.rake
prun-ops-0.2.9 lib/tasks/db.rake
prun-ops-0.2.8 lib/tasks/db.rake
prun-ops-0.2.7 lib/tasks/db.rake
prun-ops-0.2.6 lib/tasks/db.rake
prun-ops-0.2.2 lib/tasks/db.rake
prun-ops-0.2.1 lib/tasks/db.rake
prun-ops-0.2.0 lib/tasks/db.rake
prun-ops-0.1.10 lib/tasks/db.rake
prun-ops-0.1.9 lib/tasks/db.rake
prun-ops-0.1.8 lib/tasks/db.rake