import sqlite3
DB = "popravni.db"

conn = sqlite3.connect(DB)
conn.row_factory = sqlite3.Row
conn.execute("PRAGMA foreign_keys = ON;")
cur = conn.cursor()

cur.execute("UPDATE Prijava_na_popravni_izpit SET ocena = ? WHERE id_prijave =  ?;", (3, 1))
conn.commit()

cur.execute("SELECT d.ime, d.priimek, d.oddelek, p.datum, p.predmet, r.ocena FROM Prijava_na_popravni_izpit r JOIN Dijaki d ON d.id_dijaka = r.id_dijaka JOIN Popravni_izpiti p ON p.id_izpita =  r.id_izpita WHERE r.ocena = ?;", (3,))
rows = cur.fetchall()
for r in rows:
    print(r["ime"], r["priimek"], r["oddelek"], r["datum"], r["predmet"], r["ocena"])