On Nov 16, 2010, at 3:56 PM, Alvaro Reinoso wrote:
> Hi all,
>
> I have a problem when querying the database:
>
> This channel class:
>
> class Channel(rdb.Model):
> """Represents both complex channels and trivial ones (media)"""
> rdb.metadata(metadata)
> rdb.tablename("channels")
>
> id = Column("id", Integer, primary_key=True)
> title = Column("title", String(100))
> ....
>
> items = relationship("MediaItem", secondary=channel_items,
> order_by="MediaItem.position", backref="channels")
>
> I get the proper channel object if I do:
>
> channel = session.query(Channel).filter(Channel.title == title)
filter() always returns a Query object, not an instance. So there is no
difference here between the call above and the one on MediaGroup, as far as the
return result being a Query.
>
> And this is my mediaGroup class:
>
> class MediaGroup(rdb.Model):
> """Represents MediaGroup class. Contains channels and other media
> groups"""
> rdb.metadata(metadata)
> rdb.tablename("media_groups")
>
> id = Column("id", Integer, primary_key=True)
> title = Column("title", String(100))
> ....
>
> channels = relationship("Channel", secondary=media_group_channels,
> order_by="Channel.titleView", backref="media_groups")
> mediaGroups = relationship("MediaGroup",
> secondary=media_group_groups, order_by="MediaGroup.title",
> primaryjoin=lambda: MediaGroup.id ==
> media_group_groups.c.media_groupA_id,
> secondaryjoin=lambda: MediaGroup.id ==
> media_group_groups.c.media_groupB_id,
> backref="media_groups")
>
> I get the Query object object if I do:
>
> mediaGroup = session.query(MediaGroup).filter(MediaGroup.title ==
> title)
>
> I don't know if it's because of the relationships but I tried without
> mediaGroups relation, and I didn't work either.
>
> Any idea??
>
> Thanks!
>
> --
> You received this message because you are subscribed to the Google Groups
> "sqlalchemy" group.
> To post to this group, send email to sqlalch...@googlegroups.com.
> To unsubscribe from this group, send email to
> sqlalchemy+unsubscr...@googlegroups.com.
> 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 sqlalch...@googlegroups.com.
To unsubscribe from this group, send email to
sqlalchemy+unsubscr...@googlegroups.com.
For more options, visit this group at
http://groups.google.com/group/sqlalchemy?hl=en.
