4EdntcHM

1cursor.execute("""
2CREATE TABLE IF NOT EXISTS user(
3userID INTEGER PRIMARY KEY,
4username VARCHAR(20) NOT NULL,
5firstname VARCHAR(20) NOT NULL,    ###This user table works fine, I can add to it and it works.
6surname VARCHAR(20) NOT NULL,
7password VARCHAR(20) NOT NULL);
8""")
9
10cursor.execute("""
11CREATE TABLE IF NOT EXISTS coaching(
12userID INTEGER PRIMARY KEY,
13ntid VARCHAR(20) NOT NULL,         ###This paired with the function below is not working I get the traceback error in my Reddit post.
14ticketnumber VARCHAR(20) NOT NULL,
15analystname  VARCHAR(20) NOT NULL);
16""")
17
18
19def get_ticketnumber():
20    get_tickets = input("Enter Ticket Number: ")
21    with sqlite3.connect("Voice.db") as db:
22        cursor = db.cursor()
23        insertTickets = """INSERT INTO coaching (ticketnumber)
24        VALUES(?)"""
25        cursor.execute(insertTickets, [(get_tickets)])
26        db.commit()
27        print("Ticket Number added successfully")
28        print("Returning to main menu for now")
29        time.sleep(3)
30        coachingfunction()