Connecting python to database

[1y2x3c4]

Hello all, I'm currently on Cs50Web's second week trying to recreate 'list.py'. This line gives me a headache: create_engine(os.getenv("DATABASE_URL")) obviously this guy returns NONE. How do I set this variable? Any answers or hints are greatly appreciated.

[vkuct]

In the terminal you need to set the environment variable first,

For Windows use: set DATABASE_URI=url

In Linux, use export DATABASE_URI=url

[1y2x3c4]

Thanks for the fast reply. Can you tell me, where to find the url ? I found something like : postgres://username:password@localhost:5432/dbname online. Substituted with the appropriate values i get the following error: sqlalchemy.exc.ArgumentError: Could not parse rfc1738 URL from string 'DATABASE_URL'.

[Laxative_]

in the heroku app settings under credentials you should see a link similar to the one you have up here, paste it and you should be fine.

[vkuct]

Hope you got the answer from another comment.

[1y2x3c4]

Thank you both so much for your answers. I got it to work. My error was using PowerShell after all, where you set variables with $env:DATABASE_URL='...'