python - flask_sqlalchemy生成的sql不正确

Question

这是我的代码

today_user = db.session.execute("""select sum(money) from tb_recharge where state = 1 and date_format(create_time,'%Y') = '2021'""")

输出结果

2021-03-25 16:43:17,070 INFO sqlalchemy.engine.base.Engine SHOW VARIABLES LIKE 'sql_mode'
2021-03-25 16:43:17,070 INFO sqlalchemy.engine.base.Engine ()
2021-03-25 16:43:17,077 INFO sqlalchemy.engine.base.Engine SHOW LIKE 'lower_case_table_names'
2021-03-25 16:43:17,077 INFO sqlalchemy.engine.base.Engine ()
2021-03-25 16:43:17,091 INFO sqlalchemy.engine.base.Engine SELECT DATABASE()
2021-03-25 16:43:17,092 INFO sqlalchemy.engine.base.Engine ()
2021-03-25 16:43:17,104 INFO sqlalchemy.engine.base.Engine show collation where `Charset` = 'utf8mb4' and `Collation` = 'utf8mb4_bin'
2021-03-25 16:43:17,105 INFO sqlalchemy.engine.base.Engine ()
2021-03-25 16:43:17,112 INFO sqlalchemy.engine.base.Engine SELECT CAST('test plain returns' AS CHAR(60)) AS anon_1
2021-03-25 16:43:17,112 INFO sqlalchemy.engine.base.Engine ()
2021-03-25 16:43:17,119 INFO sqlalchemy.engine.base.Engine SELECT CAST('test unicode returns' AS CHAR(60)) AS anon_1
2021-03-25 16:43:17,119 INFO sqlalchemy.engine.base.Engine ()
2021-03-25 16:43:17,130 INFO sqlalchemy.engine.base.Engine SELECT CAST('test collated returns' AS CHAR CHARACTER SET utf8mb4) COLLATE utf8mb4_bin AS anon_1
2021-03-25 16:43:17,131 INFO sqlalchemy.engine.base.Engine ()
2021-03-25 16:43:17,153 INFO sqlalchemy.engine.base.Engine BEGIN (implicit)
2021-03-25 16:43:17,154 INFO sqlalchemy.engine.base.Engine select sum(money) from tb_recharge 
                where state = 1 and date_format(create_time,'%%Y') = '2021'
2021-03-25 16:43:17,154 INFO sqlalchemy.engine.base.Engine ()
2021-03-25 16:43:17,352 INFO sqlalchemy.engine.base.Engine ROLLBACK

我希望date_format(create_time,'%Y') = '2021'但是date_format(create_time,'%%Y') = '2021'。

标签： pythonsqlsqlalchemy