config.env database_url not working

[tangyiming]

i run a postgresql container in docker,
and add this in config.env:
DATABASE_URL=postgresql://postgres:docker@localhost:5432/postgres
but every time i run:
python manage.py setup_dev
it will creates data-dev.sqlite

ps:the db name and password is correct,i can use the command to connect:
psql -h localhost -U postgres -d postgres

[Euphorbium]

@tangyiming I haven't tested this, but have you tried setting SQLALCHEMY_DATABASE_URI instead?

[abhisuri97]

@tangyiming the reason it does that is that you have the app in development mode. ChangeFLASK_CONFIG=production to get the ability to connect to a db. If you want to connect to a Db in dev mode then look at lines:

flask-base/config.py

Line 78 in 2278d3f

SQLALCHEMY_DATABASE_URI = os.environ.get('DEV_DATABASE_URL') or \

Basically setDEV_DATABASE_URL=yoururlhere in config.env.

[tangyiming]

@abhisuri97 thanks,it works.