diff options
author | Munyoki Kilyungi | 2024-03-21 10:10:46 +0300 |
---|---|---|
committer | Munyoki Kilyungi | 2024-03-21 10:19:19 +0300 |
commit | ccd4ee5405f6a302283bac80dee15919dd3c6ffe (patch) | |
tree | 586921c94b09267b04d1bef598157d634d37249f /gn_auth/auth/authorisation/resources/models.py | |
parent | 7107b2b99058835bf0115955c3e79c23f9fb6bc9 (diff) | |
download | gn-auth-ccd4ee5405f6a302283bac80dee15919dd3c6ffe.tar.gz |
Add extra endpoint to get user authorisation given a resource name.
* gn_auth/auth/authorisation/resources/models.py
(user_roles_on_resources): New function.
* gn_auth/auth/authorisation/resources/views.py
(resources_authorisation): New endpoint.
Signed-off-by: Munyoki Kilyungi <me@bonfacemunyoki.com>
Diffstat (limited to 'gn_auth/auth/authorisation/resources/models.py')
-rw-r--r-- | gn_auth/auth/authorisation/resources/models.py | 11 |
1 files changed, 11 insertions, 0 deletions
diff --git a/gn_auth/auth/authorisation/resources/models.py b/gn_auth/auth/authorisation/resources/models.py index 8bd8c73..60d24ff 100644 --- a/gn_auth/auth/authorisation/resources/models.py +++ b/gn_auth/auth/authorisation/resources/models.py @@ -420,3 +420,14 @@ def user_roles_on_resources(conn: db.DbConnection, with db.cursor(conn) as cursor: cursor.execute(query, params) return reduce(__organise__, cursor.fetchall(), {}) + + +def get_resource_id(conn: db.DbConnection, name: str) -> Optional[str]: + """Given a resource_name, return it's resource_id.""" + with db.cursor(conn) as cursor: + cursor.execute( + "SELECT resource_id \ +FROM resources as r WHERE r.resource_name=?", (name, )) + if res := cursor.fetchone(): + return res["resource_id"] + return None |