How to delete or modify a database table using Flask-SQLAlchemy?

Question

Is there a way to delete or modify a table using flask-sqlalchemy?

I am working on a Flask-based web app. I switched to flask-sqlalchemy as my project is on Heroku and I had to connect my table to Heroku PostgreSQL. I made a flask-sqlalchemy table and created it using the db.create_all() command.

Now, for my app to fulfill its purpose, it is of utmost importance to save images, the best way of which I found to be to add them to the database.

Now, I want to change the particular table class to store a column called image as image = db.Column(db.Text, nullable=False) but I cannot. The former schema is unchanged and it gives me an error signifying that the column image does not exist every time I try to access or add something to the table.

How to do this?

Remember that SqlAlchemy is not a database. It's just a database adapter. You can always use the psql command line to work directly with your tables. — Tim Roberts
– Tim Roberts, Commented Nov 19, 2021 at 6:27
Welcome to Stack Overflow. Please read Under what circumstances may I add "urgent" or other similar phrases to my question, in order to obtain faster answers? (TL;DR: It's never okay.) — Chris
– Chris, Commented Nov 22, 2021 at 22:42

Ammar Aslam · Accepted Answer · 2021-11-19 09:01:03Z

1

You can use drop()

from sqlalchemy import create_engine
engine = create_engine("...")
my_table.__table__.drop(engine)

answered Nov 19, 2021 at 9:01

Ammar Aslam

6704 silver badges17 bronze badges

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

2 Comments

Tim Roberts Over a year ago

This is really the right answer. Will SqlAlchemy recreate the table in its new form next time it runs?

Ammar Aslam Over a year ago

No.. you might need to look into migrations for that

Collectives™ on Stack Overflow

How to delete or modify a database table using Flask-SQLAlchemy?

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related