summaryrefslogtreecommitdiff
path: root/lib/tasks/db.rake
blob: 20e77828ceb8bf5aa7440959dbc9cf88aee12a03 (plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
require "yaml"

namespace :db do
  desc 'backup database (rake db:backup["production"]'
  task :backup, :env do |key, value|
    environment = value[:env] || 'development'
    sh "cap #{environment} postgresql:backup"
  end

  task :restore, :env do |key, value|
    environment = value[:env] || 'development'
    all_configuration = YAML.load_file(File.join(File.dirname(__FILE__), '../../config/database.yml' ))
    config = all_configuration[environment]
    sh "pg_restore --verbose --clean --no-acl --no-owner -h #{config["host"]} -U #{config["username"]} -d #{config["database"]} tmp/database.dump"
  end
end