使用Flask对SQLAlchemy中的布尔列进行排序

from flask import Flask, request
from sqlalchemy import create_engine, Column, Boolean
from sqlalchemy.orm import sessionmaker
from sqlalchemy.ext.declarative import declarative_base

app = Flask(__name__)
engine = create_engine('数据库连接字符串')
Session = sessionmaker(bind=engine)
Base = declarative_base()

class MyModel(Base):
    __tablename__ = 'my_table'
    id = Column(Integer, primary_key=True)
    boolean_column = Column(Boolean)

@app.route('/sort', methods=['GET'])
def sort_boolean_column():
    sort_order = request.args.get('order', 'asc')  # 获取排序顺序，默认为升序
    session = Session()
    if sort_order == 'asc':
        results = session.query(MyModel).order_by(MyModel.boolean_column.asc()).all()
    else:
        results = session.query(MyModel).order_by(MyModel.boolean_column.desc()).all()
    session.close()
    return '排序结果：' + str(results)

if __name__ == '__main__':
    app.run()