sqlalchemy中具有limit的连接表

from sqlalchemy import create_engine, Column, Integer, String
from sqlalchemy.orm import sessionmaker
from sqlalchemy.ext.declarative import declarative_base
from sqlalchemy.sql import select
from sqlalchemy.sql.expression import join

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

# 创建基类
Base = declarative_base()

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

class Order(Base):
    __tablename__ = 'orders'
    id = Column(Integer, primary_key=True)
    user_id = Column(Integer)

# 创建连接表查询
query = select([User, Order]).select_from(join(User, Order, User.id == Order.user_id)).limit(10)

# 执行查询并打印结果
result = session.execute(query)
for row in result:
    print(row)

# 关闭会话
session.close()