Marcin Krol wrote:
> Hello,
>
>
> rsvs = session.query(Reservation).filter(Reservation.email ==
> em).filter(Reservation.newhosts == []
> ).options(eagerload('newhosts')).all()
>
> sqlalchemy.exc.InvalidRequestError: Can't compare a collection to an
> object or collection; use contains() to test for membership.
>
> Well I can always do:
>
> rsvs = session.query(Reservation).filter(Reservation.email ==
> em).options(eagerload('newhosts')).all()
>
>
> for r in rsvs:
> if r.newhosts != []:
> print r.id, 'newhosts', r.newhosts
>
> or
>
> for r in rsvs:
> if r.newhosts == []:
> print r.id, 'newhosts', r.newhosts
>
>
> But, that's ugly like. So, the question is, is it possible to query for
> empty or non-empty collection?
use a blank any() for that. filter(Reservation.newhosts.any()) /
filter(~Reservation.newhosts.any())
>
> Regards,
> mk
>
> --
>
> You received this message because you are subscribed to the Google Groups
> "sqlalchemy" group.
> To post to this group, send email to [email protected].
> To unsubscribe from this group, send email to
> [email protected].
> For more options, visit this group at
> http://groups.google.com/group/sqlalchemy?hl=en.
>
>
>
--
You received this message because you are subscribed to the Google Groups
"sqlalchemy" group.
To post to this group, send email to [email protected].
To unsubscribe from this group, send email to
[email protected].
For more options, visit this group at
http://groups.google.com/group/sqlalchemy?hl=en.
