Question: I would like to request assistance with my code, where when inserting a table into the database from Python, the system replies with an error

I would like to request assistance with my code, where when inserting a table into the database from Python, the system replies with an error that says that the table is not nonexistent. However, the table is there.
Cafeteria.py
import sqlite3
from Chef_staff import *
conn = sqlite3.connect('Chef__Order.db')
curs = conn.cursor()
MembersID ={'Aria': 'ID001', 'Barston': 'ID002','CJ': 'ID003', 'Damarsh': 'ID004', 'Elaine': 'ID005'}
MembersFeedback ={'Aria': 0, 'Barston': 0,'CJ': 0, 'Damarsh': 0, 'Elaine': 0}
MembersOrder ={'Aria': 0, 'Barston': 0,'CJ': 0, 'Damarsh': 0, 'Elaine': 0}
Food ={'Burger': 5.00, 'Pancakes': 2.00, 'Sandwiches': 2.50, 'Steak': 10.00, 'Fries': 1.50, 'Tea': 0.50, 'Coffee': 0.75}
FoodRating ={'Burger': 0, 'Pancakes': 0, 'Sandwiches': 0, 'Steak': 0, 'Fries': 0, 'Tea': 0, 'Coffee': 0}
order_no =0
burger_rate =0
pancake_rate =0
sandwich_rate =0
steak_rate =0
fries_rate =0
tea_rate =0
coffee_rate =0
accumalated_b =0
accumalated_p =0
accumalated_sw =0
accumalated_st =0
accumalated_f =0
accumalated_t =0
accumalated_c =0
while True:
order_option = False
login = input('Please enter your member username: ')
for i in MembersID:
if login == i:
while order_option == False:
price =0
order_no =+1
order = int(input('Please select which food you would like to order
1. Burger
2. Pancakes
3. Sandwiches
4. Steak
5. Fries
6. Tea
7. Coffee
'))
if order ==1:
amount_order = int(input('How many burgers would you like to order?
'))
MembersOrder[i]+= amount_order
print(f'You have ordered {amount_order} Burger, {login}')
price = Food['Burger']* amount_order
curs.execute(f'INSERT INTO Progression (OrderNo, ID, Food, Quantity, Price) VALUES ({order_no},{MembersID[i]},"Burger",{amount_order},{price})')
elif order ==2:
amount_order = int(input('How many pancake would you like to order?
'))
MembersOrder[i]+= amount_order
print(f'You have ordered {amount_order} Pancakes, {login}')
price = Food['Pancakes']* amount_order
curs.execute(f'INSERT INTO Progression (OrderNo, ID, Food, Quantity, Price) VALUES ({order_no},{MembersID[i]},"Pancakes",{amount_order},{price})')
elif order ==3:
amount_order = int(input('How many sandwich would you like to order?
'))
MembersOrder[i]+= amount_order
print(f'You have ordered {amount_order} Sandwiches, {login}')
price = Food['Sandwiches']* amount_order
curs.execute(f'INSERT INTO Progression.tbl (OrderNo, ID, Food, Quantity, Price) VALUES ({order_no},{MembersID[i]},"Sandwiches",{amount_order},{price})')
elif order ==4:
amount_order = int(input('How many Steak would you like to order?
'))
MembersOrder[i]+= amount_order
print(f'You have ordered {amount_order} Steak, {login}')
price = Food['Steak']* amount_order
curs.execute(f'INSERT INTO Progression (OrderNo, ID, Food, Quantity, Price) VALUES ({order_no},{MembersID[i]},"Steak",{amount_order},{price})')
elif order ==5:
amount_order = int(input('How many packet of fries would you like to order?
'))
MembersOrder[i]+= amount_order
print(f'You have ordered {amount_order} packet of fries, {login}')
price = Food['Fries']* amount_order
curs.execute(f'INSERT INTO Progression (OrderNo, ID, Food, Quantity, Price) VALUES ({order_no},{MembersID[i]},"Fries",{amount_order},{price})')
elif order ==6:
amount_order = int(input('How many tea would you like to order?
'))
MembersOrder[i]+= amount_order
print(f'You have ordered {amount_order} tea, {login}')
price = Food['Tea']* amount_order
curs.execute(f'INSERT INTO Progression (OrderNo, ID, Food, Quantity, Price) VALUES ({order_no},{MembersID[i]},"Tea",{amount_order},{price})')
elif order ==7:
amount_order = int(input('How many coffee would you like to order?
'))
MembersOrder[i]+= amount_order
print(f'You have ordered {amount_order} coffee, {login}')
price = Food['Coffee']* amount_order
curs.execute(f'INSERT INTO Progression (Or

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!