在python中使用多个值调用sqlalchemy中的exists()

from sqlalchemy import exists, select
from sqlalchemy.orm import sessionmaker
from sqlalchemy.ext.declarative import declarative_base

# 创建数据库连接
engine = create_engine('数据库连接字符串')
Session = sessionmaker(bind=engine)
session = Session()

# 创建基类
Base = declarative_base()

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

# 创建子查询
subquery = select([exists().where(User.id.in_([1, 2, 3]))])

# 使用any_()函数传递多个值给exists()函数
query = session.query(User).filter(User.name == 'John').filter(subquery.any_())

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

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

# 关闭数据库连接
session.close()