diff options
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 |