aboutsummaryrefslogtreecommitdiff
path: root/gn3/auth/authorisation/resources
diff options
context:
space:
mode:
authorFrederick Muriuki Muriithi2023-05-25 19:11:49 +0300
committerFrederick Muriuki Muriithi2023-05-25 19:11:49 +0300
commit256f13f675c60547b10a06736f0a7cb3faf752d5 (patch)
tree3e5a29212de06312424b521055a5f17e9e9dc79b /gn3/auth/authorisation/resources
parent8593d882ed1eea226eeefabaa66135df2374746f (diff)
downloadgenenetwork3-256f13f675c60547b10a06736f0a7cb3faf752d5.tar.gz
Script to assign existing data to publicly-visible resources
A script to assign existing data not assigned to any group to publicly-visible resources.
Diffstat (limited to 'gn3/auth/authorisation/resources')
-rw-r--r--gn3/auth/authorisation/resources/models.py4
1 files changed, 3 insertions, 1 deletions
diff --git a/gn3/auth/authorisation/resources/models.py b/gn3/auth/authorisation/resources/models.py
index 2016960..5ff5983 100644
--- a/gn3/auth/authorisation/resources/models.py
+++ b/gn3/auth/authorisation/resources/models.py
@@ -57,7 +57,9 @@ def __assign_resource_owner_role__(cursor, resource, user):
"""Assign `user` the 'Resource Owner' role for `resource`."""
cursor.execute(
"SELECT gr.* FROM group_roles AS gr INNER JOIN roles AS r "
- "ON gr.role_id=r.role_id WHERE r.role_name='resource-owner'")
+ "ON gr.role_id=r.role_id WHERE r.role_name='resource-owner' "
+ "AND gr.group_id=?",
+ (str(resource.group.group_id),))
role = cursor.fetchone()
if not role:
cursor.execute("SELECT * FROM roles WHERE role_name='resource-owner'")