From 6fb63b348f77d4cce29278cf06191a11a3b6d95d Mon Sep 17 00:00:00 2001
From: Frederick Muriuki Muriithi
Date: Wed, 2 Aug 2023 10:27:10 +0300
Subject: Remove ORM-dependent `insert` function

Remove the object-relation-mapping dependent `insert` function to prevent it
being used in the code down the line.
---
 gn3/db/__init__.py | 16 ----------------
 1 file changed, 16 deletions(-)

(limited to 'gn3')

diff --git a/gn3/db/__init__.py b/gn3/db/__init__.py
index 5676eb5..95b39d4 100644
--- a/gn3/db/__init__.py
+++ b/gn3/db/__init__.py
@@ -63,22 +63,6 @@ def update(conn: Any,
         conn.commit()
         return cursor.rowcount
 
-def insert(conn: Any,
-           table: str,
-           data: Dataclass) -> Optional[int]:
-    """Run an INSERT into a table"""
-    dict_ = {TABLEMAP[table].get(k): v for k, v in asdict(data).items()
-             if v is not None and k in TABLEMAP[table]}
-    sql = f"INSERT INTO {table} ("
-    sql += ", ".join(f"{k}" for k in dict_.keys())
-    sql += ") VALUES ("
-    sql += ", ".join("%s" for _ in dict_.keys())
-    sql += ")"
-    with conn.cursor() as cursor:
-        cursor.execute(sql, tuple(dict_.values()))
-        conn.commit()
-        return cursor.rowcount
-
 
 def diff_from_dict(old: Dict, new: Dict) -> Dict:
     """Construct a new dict with a specific structure that contains the difference
-- 
cgit v1.2.3