This capstone project will simulate a food vendor application, which will maintain a food menu and user database, allow for customer ordering, as well as administrative management of customer and employee accounts.

The project is divided into $3$ milestones:

Database setup

User object implementations; database access

Menu ordering integration

Milestone $1$

This Milestone uses incremental programming. The autograder's unit tests will test each method individually $($with the exception of Step $1\text{'}$s database setup methods, which will all be tested together$),$ independent of every other method. It is recommended to submit the program after each major step $($or even during a major step$)$ so as to ensure the implemented methods each function properly.

The following is the description of the dataset for the database, along with a full specification list and steps of what should be implemented in this Milestone program.

Dataset Description

A database of two tables will be initialized with two sets of data. The datasets for the database are provided in tab$-$separated value $(.$tsv$)$ files: menu.tsv and user.tsv$.$ The first row of the $.$tsv files contains the header, which contain the column names, while subsequent rows contain the values of each column. The description of the dataset for each table is as follows:

menu table $($menu$.$tsv$)$

category $-$ type TEXT, category of food item

item$\_$name $-$ type TEXT, name of food item

description $-$ type TEXT, description of food item

price $-$ type DECIMAL$(5,2),$ price of food item

prep$\_$time $-$ type INTEGER, time required to prepare the food item $($in minutes$)$

available $-$ type INTEGER, availability of food item in daily menu $(1=$ available, $0=$ unavailable$)$

user table $($user$.$tsv$)$

user$\_$name $-$ type TEXT, username of user

account$\_$type $-$ type TEXT, type of user account $($admin or customer$)$

first$\_$name $-$ type TEXT, first name of user

last$\_$name $-$ type TEXT, last name of user

email $-$ type TEXT, email address of user

phone$\_$number $-$ type TEXT, phone number of user

password $-$ type TEXT, password of user

employee$\_$id $-$ type TEXT, employee ID of admin user

credit$\_$card$\_$number $-$ type TEXT, credit card number of customer user

credit$\_$card$\_$exp$\_$date $-$ type TEXT, expiration date of credit card of customer user

billing$\_$address $-$ type TEXT, credit card billing address of customer user

reward$\_$points $-$ type INTEGER, reward points earned by customer user

order$\_$history $-$ type INTEGER, receipt number of last order by customer user

Step $1$: Implement database setup methods in DbManager.py

DbManager.py contains class DbManager which allows the food vendor to create and access the database. Implement the following attributes and methods for class DbManager:

Attributes

Connection conn $-$ Connection object that, once connected, will be used throughout the program.

Instance methods

Database Setup Methods

connect$()$

Establishes a connection to an in$-$memory database.

disconnect$()$

Disconnects from the existing database.

create$\_$menu$\_$table$($data$\_$file$)$

Reads a $.$tsv file and creates a table named menu.

Calls insert$\_$menu$()$ to insert individual entries to the table.

insert$\_$menu$($menu$)$

Reads a menu tuple containing the column values of a menu entry $($category$,$ item$\_$name, description, price, prep$\_$time, availability$).$

Inserts an entry into the menu table with column values listed in the parameter.

create$\_$user$\_$table$($data$\_$file$)$

Reads a $.$tsv file and creates a table named user.

Calls insert$\_$user$()$ to insert individual entries into the table.

Step $2$: Implement basic FoodVendor.py

FoodVendor.py contains class FoodVendor which controls the overall ordering system. FoodVendor.py will also be where a main method can be implemented to test the functionality of the program. FoodVendor.py has the following specifications:

Attributes

DbManager db $-$ DbManager object that allows access to a database.

Instance methods

initialize$()$

Instantiates a new DbManager object.

Connects to the database.

Creates menu and user tables in the database.

Step $3$: Implement user$-$related methods in DbManager.py

In DbManager.py$,$ implement the following methods relating to the user table:

User$-$related Methods

insert$\_$user$($user$)$

Reads a user a tuple containing the column values of a user entry $($user$\_$name, account, first$\_$name, last$\_$name, email, phone$\_$num, password, emId, card$\_$num, card$\_$date, address, points, history$).$

Inserts an entry into the user table with the column values listed in the parameter.

update$\_$customer$\_$rewards$($name$,$ value$)$

Sets a user's $($whose name equals parameter name$)$ reward points equal to parameter value.

update$\_$customer$\_$history$($name$,$ value$)$

Sets a user's $($whose name equals parameter name$)$ order history with parameter value.

is$\_$user$\_$exist$($user$\_$name$)$

Returns True if a user with name equal to parameter user$\_$name exists in the database, otherwise returns False.

delete$\_$user$($user$\_$name$)$

Removes entry of a user with name equal to parameter user$\_$name from the database.

Step $4$: Implement menu$-$