So what do you suggest to get the instance by title? I can query the database by title to get the id and then query again to get the instance by id. What do you think?
On Nov 17, 1:10 pm, Michael Bayer <[email protected]> wrote: > 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 [email protected]. > > To unsubscribe from this group, send email to > > [email protected]. > > For more options, visit this group > > athttp://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.
