there's an isnot() operator, use that
On Apr 14, 2014, at 7:17 PM, Jonathan Vanasco <jonat...@findmeon.com> wrote:
> 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.
--
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.
