1 files changed, 8 insertions, 0 deletions
diff --git a/uploader/species/models.py b/uploader/species/models.py
index 53e7de0..cea3549 100644
--- a/uploader/species/models.py
+++ b/uploader/species/models.py
@@ -81,3 +81,11 @@ def save_species(conn: mdb.Connection,
             **species,
             "species_id": species_id
         }
+
+
+def species_families(conn: mdb.Connection) -> tuple:
+    """Retrieve the families under which species are grouped."""
+    with conn.cursor(cursorclass=DictCursor) as cursor:
+        cursor.execute(
+            "SELECT DISTINCT(Family) FROM Species WHERE Family IS NOT NULL")
+        return tuple(fam["Family"] for fam in cursor.fetchall())