config.py did not send back DATABASE_URL

Question

my config.py:

"""Flask config."""
import os
from dotenv import dotenv_values

basedir = os.path.abspath(os.path.dirname(__file__))

configuration = dotenv_values(".env")

class Config(object):
    DEBUG = False
    TESTING = False
    CSRF_ENABLED = True
    SECRET_KEY = os.environ.get('SECRET_KEY')
    SQLALCHEMY_DATABASE_URI = os.environ.get('DATABASE_URL')

class ProductionConfig(Config):
    DEBUG = False

I'm trying to connect to DB with another py file:

import psycopg2
import xlrd
from config import Config


POSTGRES = Config.SQLALCHEMY_DATABASE_URI
connection = psycopg2.connect(POSTGRES)
cursor = connection.cursor()

But POSTRES is None

my .env file is in same directory like this:

FLASK_APP=wsgi.py
FLASK_ENV=development
SECRET_KEY=randomstringofcharacters
DATABASE_URL='postgresql://xxx:[email protected]:5432/xxxxx'

All my files are in same directory.

So is it POSTGRES or POSTRES ? You could simply add a print in your config section right after declaring POSTGRES to verify that it is indeed has a value. — Kate
– Kate, Commented Jun 4, 2021 at 20:40

Dave W. Smith · Accepted Answer · 2021-06-04 21:00:12Z

1

dotenv_values() doesn't side-effect the local environment. You need load_dotenv(), which does.

See https://pypi.org/project/python-dotenv/#load-configuration-without-altering-the-environment

answered Jun 4, 2021 at 21:00

Dave W. Smith

25k4 gold badges42 silver badges50 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

config.py did not send back DATABASE_URL

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related