sqlalchemy反射已经存在的数据库表

from sqlalchemy import create_engine, Table, MetaData
from sqlalchemy.orm import Session
metadata = MetaData()
engine = create_engine(
    'mysql+mysqlconnector://user_name:user_pass@db_ip:3306/database_name',
    echo = True)
# 反射数据库单表
Admin = Table('admin', metadata, autoload=True, autoload_with=engine)
session = Session(engine)

'''反射数据库所有的表
Base = automap_base()
Base.prepare(engine, reflect=True)
Admin = Base.classes.admin
'''

res = session.query(Admin).first()
print(res.id,res.account_text)