SQLite3 Database for python

database.py

import sqlite3

class Database:
    def __init__(self):
        self.conn: Optional[sqlite3.Connection] = None

    async def connect(self):
        try:
            self.conn = sqlite3.connect(FILENAME)
        except sqlite3.Error:
            pass

        return self

    @property
    def is_connected(self) -> bool:
        return self.conn is not None

    @staticmethod
    async def _fetch(cursor, mode) -> Optional[Any]:
        if mode == "one":
            return cursor.fetchone()
        if mode == "many":
            return cursor.fetchmany()
        if mode == "all":
            return cursor.fetchall()

        return None
    
    # fetch param only use when using SELECT
    async def execute(self, query: str, values: Tuple = (), *, fetch: str = None) -> Optional[Any]:
        cursor = self.conn.cursor()

        cursor.execute(query, values)
        data = await self._fetch(cursor, fetch)
        self.conn.commit()

        cursor.close()
        return data