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 sqlite
from Chefstaff import
conn sqliteconnectChefOrder.db
curs conn.cursor
MembersID Aria: ID 'Barston': IDCJ: ID 'Damarsh': ID 'Elaine': ID
MembersFeedback Aria: 'Barston': CJ: 'Damarsh': 'Elaine':
MembersOrder Aria: 'Barston': CJ: 'Damarsh': 'Elaine':
Food Burger: 'Pancakes': 'Sandwiches': 'Steak': 'Fries': 'Tea': 'Coffee':
FoodRating Burger: 'Pancakes': 'Sandwiches': 'Steak': 'Fries': 'Tea': 'Coffee':
orderno
burgerrate
pancakerate
sandwichrate
steakrate
friesrate
tearate
coffeerate
accumalatedb
accumalatedp
accumalatedsw
accumalatedst
accumalatedf
accumalatedt
accumalatedc
while True:
orderoption False
login inputPlease enter your member username:
for i in MembersID:
if login i:
while orderoption False:
price
orderno
order intinputPlease select which food you would like to order
Burger
Pancakes
Sandwiches
Steak
Fries
Tea
Coffee
if order :
amountorder intinputHow many burgers would you like to order?
MembersOrderi amountorder
printfYou have ordered amountorder Burger, login
price FoodBurger amountorder
curs.executefINSERT INTO Progression OrderNo ID Food, Quantity, Price VALUES ordernoMembersIDi"Burger",amountorderprice
elif order :
amountorder intinputHow many pancake would you like to order?
MembersOrderi amountorder
printfYou have ordered amountorder Pancakes, login
price FoodPancakes amountorder
curs.executefINSERT INTO Progression OrderNo ID Food, Quantity, Price VALUES ordernoMembersIDi"Pancakes",amountorderprice
elif order :
amountorder intinputHow many sandwich would you like to order?
MembersOrderi amountorder
printfYou have ordered amountorder Sandwiches, login
price FoodSandwiches amountorder
curs.executefINSERT INTO Progression.tbl OrderNo ID Food, Quantity, Price VALUES ordernoMembersIDi"Sandwiches",amountorderprice
elif order :
amountorder intinputHow many Steak would you like to order?
MembersOrderi amountorder
printfYou have ordered amountorder Steak, login
price FoodSteak amountorder
curs.executefINSERT INTO Progression OrderNo ID Food, Quantity, Price VALUES ordernoMembersIDi"Steak",amountorderprice
elif order :
amountorder intinputHow many packet of fries would you like to order?
MembersOrderi amountorder
printfYou have ordered amountorder packet of fries, login
price FoodFries amountorder
curs.executefINSERT INTO Progression OrderNo ID Food, Quantity, Price VALUES ordernoMembersIDi"Fries",amountorderprice
elif order :
amountorder intinputHow many tea would you like to order?
MembersOrderi amountorder
printfYou have ordered amountorder tea, login
price FoodTea amountorder
curs.executefINSERT INTO Progression OrderNo ID Food, Quantity, Price VALUES ordernoMembersIDi"Tea",amountorderprice
elif order :
amountorder intinputHow many coffee would you like to order?
MembersOrderi amountorder
printfYou have ordered amountorder coffee, login
price FoodCoffee amountorder
curs.executefINSERT INTO Progression Or
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
