Activity 2.26

Source Code

import sqlite3
import os
# needed for current_datetime
from datetime import datetime

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

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

    # connect
    conn = sqlite3.connect(dbname)

    # cursor object
    cursor = conn.cursor()

    # sql query
    sql = ""

    # execute
    cursor.execute(sql)

    # retrieve data again
    rows = cursor.fetchall()

    conn.close()

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