Cannot complete Flask-Migration

python postgresql sqlalchemy-migrate flask-migrate
Suraj Kapoor picture Suraj Kapoor · Jan 7, 2014 · Viewed 18.9k times · Source

I've setup a local Postgres DB with SQLAlchemy and cannot commit my first entry. I keep on getting this error... 

ProgrammingError: (ProgrammingError) relation "user" does not exist
LINE 1: INSERT INTO "user" (name, email, facebook_id, facebook_token...

It seems like the fields aren't matching to those in the database. I'm trying to migrate using flask-migrate but, when I run $ python app.py db migrate I get this error...

raise util.CommandError("No such revision '%s'" % id_)
alembic.util.CommandError: No such revision '39408d6b248d'

It may be best to delete everything and start from scratch as it seems I have botched my database setup and / or migration but I'm not sure how to.

UPDATE: The database has started working now (I dropped and created it again). However, I'm still getting the same error trying to run migrations and it turns out the "no such revision '39408d6b248d' is referring to a migration from an unrelated project. I re-installed flask-migrate but same error.

Answer

Cello Hsueh picture Cello Hsueh · Jun 29, 2014

flask-migrate will create a table named "alembic_version" in your database.
so you should drop this table and delete migrations folder in your project.
and then use $ python app.py db init again...
I think $ python app.py db migrate will work fine.

Related questions

How to write alter column name migrations with sqlalchemy-migrate?

I'm trying to alter a column name. First attempt was with this script: meta = MetaData() users = Table('users', meta, Column('id', Integer, primary_key=True), Column('name', String(50), unique=True), Column('email', String(120), unique=True) ) def upgrade(migrate_engine): meta.…

Read More
How to alter column type from character varying to integer using sqlalchemy-migrate

I'm using sqlalchemy-migrate to alter the type of one of the columns in a table in a Postgre SQL database. The upgrade script I'm using is: # -*- cofing: utf-8 -*- from sqlalchemy import MetaData, Table, Column, String, Integer …

Read More
Can't subtract offset-naive and offset-aware datetimes

I have a timezone aware timestamptz field in PostgreSQL. When I pull data from the table, I then want to subtract the time right now so I can get it's age. The problem I'm having is that both datetime.datetime.…

Read More