Sqlalchemy打印查询的输出对象

from sqlalchemy import create_engine, MetaData, Table, Column, Integer, String, select

# 创建数据库引擎
engine = create_engine('mysql://username:password@localhost/dbname')

# 创建表的元数据
metadata = MetaData(bind=engine)

# 定义表结构
users = Table('users', metadata,
              Column('id', Integer, primary_key=True),
              Column('name', String),
              Column('age', Integer)
              )

# 创建查询对象
query = select([users])

# 执行查询并获取结果
result = engine.execute(query)

# 打印输出对象
for row in result:
    print(row)

# 关闭数据库连接
engine.dispose()