Untitled

 avatar
unknown
plain_text
a year ago
1.5 kB
4
Indexable
import sqlite3

def create_connection(db_file):
    conn = sqlite3.connect(db_file)
    print("Lidhja me databazen u krye me sukses!")
    return conn

def create_table(conn):
    komanda = """CREATE TABLE IF NOT EXISTS punonjes2(
                    id INTEGER PRIMARY KEY AUTOINCREMENT,
                    emri TEXT NOT NULL,
                    mbiemri TEXT NOT NULL,
                    departamenti TEXT NOT NULL,
                    paga REAL NOT NULL);"""
    cursor = conn.cursor()
    cursor.execute(komanda)
    conn.commit()
    print("Tabela u krijua me sukses!")

def shto_punonjes(conn, punonjesit):
    komanda2 = """INSERT INTO punonjes2 (emri, mbiemri, departamenti, paga) VALUES (?, ?, ?, ?)"""
    cursor = conn.cursor()
    cursor.executemany(komanda2, punonjesit)
    conn.commit()
    print("Punonjesit u shtuan me sukses!")

def shfaq_punonjes(conn):
    komanda3 = """SELECT * FROM punonjes2"""
    cursor = conn.cursor()
    cursor.execute(komanda3)
    punonjes = cursor.fetchall()
    for punetor in punonjes:
        print(punetor)

def main():
    databaza = "punonjes.db"
    conn = create_connection(databaza)
    create_table(conn)
    punonjesit = [
        ("Alban", "Hoxha", "IT", 70000),
        ("Andi", "Prifti", "Call Center", 50000),
        ("Ilir", "Shehu", "Support", 60000)
    ]
    shto_punonjes(conn, punonjesit)
    print("Te gjithe punonjesit jane:")
    shfaq_punonjes(conn)
    conn.close()

if __name__ == '__main__':
    main()
Editor is loading...
Leave a Comment