Local migration from sqlite to postgres with Flask

Question

I'm trying to extend the flask-base project https://github.com/hack4impact/flask-base/tree/master/app .

I have used flask-migrate to create migrations for my local sqlite db.

I now need to migrate from the local sqlite db to heroku's postgres. Following https://www.quora.com/What-is-the-best-way-to-copy-my-SQLite-database-to-PostgreSQL-so-I-can-deploy-it-to-Heroku , I'm trying I set up a local postgres db called 'test' (screenshot)

I set:

os.environ["TEST_DATABASE_URL"] = "postgresql+psycopg2://127.0.0.1:5432/test"   # REMOVE THIS !!!!!!!!!!

There is a test config in the config.py containing:

class TestingConfig(Config):
    TESTING = True
    SQLALCHEMY_DATABASE_URI = os.environ.get('TEST_DATABASE_URL') or \
        'sqlite:///' + os.path.join(basedir, 'data-test.sqlite')

    print('TestingConfig - psgres?')
    print(SQLALCHEMY_DATABASE_URI)

    WTF_CSRF_ENABLED = False

However when I perform the upgrade with flask-migrate:

$ python manage.py db upgrade


TestingConfig - psgres?
postgresql+psycopg2://127.0.0.1:5432/test

INFO  [alembic.runtime.migration] Context impl SQLiteImpl.
INFO  [alembic.runtime.migration] Will assume non-transactional DDL.
INFO  [alembic.runtime.migration] Running upgrade  -> 78401e355127, empty message

A new sqlite db is created. Obviously I'm not connecting to the postgres test db. How can I get this working?

suhas.org/sqlalchemy-tutorial

user1592380
– user1592380

2018-02-08 04:20:36 +00:00
Commented Feb 8, 2018 at 4:20 — user1592380
– user1592380, Commented Feb 8, 2018 at 4:20

user1592380 · Accepted Answer · 2018-02-08 13:42:03Z

1

in this case the environmental variables were not being recognized initially, but when I rebooted later they did start working.

os.environ["TEST_DATABASE_URL"] = "postgresql://[email protected]:5432/postgres"

worked.

answered Feb 8, 2018 at 13:42

user1592380

36.9k105 gold badges317 silver badges559 bronze badges

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

Comments

lukasz.herok · Accepted Answer · 2021-02-20 10:00:03Z

0

I was also doing the migration and I've recorded it in short post:

Migrating form SqlLite to Postgresql in Flask

answered Feb 20, 2021 at 10:00

lukasz.herok

1348 bronze badges

Collectives™ on Stack Overflow

Local migration from sqlite to postgres with Flask

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related