dbmanager.py

##database manager

import sys
import os
curPath = os.path.abspath(os.path.dirname(__file__))
rootPath = os.path.split(curPath)[0]
sys.path.append(rootPath)
#Prevent posible package not found error
import sqlite3

sqlite_file = 'my_db.sqlite'                #filename for database

class DatabaseManager:

    def __init__(self):
        self.__conn = sqlite3.connect(sqlite_file)
        self.__cur = self.__conn.cursor()
        self.create()

    def create(self):
        command = '''CREATE TABLE IF NOT EXISTS JOKES (
            Comedian text,
            Joke text,
            Charlen integer,
            Wordlen integer
        )
        '''
        self.__cur.execute(command)
        self.__conn.commit()

    def execute(self, query: str):
        """execute sql query @code(command)
        
        Arguments:
            command {[str]} -- sql query we want to execute
        """

        self.__cur.execute(query)

    def fetch(self):
        """fetch once
        
        Returns:
            [tuple] -- tuple of first data that fits the query
        """

        return self.__cur.fetchone()

    def fetch_all(self):
        """fetch all answer that fits the latest query
        
        Returns:
            [list] -- list of tuples of data that fits the query
        """

        return self.__cur.fetchall()

    def commit(self):
        """commit changes
        
        Returns:
            [None] -- returns nothing
        """

        return self.__conn.commit()

    def close(self):
        """close the connection to the database
        
        Returns:
            [None] -- returns nothing
        """

        return self.__conn.close()