-
Notifications
You must be signed in to change notification settings - Fork 1
/
rakefile
35 lines (29 loc) · 1.15 KB
/
rakefile
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
require "rubygems"
require "bundler/setup"
require 'pg'
require 'active_record'
require 'erb'
require 'yaml'
vacation_slack_bot_env = ENV['VACATION_SLACK_BOT_ENV'] || 'development'
connection_details = YAML.load(ERB.new(File.read("config/database.#{vacation_slack_bot_env}.yml")).result)
namespace :db do
desc "Migrate the db"
task :migrate do
ActiveRecord::Base.establish_connection(connection_details)
ActiveRecord::Migrator.migrate("migrations/")
end
desc "Create the db"
task :create do
admin_connection = connection_details.merge({'database'=> 'postgres',
'schema_search_path'=> 'public'})
ActiveRecord::Base.establish_connection(admin_connection)
ActiveRecord::Base.connection.create_database(connection_details.fetch('database'))
end
desc "drop the db"
task :drop do
admin_connection = connection_details.merge({'database'=> 'postgres',
'schema_search_path'=> 'public'})
ActiveRecord::Base.establish_connection(admin_connection)
ActiveRecord::Base.connection.drop_database(connection_details.fetch('database'))
end
end