db.py

import sqlite3


class Database:
    def __init__(self, db):
        self.con = sqlite3.connect(db)  # داله اتصال قاعده البيانات
        self.cur = self.con.cursor()  # داله تحديث قواعد البيانات

        sql = """
        CREATE TABLE IF NOT EXISTS employees (
            id Integer Primary Key,
            name text,
            age text,
            job text,
            email text, 
            gender text, 
            mobile text,
            address text
        )
        """
        self.cur.execute(sql)
        self.con.commit()

    def insert(self, name, age, job, email, gender, mobile, address):
        self.cur.execute("insert into employees values (NULL,?,?,?,?,?,?,?)",
                         (name, age, job, email, gender, mobile, address)
                         )
        self.con.commit()

    def fetch(self):
        self.cur.execute("SELECT * FROM employees")
        rows = self.cur.fetchall()
        return rows

    def remove(self,id):
        self.cur.execute("delete from employees where id=?", (id,))
        self.con.commit()

    def update(self, id, name, age, job, email, gender, mobile, address):
        self.cur.execute("update employees set name=?,age=?,job=?,email=?,gender=?,mobile=?,address=? where id=?",
                         (name, age, job, email, gender, mobile, address, id))
        self.con.commit()