Hi,
New with SQLalchemy, here is my problem:
My model is:
user_group_association_table = Table('user_group_association',
Base.metadata,
Column('user_id', Integer, ForeignKey('user.id')),
Column('group_id', Integer, ForeignKey('group.id'))
)
department_group_association_table =
Table('department_group_association', Base.metadata,
Column('department', Integer, ForeignKey('department.id')),
Column('group_id', Integer, ForeignKey('group.id'))
)
class Department(Base):
__tablename__ = 'department'
id = Column(Integer, primary_key=True)
name = Column(String(50))
class Group(Base):
__tablename__ = 'group'
id = Column(Integer, primary_key=True)
name = Column(String)
users = relationship("User",
secondary=user_group_association_table, backref="groups")
departments = relationship("Department",
secondary=department_group_association_table, backref="groups")
class User(Base):
__tablename__ = 'user'
id = Column(Integer, primary_key=True)
firstname = Column(String(50))
surname = Column(String(50))
So, this code reflects the following relationships:
-------- --------- --------------
| User | --- N:M --- | Group | --- N:M --- | Department |
-------- --------- --------------
I tried to work with joins but still not succeeded in doing the
following :
One sqlalchemy request to get all the users instances while knowing a
departement name (let's say 'R&D")
This should start with:
session.query(User).join(...
or
session.query(User).options(joinedLoad(...
Anyone could help ?
Thanks for your time,
Pierre
--
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.
