Skip to content

Instantly share code, notes, and snippets.

Created May 23, 2013 14:11
Show Gist options
  • Save anonymous/5636346 to your computer and use it in GitHub Desktop.
Save anonymous/5636346 to your computer and use it in GitHub Desktop.
Heroku and how it ignores your database.yml
saasbook@saasbook:~/LocalSupport$ heroku run bash
Running bash attached to terminal... up, run.9534
~ $ cat config\database.yml
cat: configdatabase.yml: No such file or directory
~ $ ls
app config db Gemfile log README spec vendor
autotest config.ru doc Gemfile.lock public README.md test
bin COPYING features lib Rakefile script tmp
~ $ cd config
~/config $ database.yml
bash: database.yml: command not found
~/config $ vi database.yml
bash: vi: command not found
~/config $ cat database.yml
<%
require 'cgi'
require 'uri'
begin
uri = URI.parse(ENV["DATABASE_URL"])
rescue URI::InvalidURIError
raise "Invalid DATABASE_URL"
end
raise "No RACK_ENV or RAILS_ENV found" unless ENV["RAILS_ENV"] || ENV["RACK_ENV"]
def attribute(name, value, force_string = false)
if value
value_string =
if force_string
'"' + value + '"'
else
value
end
"#{name}: #{value_string}"
else
""
end
end
adapter = uri.scheme
adapter = "postgresql" if adapter == "postgres"
database = (uri.path || "").split("/")[1]
username = uri.user
password = uri.password
host = uri.host
port = uri.port
params = CGI.parse(uri.query || "")
%>
<%= ENV["RAILS_ENV"] || ENV["RACK_ENV"] %>:
<%= attribute "adapter", adapter %>
<%= attribute "database", database %>
<%= attribute "username", username %>
<%= attribute "password", password, true %>
<%= attribute "host", host %>
<%= attribute "port", port %>
<% params.each do |key, value| %>
<%= key %>: <%= value.first %>
<% end %>
~/config $
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment