CODEWITHSUNDEEP
pythonflaskflask-sqlalchemy
1478963
1478963

Reputation: 1216

SQL Alchemy Flask Delete

If I run the following query:

 a = db.session.query(Submission).filter_by(id=todelid,deletioncode=todelcode).count()

and I print a, it returns 1.

However when I run the following:

db.session.delete(db.session.query(Submission).filter_by(id=todelid,deletioncode=todelcode))

OR

a = db.session.query(Submission).filter_by(id=todelid,deletioncode=todelcode).delete()

it does not delete from the database. How can I make it delete?

Upvotes: 2

Views: 1622

Answers (1)

alecxe
alecxe

Reputation: 474151

Without session.commit() you are actually just marking objects for deletion:

db.session.query(Submission).filter_by(id=todelid,deletioncode=todelcode).delete()
db.session.commit()

Upvotes: 4

Related Questions