组合2个sqlalchemy查询和排序

from sqlalchemy import create_engine, Column, Integer, String
from sqlalchemy.orm import sessionmaker
from sqlalchemy.ext.declarative import declarative_base

# 创建数据库引擎和会话
engine = create_engine('mysql+pymysql://username:password@localhost/database')
Session = sessionmaker(bind=engine)
session = Session()

# 创建基础模型类
Base = declarative_base()

# 定义模型类
class User(Base):
    __tablename__ = 'users'
    id = Column(Integer, primary_key=True)
    name = Column(String(50))
    age = Column(Integer)

# 创建查询1
query1 = session.query(User).filter(User.age > 18)

# 创建查询2
query2 = session.query(User).filter(User.name.like('John%'))

# 组合查询并排序
combined_query = query1.union(query2).order_by(User.age.desc())

# 执行查询
results = combined_query.all()

# 输出结果
for user in results:
    print(user.name, user.age)