I can query my Seat
table for all seats where there is no invite assigned:
seats = Seat.query.filter_by(invite=None).all()
However, when querying for all seats that have an invite assigned, I get a NameError
:
seats = Seat.query.filter_by(invite!=None).all()
NameError: name 'invite' is not defined
Here is my Seat
class:
class Seat(db.Model): id = db.Column(db.Integer, primary_key=True) invite_id = db.Column(db.Integer, db.ForeignKey('invite.id')) invite = db.relationship('Invite', backref=db.backref('folks', lazy='dynamic'))
How can I query for all seats where the owner is not blank?
The filter_by()
method takes a sequence of keyword arguments, so you always have to use =
with it.
You want to use the filter()
method which allows for !=
:
seats = Seat.query.filter(Seat.invite != None).all()
I think this can help http://docs.sqlalchemy.org/en/rel_0_9/core/sqlelement.html#sqlalchemy.sql.operators.ColumnOperators.isnot
query.filter(User.name == None)
or alternatively, if pep8/linters are a concernquery.filter(User.name.is_(None))
query.filter(User.name != None)
or alternatively, if pep8/linters are a concern query.filter(User.name.isnot(None))
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