使用sqlalchemy查询mysql数据库里的数据

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
from sqlalchemy import create_engine,MetaData,Table
# from sqlalchemy.sql import select
from sqlalchemy.ext.automap import automap_base
from sqlalchemy.orm import sessionmaker

engine_mysql=create_engine('mysql://root:pwd@localhost:3306/test')
# metadata=MetaData()
# connection=engine_mysql.connect()

# tb_order=Table('tb_order',metadata,autoload=True,autoload_with=engine_mysql)
# metadata.reflect(bind=engine_mysql)
# tb_order=metadata.tables.get('tb_order')
# s=select('*').select_from(tb_order)
# print(str(s))
# rp=connection.execute(s)
# print(rp)
# results=rp.fetchall()
# print(results)

Base=automap_base()
Base.prepare(engine_mysql,reflect=True)
bt_tasks=Base.classes.bt_tasks
Session=sessionmaker(bind=engine_mysql)
session=Session()
row=session.query(bt_tasks).filter(bt_tasks.id==2)
print(row.one().name)

https://www.cnblogs.com/lilied/p/17698017.html sqlalchemy简单操作(创建表，反射表)

https://www.jb51.net/article/197296.htm Python SQLAlchemy库的使用方法

一次性反映所有表¶

sqlalchemy 操作mysql反射已有表

创建于2404261840，修改于2410231554