Search code examples
pythonsqliteflaskalembicflask-migrate

Tables are detected when running migration, but aren't created in database

I ran a migration to create the SQLite tables for a cookiecutter Flask app. Although the database file exists and I can open it, I cannot see the tables. When I try to create a user I get a "no such table" error. Why doesn't the table exist even though I ran the migration? How can I use the tables?

$ python manage.py db migrate
INFO  [alembic.migration] Context impl SQLiteImpl.
INFO  [alembic.migration] Will assume non-transactional DDL.
INFO  [alembic.autogenerate.compare] Detected added table 'tags'
INFO  [alembic.autogenerate.compare] Detected added table 'users'
INFO  [alembic.autogenerate.compare] Detected added table 'posts'
INFO  [alembic.autogenerate.compare] Detected added table 'tags_posts'
Generating C:\envs\r2\myflaskapp\migrations\versions\....

sqlalchemy.exc.OperationalError OperationalError: (OperationalError) no such table:
Solution

  • You only generated the migration, you need to apply it as well. Be sure to read through the generated migration file to ensure it's correct before running it.

    python manage.py db upgrade

    Applying generated migrations is described in the docs for both Alembic (the migration engine) and Flask-Migrate (the manage commands).