Has anybody been able to connect to a Postgres database
using stand alone Pydal?
I know I have to pass the database credentials via the environment
variable DATABASE_URL thru the heroku-cli like this:
DATABASE_URL=$(heroku config:get DATABASE_URL -a books-proyecto1) MY-PROCESS
but I don't know what is MY-PROCESS (books-proyecto1 is MY-APP).
Then I just call DATABASE_URL in my app to make the connection.
import os
import psycopg2
from bottle import run, route, request, post, get
from yatl import *
from pydal import *
DATABASE_URL = os.environ['DATABASE_URL']
db = DAL('DATABASE_URL')
When I run the app it gives me a KeyError, beacause DATABASE_URL is empty.
How do I pass DATABASE_URL from Heroku to PyDAL?
I think the key is MY-PROCESS.
--
Resources:
- http://web2py.com
- http://web2py.com/book (Documentation)
- http://github.com/web2py/web2py (Source code)
- https://code.google.com/p/web2py/issues/list (Report Issues)
---
You received this message because you are subscribed to the Google Groups
"web2py-users" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to web2py+unsubscr...@googlegroups.com.
To view this discussion on the web visit
https://groups.google.com/d/msgid/web2py/f68e1197-a6af-4b8d-9337-f179d5dd2c70n%40googlegroups.com.
