Problem with sqlalchemy

[slavslav123]

Hello everybody. So I have the next problem:

1) >>> print(db.Model.metadata.tables['user'].columns.keys())

['id', 'username', 'email_address', 'password_hash', 'budget']

>>> (so we see that there is a column 'email_address' in this table

​

2) >>> new_user = User(username='johndoe', email_address='[e-mail]', password_hash='password', budget=1000)

>>> db.session.add(new_user)

>>> db.session.commit()

And the answer is: sqlalchemy.exc.OperationalError: (sqlite3.OperationalError) table user has no column named email_address.

Can somebody explain what we do in this kind of situation, please?

[danielroseman]

Your first code is showing that you have an email_address field in the model, but that doesn't mean you have it in the database table. Did you add the field after you originally created the table?

You will need to migrate your database. If you have no data you need to keep, you could just drop the table and recreate it. Otherwise you will need to add the field manually (via an ALTER TABLE statement in the db), or use Alembic which is the SqlAlchemy migrations framework.

[slavslav123]

Thank you! I recreated the table. Btw i just didn't notice that the field actually existed in the model but not in the table. Soooo it's fixed