Fastapi sqlalchemy DBApi 直接使用sql语句

with engine.connect() as conn:
    conn.execute(text("insert into teacher(user_id, name, subject) values(:a,:b,:c)"), [{"a": "88888888", "b": "叭叭叭巴巴爸爸", "c": "科目"}])

    conn.commit()

    result = conn.execute(text("select * from users"))
    teachers = result.cursor.fetchall()
    return {"teachers": teachers}

 

#更新字典
 statement = select(Teachers)
 teachers = session.exec(statement).all()
 resultset = []
 for row in teachers:
 resultset.append(dict(row))
 for r in resultset:
     r['test'] = '测试内容'