YJP4ZFK9

1import sqlite3
2def cretae_table():
3	conn = sqlite3.connect("lite.db")
4	cur = conn.cursor()
5	cur.execute(
6		"CREATE TABLE IF NOT EXISTS stored (item TEXT, quantity INTEGER, cost INTEGER)"
7  	)
8	conn.commit()
9	conn.close()
10
11def insert(item,quantity,cost):
12		conn = sqlite3.connect("lite.db")
13		cur = conn.cursor()
14		cur.execute("INSERT INTO stored VALUES(?,?,?)",(item,quantity,cost))
15		conn.commit()
16		conn.close()
17
18insert('cup',4,10)
19
20def view():
21	conn = sqlite3.connect("lite.db")
22	cur = conn.cursor()
23	cur.execute("SELECT * FROM stored")
24	rows=cur.fetchall()
25	conn.close()
26	return rows
27
28def update(quantity,cost,item):
29	conn = sqlite3.connect("lite.db")
30	cur = conn.cursor()
31	cur.execute("UPDATE stored SET quantity=?, cost=? WHERE item=?",(quantity,cost,item,))
32	conn.commit()
33	conn.close()
34
35update(5,12,'glass')
36
37def delete(item):
38	conn = sqlite3.connect("lite.db")
39	cur = conn.cursor()
40	cur.execute("DELETE FROM stored WHERE item=?",(item,))
41	conn.commit()
42	conn.close()
43
44delete('cup')
45print(view())