Using Python, $9\mathrm{.}2$ Wk $4$ Milestone $2($Part$2-$ Database access with users$)$

In this lab, the DbManager class created in Milestone $1$ is extended to include new functionalities associated with the new user classes. You can use your Users.py$,$ from Part$1$ of Milestone $2,$ DbManager.py and FoodVendor.py from Milestone $1$ to complete this lab. Alternatively, copy and paste all the attributes and instance methods created in your recent submissions to the new template files provided here.

To include the new functionalities, DbManager.py has the following extra specifications:

Instance methods

update$\_$admin$($user$)$

Update the database with the phone number and email address of parameter user.

get$\_$admin$($user$\_$name$)$

Return an Admin user that is in the database with username equals to the parameter. If the user is not found, return an Admin user with all attributes $="".$

update$\_$customer$($user$)$

Update the database with the credit card number, expiration date, billing address, phone number, and email address of parameter user.

get$\_$customer$($user$\_$name$)$

Return a customer that is in the database with username equals to the parameter. If the user is not found, return a customer with all attributes to $""$ or $0.$

There is no new specification for FoodVendor.py; however, modify the main method in the FoodVendor.py you have submitted for Milestone $1$ to test the program. See examples in the template file. import sqlite$3,$ os

from sqlite$3$ import Error

from os import path

from DbManager import DbManager

from Users import User, Admin, Customer

class FoodVendor:

# TODO: copy and paste instance method initialize$()$ created from Part $1$ of Milestone $1$ here.

if $\_\_$name$\_\_==\text{'}\_\_$main$\_\_\text{'}$:

vendor $=$ FoodVendor$()$

vendor.initialize$()$

# Test cases

# Test get$\_$customer$()$

print$(\text{'}$Test get$\_$customer$()$ with username from database'$)$

customer$\_$user $=$ vendor.db$.$get$\_$customer$("$gwarner$653")$;

print$(\text{'}$customer$\_$user: $\{\}\text{'}.$format$($customer$\_$user$))$

# Test get$\_$admin$()$

print$(\text{'}$Test get$\_$admin$()$ with username from database'$)$

admin$\_$user $=$ vendor.db$.$get$\_$admin$("$rebradshaw$835")$;

print$(\text{'}$admin$\_$user: $\{\}\text{'}.$format$($admin$\_$user$))$

# TODO: test other member methods of DbManager

vendor.db$.$disconnect$()$