How to delete a record by id in Flask-SQLAlchemy

by

You can do this,

User.query.filter_by(id=123).delete()

or

User.query.filter(User.id == 123).delete()

Make sure to commit for delete() to take effect.

More Related Contents:

  1. How to execute raw SQL in Flask-SQLAlchemy app
  2. jsonify a SQLAlchemy result set in Flask [duplicate]
  3. How to build a flask application around an already existing database?
  4. Flask sqlalchemy many-to-many insert data
  5. Get inserted key before commit session
  6. Querying with function on Flask-SQLAlchemy model gives BaseQuery object is not callable error
  7. AttributeError: ‘int’ object has no attribute ‘_sa_instance_state’
  8. Getting first row from sqlalchemy
  9. flask-sqlalchemy or sqlalchemy
  10. Flask-SQLAlchemy Constructor
  11. SQLAlchemy ordering by count on a many to many relationship
  12. flask sqlalchemy query with keyword as variable
  13. Flask SQLAlchemy query, specify column names
  14. Flask-SQLAlchemy import/context issue
  15. AttributeError: can’t set attribute when connecting to sqlite database with flask-sqlalchemy
  16. Case Insensitive Flask-SQLAlchemy Query
  17. Flask-SQLalchemy update a row’s information
  18. Flask Download a File
  19. Implementing Flask-Login with multiple User Classes
  20. Updates to JSON field don’t persist to DB
  21. Is a SQLAlchemy query vulnerable to injection attacks?
  22. Flask-SQLAlchemy db.create_all() raises RuntimeError working outside of application context
  23. ImportError: No module named flaskext.sqlalchemy
  24. sqlalchemy.exc.NoSuchModuleError: Can’t load plugin: sqlalchemy.dialects:postgres
  25. ImportError: No module named sqlalchemy
  26. Using SQLAlchemy models in and out of Flask
  27. Flask, SQLAlchemy : KeyError: ‘SQLALCHEMY_TRACK_MODIFICATIONS’
  28. Which SQLAlchemy column type should be used for binary data?
  29. Retrieve query results as dict in SQLAlchemy
  30. Tyring to set up modelview with Flask-Admin causes ImportError

Leave a Comment