Hello everyone: Let's say I have a class "User" and a class "UserGroup". One user can belong to one userGroup, an a userGroup can contain several users (pretty typical structure). It's a simple relationship I got modeled like:
class UserGroup(declarativeBase): """Represents a group of users with the same features""" __tablename__ = "user_groups" id = Column("id", Integer, primary_key=True) name = Column("name", String(50)) users = relationship("User", order_by=lambda:User.userName, cascade="all, delete", collection_class=set) class User(declarativeBase): """Represents a user""" __tablename__ = "users" id = Column("id", Integer, primary_key=True) firstName = Column("first_name", String(50)) lastName = Column("last_name", String(50)) email = Column("email", String(60)) userName = Column("user_name", String(50), unique=True, nullable=False) password = Column("password", String(64), nullable=False) userGroupId = Column("user_group_id", Integer, ForeignKey("user_groups.id")) userGroup = relationship("UserGroup", uselist=False) I am working in a tool that accepts generic queries, and, basically, I can do something like: session.query(User.User).filter(User.User.id > 3).values("userName") And get tuples with a .userName field with all the userNames of the users whose id is > 3 But if I try: session.query(User.User).filter(User.User.id > 3).values("userGroup") I get an error: OperationalError: (OperationalError) (1054, "Unknown column 'userGroup' in 'field list'") 'SELECT userGroup' () session.query(User.User).filter(User.User.id > 3).values("userGroup") I have also tried: session.query(User.User.userGroup).filter(User.User.id >= 3).all() but, doing this, I get all the user information, not the userGroup So here's the question: Is there any way of getting the "userGroup" value somehow "starting" (or querying) User objects? (or what would be the best way, if there are many ways) Thank you! -- You received this message because you are subscribed to the Google Groups "sqlalchemy" group. To post to this group, send email to sqlalchemy@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.