记录 sqlalchemy orm 的一个bug

2021-01-06  本文已影响0人  冰_Angus
>>> str(db.session.query(cls))
Out[1]: 'SELECT asset_tmp4test.id, asset_tmp4test.create_time, asset_tmp4test.last_update'

此时没有 Form asset_tmp4test,直接使用with_entities会报错

>>> str(db.session.query(cls).filter_by(status="active")))
Out[4]: 'SELECT asset_tmp4test.id AS asset_tmp4test_id, asset_tmp4test.create_time AS asset_tmp4test_create_time, asset_tmp4test.last_update AS asset_tmp4test_last_update, asset_tmp4test.`status` AS asset_tmp4test_status,  
FROM asset_tmp4test'

加任意filter_by后会有 FROM 语句。

记录一下

上一篇 下一篇

猜你喜欢

热点阅读