python - 插入表时处理 SQLAlchemy 中的触发器

Question

我已经使用flask-SQLAlchemy 映射数据库中名为Proposal 的表之一，但在从应用程序插入数据库时​​遇到了问题。这是错误:

sqlalchemy.exc.ProgrammingError: (pyodbc.ProgrammingError) ('42000', "[42000]

[Microsoft][ODBC SQL Server Driver][SQL Server]The target table 'Proposal' of
the DML statement cannot have any enabled triggers if the statement contain an
OUTPUT clause without INTO clause. (334) (SQLExecDirectW); [42000] [Microsoft]
[ODBC SQL Server Driver][SQL Server]Statement(s) could not be prepared

数据库是MSSQL类型。

SQLAlchemy生成的sql语句为

SQL: 'INSERT INTO [Proposal] (proposal_fee, contract1, contract,
proposal_disb, source, sid, value_per_hr, team_hrs, reason_for_loss,
incharge, [Country_id], [manner], [Manager_id], preparer_id,
task_id, date_received, proposal_deadline, industry_id,
proposal_currency_id, contract_currency_id, service_description_id,
business_unit_id, status_id, associated_cost) OUTPUT inserted.[ID] VALUE
(?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)']
[parameters: ('', '', '', '', '', 'None', '', '', None, 'Adv,
Office', 'Select Country', None, 'ABCD', 'some name', '1007000', '', '', '', '', 'usd', None, None, '', '')]

我知道当我禁用触发器时，插入将起作用，但我需要 sqlalchemy 中的一个解决方案来解决这个问题？

有什么办法吗？

Answer 1

我意识到我必须删除该输出子句，并找到了推荐使用的解决方案:

__table_args__ = {'implicit_returning':False}

为提案表创建类时。