From 6ab6d46ab4b1611ed72bdbce85cf9324ce69b305 Mon Sep 17 00:00:00 2001
From: Frederick Muriuki Muriithi
Date: Mon, 7 Aug 2023 07:47:01 +0300
Subject: Collect db-connections function in single module.

---
 gn_auth/auth/db.py | 78 ------------------------------------------------------
 1 file changed, 78 deletions(-)
 delete mode 100644 gn_auth/auth/db.py

(limited to 'gn_auth/auth/db.py')

diff --git a/gn_auth/auth/db.py b/gn_auth/auth/db.py
deleted file mode 100644
index 2ba6619..0000000
--- a/gn_auth/auth/db.py
+++ /dev/null
@@ -1,78 +0,0 @@
-"""Handle connection to auth database."""
-import sqlite3
-import logging
-import contextlib
-from typing import Any, Callable, Iterator, Protocol
-
-import traceback
-
-class DbConnection(Protocol):
-    """Type annotation for a generic database connection object."""
-    def cursor(self) -> Any:
-        """A cursor object"""
-        ...
-
-    def commit(self) -> Any:
-        """Commit the transaction."""
-        ...
-
-    def rollback(self) -> Any:
-        """Rollback the transaction."""
-        ...
-
-class DbCursor(Protocol):
-    """Type annotation for a generic database cursor object."""
-    def execute(self, *args, **kwargs) -> Any:
-        """Execute a single query"""
-        ...
-
-    def executemany(self, *args, **kwargs) -> Any:
-        """
-        Execute parameterized SQL statement sql against all parameter sequences
-        or mappings found in the sequence parameters.
-        """
-        ...
-
-    def fetchone(self, *args, **kwargs):
-        """Fetch single result if present, or `None`."""
-        ...
-
-    def fetchmany(self, *args, **kwargs):
-        """Fetch many results if present or `None`."""
-        ...
-
-    def fetchall(self, *args, **kwargs):
-        """Fetch all results if present or `None`."""
-        ...
-
-@contextlib.contextmanager
-def connection(db_path: str, row_factory: Callable = sqlite3.Row) -> Iterator[DbConnection]:
-    """Create the connection to the auth database."""
-    logging.debug("SQLite3 DB Path: '%s'.", db_path)
-    conn = sqlite3.connect(db_path)
-    conn.row_factory = row_factory
-    conn.set_trace_callback(logging.debug)
-    conn.execute("PRAGMA foreign_keys = ON")
-    try:
-        yield conn
-    except sqlite3.Error as exc:
-        conn.rollback()
-        logging.debug(traceback.format_exc())
-        raise exc
-    finally:
-        conn.commit()
-        conn.close()
-
-@contextlib.contextmanager
-def cursor(conn: DbConnection) -> Iterator[DbCursor]:
-    """Get a cursor from the given connection to the auth database."""
-    cur = conn.cursor()
-    try:
-        yield cur
-    except sqlite3.Error as exc:
-        conn.rollback()
-        logging.debug(traceback.format_exc())
-        raise exc
-    finally:
-        conn.commit()
-        cur.close()
-- 
cgit v1.2.3