Menu
I'm having trouble figuring out how to do a "greater than or equal to" comparison in a query.
I have a model field:
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 What is the correct syntax for a greater than or equal filter in sqlalchemy or flask-sqlalchemy?
620
The operator used for not equals is !=
Implementing alias in SQLAlchemy SQL alias is a method of giving a temporary name for a table that is more convenient and readable. SQL alias facilitates a simple name to be used in place of a complex table name when it has to be used multiple times in a query.
_sa_instance_state is a non-database-persisted value used by SQLAlchemy internally (it refers to the InstanceState for the instance. While not directly relevant to this section, if we want to get at it, we should use the inspect() function to access it).
The sqlalchemy backref is one of the type keywords and it passed as the separate argument parameters which has to be used in the ORM mapping objects. It mainly includes the event listener on the configuration attributes with both directions of the user datas through explicitly handling the database relationships.
You want filter, not filter_by:
Invoice.query.filter(Invoice.invoicedate >= date.today()) See this answer for more on filter vs filter_by
59
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
