[sqlalchemy] Re: Problems when querying the database
Fixed it!
On Nov 22, 10:14 am, Alvaro Reinoso wrote:
> 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 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 sqlalch...@googlegroups.com.
> > > To unsubscribe from this group, send email to
> > > sqlalchemy+unsubscr...@googlegroups.com.
> > > 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 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.
[sqlalchemy] Re: Problems when querying the database
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 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 sqlalch...@googlegroups.com.
> > To unsubscribe from this group, send email to
> > sqlalchemy+unsubscr...@googlegroups.com.
> > 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 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.
