From b2e870ccb3cd82f8ba28a578144c20fa6a636221 Mon Sep 17 00:00:00 2001
From: Frederick Muriuki Muriithi
Date: Tue, 7 Apr 2026 13:53:21 -0500
Subject: Handle edge case where no admins exist: e.g. database is empty.

---
 ...20260402_01_Bf8nm-add-user-and-time-tracking-to-resources-table.py | 4 +++-
 1 file changed, 3 insertions(+), 1 deletion(-)

diff --git a/migrations/auth/20260402_01_Bf8nm-add-user-and-time-tracking-to-resources-table.py b/migrations/auth/20260402_01_Bf8nm-add-user-and-time-tracking-to-resources-table.py
index fd1e617..702c418 100644
--- a/migrations/auth/20260402_01_Bf8nm-add-user-and-time-tracking-to-resources-table.py
+++ b/migrations/auth/20260402_01_Bf8nm-add-user-and-time-tracking-to-resources-table.py
@@ -38,7 +38,9 @@ def fetch_a_sysadmin_id(conn, resources_table):
             return tuple(row[0] for row in cursor.fetchall())
 
     if not bool(__admin_id__):
-        __admin_id__ = random.choice(__fetch__())
+        __admins__ = __fetch__()
+        if len(__admins__) > 0:
+            __admin_id__ = random.choice(__admins__)
 
     return __admin_id__
 
-- 
cgit 1.4.1