Untitled
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