db_context_managers.py

import sqlite3
from utils import SQLITE_DB_PATH


class OpenReaderCursor:
    def __init__(self, sql: str, args=()):
        self._SQL = sql
        self.args = args

    def __enter__(self) -> 'cursor':
        self.conn = sqlite3.connect(SQLITE_DB_PATH)
        self.cursor = self.conn.cursor()
        self.cursor.execute(self._SQL, self.args)
        return self.cursor

    def __exit__(self, exc_type, exc_val, exc_tb) -> None:
        self.cursor.close()
        self.conn.close()


class OpenWriterCursor(OpenReaderCursor):
    def __exit__(self, exc_type, exc_val, exc_tb) -> None:
        self.conn.commit()
        self.cursor.close()
        self.conn.close()


class OpenMultiWriterCursor(OpenWriterCursor):
    def __enter__(self) -> 'cursor':
        self.conn = sqlite3.connect(SQLITE_DB_PATH)
        self.cursor = self.conn.cursor()
        self.cursor.executemany(self._SQL, self.args)
        return self.cursor