Class: HerokuRails::DbConfiguration

Inherits:
Object
  • Object
show all
Defined in:
lib/heroku_rails/db_configuration.rb

Instance Method Summary collapse

Instance Method Details

#configObject



4
5
6
7
8
# File 'lib/heroku_rails/db_configuration.rb', line 4

def config
  @config ||= YAML.load(
    ERB.new(File.read("config/database.yml")).result
  )
end

#databaseObject



20
21
22
# File 'lib/heroku_rails/db_configuration.rb', line 20

def database
  db_config["database"]
end

#generate_drop_tables_sqlObject



10
11
12
13
# File 'lib/heroku_rails/db_configuration.rb', line 10

def generate_drop_tables_sql
  sql = %(select 'DROP TABLE IF EXISTS \\"' || tablename || '\\" CASCADE;' from pg_tables where schemaname = 'public')
  %(psql #{user_arg} #{database} -t -c "#{sql}")
end

#user_argObject



15
16
17
18
# File 'lib/heroku_rails/db_configuration.rb', line 15

def user_arg
  username = db_config["username"]
  username.present? && "-U #{username}" || ""
end