python - SQLAlchemy 2.0 NotImplementedError：engine.execute

Question

NotImplementedError: This method is not implemented for SQLAlchemy 2.0.尝试使用deleteSQLAlchemy v1.4.15 中的方法删除表时，我得到一个,。

from sqlalchemy import Column, Integer, MetaData, String, Table, create_engine, delete

engine = create_engine("sqlite+pysqlite:///:memory:", echo=True, future=True)
metadata = MetaData()

user = Table(
    "users", metadata, Column("id", Integer, primary_key=True), Column("name", String)
)

metadata.create_all(engine)

engine.execute(user.delete())  # leading to Traceback
# NotImplementedError: This method is not implemented for SQLAlchemy 2.0.

标签： pythonsqlalchemy

Answer 1

engine.execute在 SQLAlchemy 1.4 中已弃用，并将在 SQLAlchemy 2.0 中删除。您需要改为调用连接的执行方法：

from sqlalchemy import Column, Integer, MetaData, String, Table, create_engine, delete

engine = create_engine("sqlite+pysqlite:///:memory:", echo=True, future=True)
metadata = MetaData()

user = Table(
    "users", metadata, Column("id", Integer, primary_key=True), Column("name", String)
)

metadata.create_all(engine)

stmt = delete(user)
with engine.connect() as conn:
    with conn.begin():   # Optional: start a transaction
        conn.execute(stmt)