models: User, Show, Episode
Show 1-----n Episode
User n------n Show
so: shows can have multiple episodes and different users can have
different shows
I want to construct a query that will:
- check if episode dates to specific date
- join all shows on that episode
- filter out shows that are not bound to specific user
the query that is not working correctly is:
AShow = aliased(Show)
q = s.query(Episode, AShow)\
.filter(Episode.airdate.between(date1, date2))\
.filter(User.userID == 2)\
.join(User.relShows)\
.join(AShow)
(User.relShows is the n-n relation to Shows that lists all shows which
one user posseses)
If I haven't explained myself enough, please say so. I have no idea
where I'm failing:)
--~--~---------~--~----~------------~-------~--~----~
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
-~----------~----~----~----~------~----~------~--~---
