Activity 2.25

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")
    # Get the current date and time
    current_datetime = datetime.now()

    # Format the date as YYYY-MM-DD HH:MM:SS
    date_time = str(current_datetime.strftime('%Y-%m-%d %H:%M:%S'))

    # connect
    conn = sqlite3.connect(dbname)

    # cursor object
    cursor = conn.cursor()

    # sql query
    sql = "SELECT * FROM menu"

    # execute
    cursor.execute(sql)

    # retrieve data (raw)
    rows = cursor.fetchall()
    for row in rows:
        print(row)

    # execute
    cursor.execute(sql)

    # retrieve data again
    print("ID\tName\tPrice\tDescription")
    rows = cursor.fetchall()
    for row in rows:
        print(str(row[0]) + "\t" + row[1] + "\t" + str(row[3]) + "\t" + row[4])

    # order code
    
        
        # sql query



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