1.如何建表(增删改查)
2.如何对已存在的表进行增删改查
采用映射数据库的方法操作已存在的表，需要使用automap_base函数。
from sqlalchemy import create_engine from sqlalchemy.ext.automap import automap_base from sqlalchemy.orm import sessionmaker uri = ‘mysql://root:mysql@127.0.0.1:3306/flasknews‘ engine = create_engine(uri, echo=False) Base = automap_base() Base.prepare(engine, reflect=True) # 获取表对象 table_student = Base.classes.students#映射到students表 Session = sessionmaker(bind=engine) session = Session() #----------添加数据 def add(): session.add(table_student(name="hello791")) session.commit() def query(): data=session.query(table_student).filter(table_student.id>=2).all() for name in data: print(name.name) if __name__ == ‘__main__‘: # add() query()
engine = create_engine(uri, echo=False)
metadata = MetaData(engine)
table1 = Table("students", metadata, autoload=True)#查找数据库中的表students
session = Session(bind=engine)
a = session.query(table1).first()#查找表中的第一条记录
原文：https://www.cnblogs.com/xuehaiwuya0000/p/11143078.html