且构网

分享程序员开发的那些事...
且构网 - 分享程序员编程开发的那些事

如何在 Flask-SQLAlchemy 应用程序中执行原始 SQL

更新时间:2023-01-19 23:26:37

您是否尝试过:

result = db.engine.execute("<sql here>")

或:

from sqlalchemy import text

sql = text('select name from penguins')
result = db.engine.execute(sql)
names = [row[0] for row in result]
print names

请注意,db.engine.execute() 是无连接",即 在 SQLAlchemy 2.0 中已弃用.

Note that db.engine.execute() is "connectionless", which is deprecated in SQLAlchemy 2.0.