From 3d04f8a28386a08a19c01f8154872fcff4936dec Mon Sep 17 00:00:00 2001
From: Frederick Muriuki Muriithi
Date: Sat, 21 Jan 2023 03:18:10 +0300
Subject: auth: Groups - Fetch all existing groups

---
 gn3/auth/authorisation/groups.py | 11 +++++++++++
 1 file changed, 11 insertions(+)

(limited to 'gn3/auth/authorisation/groups.py')

diff --git a/gn3/auth/authorisation/groups.py b/gn3/auth/authorisation/groups.py
index bbabd44..3367b57 100644
--- a/gn3/auth/authorisation/groups.py
+++ b/gn3/auth/authorisation/groups.py
@@ -145,3 +145,14 @@ def is_group_leader(cursor: db.DbCursor, user: User, group: Group):
     role_names = tuple(row[0] for row in cursor.fetchall())
 
     return "group-leader" in role_names
+
+def all_groups(conn: db.DbConnection) -> Maybe[Sequence[Group]]:
+    """Retrieve all existing groups"""
+    with db.cursor(conn) as cursor:
+        cursor.execute("SELECT * FROM groups")
+        res = cursor.fetchall()
+        if res:
+            return Just(tuple(
+                Group(row["group_id"], row["group_name"]) for row in res))
+
+    return Nothing
-- 
cgit v1.2.3