A Simple Food Ordering system made with Python and MySQL Database. The Code uses PyMySQL Python Library to function. This code has a very simple syntax which makes it easy to understand and beginner friendly.

Clone the project

pip install pymysql

or

python -m pip install pymysql

-- Create the database
CREATE DATABASE food_ordering;

-- Use the database
USE food_ordering;

-- Create the tables
CREATE TABLE menu (
    id INT PRIMARY KEY,
    item_name VARCHAR(100),
    price DECIMAL(10, 2)
);

CREATE TABLE orders (
    id INT PRIMARY KEY AUTO_INCREMENT,
    item_id INT,
    quantity INT,
    total_price DECIMAL(10, 2),
    FOREIGN KEY (item_id) REFERENCES menu(id)
);

• After installing the needed libraries. Edit the menu.csv file to load the questions and its answers.

• Then, run the load_food.py script to load the questions and answers to the SQL database.

• Don't run the load_food.py more than once, It will cause duplicate questions and cause clutter on your database.

• Then Finally, run the app.py to play the quiz.

• @sidharth_everett
• @sindhu_vaibhav_KL
• And our friends @Medusa Infosystems International