Activity 2.24

Source Code

import sqlite3
import os

def main():
    done = False
    print("Project 5")
    # create database
    dbname = 'project5.db'
    conn = sqlite3.connect(dbname)
    while not done:
        print("Restaurant Test Menu")
        print("S- Select Example")
        print("X - Exit")
        choice = input("Choice: ").upper()
        if choice == "X":
            print("Exiting Restaurant Menu")
            done = True
        elif choice == "S":
            example(dbname)
        else:
            print("Invalid, try again!")

# example
def example(dbname):
    print("Example")

    # connect
    

    # cursor object
    

    # sql query
    

    # execute
    

    # retrieve data (raw)
    

    # execute
    

    # retrieve data again
    

# call to main function, do not delete!
main()