42uDhg9a

1import sqlite3
2
3with sqlite3.connect("scannerbarcode.db") as db:
4    cursor = db.cursor()
5
6    cursor.execute("""
7CREATE TABLE IF NOT EXISTS UPCDATABASE(
8UPCID INTEGER PRIMARY KEY,
9UPC VARCHAR(50) NOT NULL,
10Nomenclature VARCHAR(50) NOT NULL,
11Quantity INTEGER NOT NULL,
12Price Float NOT NULL);  
13""")
14
15
16cursor.execute("""
17WHERE NOT EXISTS(SELECT UPC FROM UPCDATABASE WHERE UPC = 9781595824790)
18INSERT INTO UPCDATABASE(UPC,Nomenclature,Quantity,Price)
19VALUES("9781595824790","StarWarsInvasion1","1","20.99")
20""")
21db.commit()
22
23cursor.execute("SELECT * FROM UPCDATABASE")
24print(cursor.fetchall())