restore.rake

namespace:dbdo

taskrestore: [
'db:download:generate',
'db:download:latest',
'db:drop',
'db:create',
'db:download:load',
'db:download:clean',
'db:migrate'
]

namespace:downloaddo
defdb_dump_file
"coderwall-production.dump"
end

desc'Create a production database backup'
task:generatedo
Bundler.with_clean_envdo
cmd="heroku pg:backups capture DATABASE_URL --app coderwall-next"
sh(cmd)
end
end

desc'Download latest database backup'
task:latestdo
unlessFile.exists?(db_dump_file)
Bundler.with_clean_envdo
sh("curl `heroku pg:backups public-url --app coderwall-next` -o #{db_dump_file}")
end
end
end

desc'Load local database backup into dev'
taskload: :environmentdo
raise'local dump not found'unlessFile.exists?(db_dump_file)
puts'Loading Production database locally'
`pg_restore --verbose --clean --no-acl --no-owner -h localhost -d coderwall-next_development #{db_dump_file}`
end

task:cleando
`rm #{db_dump_file}`
end
end

end