Flask-SQLAlchemy-大于或等于 [英] Flask-SQLAlchemy - Greater than or equal to

问题描述

我在弄清楚如何在查询中进行大于或等于"比较时遇到了麻烦.

I'm having trouble figuring out how to do a "greater than or equal to" comparison in a query.

我有一个模型字段:

invoicedate = db.Column(db.Date(), nullable=True, key='InvoiceDate')

我正在尝试进行以下过滤:

And i'm trying to do the following filter:

Invoice.query.filter_by(invoicedate >= date.today()).count()

运行视图时，它会不断抛出以下错误:

When I run the view, it keeps throwing the following error:

NameError: global name 'invoicedate' is not defined

在sqlalchemy或flask-sqlalchemy中大于或等于过滤器的正确语法是什么?

What is the correct syntax for a greater than or equal filter in sqlalchemy or flask-sqlalchemy?

推荐答案

您要的是filter，而不是filter_by:

Invoice.query.filter(Invoice.invoicedate >= date.today())

有关更多信息，请参见此答案在filter与filter_by

See this answer for more on filter vs filter_by

这篇关于Flask-SQLAlchemy-大于或等于的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！