[sqlalchemy] Problems when querying the database

[Alvaro Reinoso]

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)

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.