Hello everyone!
In my application I have a class "Store" that can contain several
"UserGroup"s (for permission purposes) and one "UserGroup" can belong
to several "Stores".
I want to get the "Stores" that contain a certain "UserGroup" (instance):
I have it modeled like this:
class Store(declarativeBase):
__tablename__ = "stores"
_id = Column("id", Integer, primary_key=True)
_name = Column("name", String(50))
_number = Column("number", Integer)
_storeGroupId = Column("store_group_id", Integer,
ForeignKey("store_groups.id"))
# _devices: Backref from Device
_userGroups = relationship("UserGroup", secondary=user_group_store,
order_by=lambda:UserGroup.UserGroup.name,
primaryjoin=lambda: Store.id == user_group_store.c.store_id,
secondaryjoin=lambda: UserGroup.UserGroup.id ==
user_group_store.c.user_group_id,
collection_class=set
)
And:
class UserGroup(declarativeBase):
__tablename__ = "user_groups"
_id = Column("id", Integer, primary_key=True)
_name = Column("name", String(50))
#_users: Backref from User
I want to create a method (something like
getStoresByUserGroup(userGroup) ) that accepts a userGroup instance
(or id) and returns only the stores that contain that "userGroup".
That should allow me to "hide" certain stores for certain user groups.
The use case is: The user who is currently logged into my application
will belong to a certain user group. If he wants to access the
"stores" stored in the database, he will only see the ones that have
that user's userGroup among the Store._userGroups set.
I'm trying to join the Store with the UserGroup, but then I get:
"Can't find any foreign key relationships between 'stores' and
'%(175967212 user_groups)s
I'm also trying to use alias, but without any luck so far.
Do you have any idea, hint... Whatever. I'm kind of lost here. I keep
trying things without knowing very well what I'm doing.
Thank you in advance
--
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.
