Python SQLite Database Class for Simplified Database Interactions

class CSqlite(object): def init(self): super(CSqlite, self).init() self._conn = None self._cur = None

def connect(self, database): try: self._conn = sqlite3.connect(database) self._cur = self._conn.cursor() except sqlite3.Error as e: print('Error connecting to database: {}'.format(e))

def execute(self, query, args=None):
    try:
        if args:
            self._cur.execute(query, args)
        else:
            self._cur.execute(query)
        return self._cur.fetchall()
    except sqlite3.Error as e:
        print('Error executing query: {}'.format(e))

def commit(self):
    try:
        self._conn.commit()
    except sqlite3.Error as e:
        print('Error committing changes: {}'.format(e))

def close(self):
    try:
        self._conn.close()
    except sqlite3.Error as e:
        print('Error closing database: {}'.format(e))