I'm on postgres and have a boolean column that allows NULL values.
I need to create a relationship between 2 ORM classes , where there is a
filter that states "IS NOT TRUE".
The ORM likes these 2 commands :
photo = sa.orm.relationship("Photo", primaryjoin="and_(
Useraccount.photo_id==Photo.id , Photo.is_deletion_scheduled != True )")
photo = sa.orm.relationship("Photo", primaryjoin="and_(
Useraccount.photo_id==Photo.id , Photo.is_deletion_scheduled <> True )")
however they don't compare correct in Postgresql. I need this to work,
however the mapper doesn't like it:
photo = sa.orm.relationship("Photo", primaryjoin="and_(
Useraccount.photo_id==Photo.id , Photo.is_deletion_scheduled IS NOT True )")
if I were doing a column comparison, I would do
Photo.is_deletion_scheduled.op('IS NOT')(True)
anyone have an idea ?
--
You received this message because you are subscribed to the Google Groups
"sqlalchemy" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to sqlalchemy+unsubscr...@googlegroups.com.
To post to this group, send email to sqlalchemy@googlegroups.com.
Visit this group at http://groups.google.com/group/sqlalchemy.
For more options, visit https://groups.google.com/d/optout.
