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