Flask SQLAlchemy 批量删除记录

Flask SQLAlchemy 是一个功能强大的 Python 框架，用于与数据库进行交互。在实际开发中，我们经常需要批量删除数据库中的记录。本文将介绍如何使用 Flask SQLAlchemy 进行批量删除，并提供一个案例代码来帮助读者更好地理解。

python
from flask_sqlalchemy import SQLAlchemy
db = SQLAlchemy()
class User(db.Model):
    __tablename__ = 'users'
    id = db.Column(db.Integer, primary_key=True)
    name = db.Column(db.String(50))
    email = db.Column(db.String(50))

python
from flask import Flask
from flask_sqlalchemy import SQLAlchemy
app = Flask(__name__)
app.config['SQLALCHEMY_DATABASE_URI'] = 'sqlite:///example.db'
db = SQLAlchemy(app)
class User(db.Model):
    __tablename__ = 'users'
    id = db.Column(db.Integer, primary_key=True)
    name = db.Column(db.String(50))
    email = db.Column(db.String(50))
@app.route('/delete_users')
def delete_users():
    users_to_delete = User.query.filter_by(name='John').all()
    db.session.delete_all(users_to_delete)
    db.session.commit()
    return 'Users deleted successfully'
if __name__ == '__main__':
    app.run()