import sqlite3

def connect():
    conn = sqlite3.connect("book.db")
    cur = conn.cursor()
    cur.execute("CREATE TABLE IF NOT EXISTS book ( id INTEGER PRIMARY KEY , title text , author text , year integer , isbn integer)")
    conn.commit()
    conn.close()

def insert(title,author,year,isbn):
    conn=sqlite3.connect("book.db")
    cur = conn.cursor()
    cur.execute("INSERT INTO book VALUES ( NULL,?,?,?,?)",(title,author,year,isbn))
    conn.commit()
    conn.close()

def view():
    conn=sqlite3.connect("book.db")
    cur = conn.cursor()
    cur.execute("SELECT * FROM book")
    Rows = cur.fetchall()
    conn.close()
    return Rows

def search(title="",author="",year="",isbn=""):
    conn=sqlite3.connect("book.db")
    cur = conn.cursor()
    cur.execute("SELECT * FROM book WHERE title =? OR author =? OR year = ? OR isbn = ? ",(title,author,year,isbn))
    Rows = cur.fetchall()
    conn.close()
    return Rows

def delete(id):
    conn=sqlite3.connect("book.db")
    cur = conn.cursor()
    cur.execute("DELETE FROM book WHERE id = ?",(id,))
    conn.commit()
    conn.close()

def update(id,title,author,year,isbn):
    conn=sqlite3.connect("book.db")
    cur = conn.cursor()
    cur.execute("UPDATE book SET title =?,author = ?, year = ?, isbn = ? WHERE id =?",(id,title,author,year,isbn))
    conn.commit()
    conn.close()



connect()
#insert("The Sea","<NAME>",1918,913123132)
#print(view())
#print(search(author ="<NAME>"))