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$()$ import csv$,$ sqlite$3,$ os

from sqlite$3$ import Error

from os import path

from Users import User, Admin, Customer

class DbManager:

$\text{'}\text{'}\text{'}$ A class that manages the database.$\text{'}\text{'}\text{'}$

#TODO: copy and paste all the instance method definitions created from Milestone $1$ here.

# Part $2$ of Milestone $2$

def update$\_$admin$($self$,$ user$)$:

# TODO: impletement your instance method here.

def get$\_$admin$($self$,$ user$\_$name$)$:

# TODO: impletement your instance method here.

def update$\_$customer$($self$,$ user$)$:

# TODO: impletement your instance method here.

def get$\_$customer$($self$,$ user$\_$name$)$:

# TODO: impletement your instance method here. # TODO: Copy and paste your User class from Part $1$ of Milestone $2$ here.

# TODO: Copy and paste your Admin class from Part $1$ of Milestone $2$ here.

# TODO: Copy and paste your Customer class from Part $1$ of Milestone $2$ here.