DELETE dan konfirmasi

Telusuri kode sebelum menjalankan

Python · contoh konsep yang dapat dijalankan

from support import database
with database() as con:
    con.execute("CREATE TABLE books(id INTEGER PRIMARY KEY, title TEXT NOT NULL, stock INTEGER CHECK(stock>=0))")
    con.executemany("INSERT INTO books VALUES(?,?,?)", [(1, "Sains", 1), (2, "Seni", 2)])
    konfirmasi = variant == 1
    if konfirmasi:
        con.execute("DELETE FROM books WHERE id=?", (1,))
    value = con.execute("SELECT COUNT(*) FROM books").fetchone()[0]

Potongan konsep dari latihan.py · variant 0 = A · variant 1 = B