c = contacts.Contacts() while True: print(" *** TUFFY TITAN CONTACTS MAIN MENU") print() print("1. Set database name") print("2. Add contact") print("3. Modify contact") print("4. Add phone") print("5. Modify phone") print("6. Print contact phone list") print("9. Exit the program") print() choice=int(input("Enter menu choice: ")) print() # set database name ifchoice==1: database_name=input("Enter database name: ") c.set_database_name(database_name) print() # add contact elifchoice==2: database_name=c.get_database_name() ifdatabase_name=='': print('ERROR: Set database name') print() else: first_name=input("Enter first name: ") last_name=input("Enter last name: ") c.add_contact(first_name, last_name) print() # modify contact elifchoice==3: database_name=c.get_database_name() ifdatabase_name=='': print('ERROR: Set database name') print() else: contact_id=input("Enter contact id: ") first_name=input("Enter first name: ") last_name=input("Enter last name: ") c.modify_contact(contact_id, first_name, last_name) print() # add phone elifchoice==4: database_name=c.get_database_name() ifdatabase_name=='': print('ERROR: Set database name') print() else: contact_id=input("Enter contact id: ") phone_type=input("Enter phone type: ") phone_number=input("Enter phone number: ") c.add_phone(contact_id, phone_type, phone_number) print() # modify phone elifchoice==5: database_name=c.get_database_name() ifdatabase_name=='': print('ERROR: Set database name') print() else: phone_id=input("Enter phone id: ") phone_type=input("Enter phone type: ") phone_number=input("Enter phone number: ") c.modify_phone(phone_id, phone_type, phone_number) print() # print report elifchoice==6: database_name=c.get_database_name() ifdatabase_name=='': print('ERROR: Set database name') print() else: list=c.get_contact_phone_list() print('=======================================================') print('(id) Contact (id) Phone Numbers ') print('======================= ==============================') previous_id=0 forxinlist: ifx[0] ==previous_id: print(f'{"":5}{" ":20}{"("+str(x[3])+")":5}{x[5]+": "+x[6]:25}') else: print(f'{"("+str(x[0])+")":5}{x[1]+" "+x[2]:20}{"("+str(x[3])+")":5}{x[5]+": "+x[6]:25}') previous_id=x[0] print('=======================================================') print() #EXIT elifchoice==9: break; 1. Write a Python program that performs as a Tuffy Titan Contacts phone list. You are given the main.py file andare required to create the Contacts class.2. The following is the Entity-Relationshipcontactscontact_idfirst_namelast_nameDiagram for the data structure:Entity-Relationship DiagramContactAnna Kendrick1. The following is some sample data to help visualize the data model:Rebel WilsonSkylar AstinAdam DeVinephonesphone_idcontact_idphone_typephone_number1. Create a Contacts class to meet the following requirements:i. Create a file named contacts.py.Sample DataPhone NumbersHome: (224)965-7800Cell: (113)290-9210Home: (227)673-8398Work: (726)114-4178Cell: (488)190-7360Cell: (388)897-6231Work: (675)903-1290Cell: (747)582-9543Home: (370)737-9472Business: (605)101-7583a. Define a method named_init_ to meet the following requirements:a. Declare a class variable to store the database file and intitialize it to an empty string.b. Define a method named set_database_name to meet the following requirements:a. Take a database file name as a positional parameter and assign the value to the class variable.b. If the file already exists, do nothing (we want to preserve any data in the file for continued use.)c. If the file does not exisit, connect to the sqlite3 file and create the contacts table and thephones table using the proper SQL CREATE TABLE statement. Use the same field names asthose used in the Entity-Relationship diagram above. Use integers for all the id's and text for allthe other data.c. Define a method named get_database_name to meet the following requirements:a. Return the value of the class variable that stores the database name.d. Define a method named add_contact to meet the following requirements:a. Take a first name and last name as positionals parameter.b. Insert the first name and last name into the contacts table using the SQL INSERT INTOstatement.e. Define a method named modify_contact to meet the following requirements:a. Take a contact id, first name, and last name as positionals parameter.b. Update the first name and last name of the cooresponding contact id in the contacts table usingthe SQL UPDATE statement.f. Define a method named add_phone to meet the following requirements:a. Take a contact id, phone type, and phone number as positionals parameter.b. Insert the contact id, phone type, phone number into the phones table using the SQL INSERTINTO statement.g. Define a method named modify_phone to meet the following requirements:a. Take a phone id, phone type, and phone number as positionals parameter.b. Update the phone type and phone number of the cooresponding phone id in the phones tableusing the SQL UPDATE statement.h. Define a method named get_contact_phone_list to meet the following requirements:a. Return an array created from a query on the database using the SQL statement SELECTcontacts.*, phones.* FROM contacts LEFT JOIN phones ONcontacts. contact_id=phones. contact_id.

Introduction Python Function: The function in Python is a set of related statements that perform out a certain task. Functions assist in segmenting our software into manageable, modular portions. The programme becomes much more structured & controlled as it becomes bigger & bigger. Also it makes the code reusable & avoids duplication.Source Code: main.py: import contactsc = contacts.Contacts() while True: print(" *** TUFFY TITAN CONTACTS MAIN MENU") print() print("1. Set database name") print("2. Add contact") print("3. Modify contact") print("4. Add phone") print("5. Modify phone") print("6. Print contact phone list") print("9. Exit the program") print() choice = int(input("Enter menu choice: ")) print() # set database name if choice == 1: database_name = input("Enter database name: ") c.set_database_name(database_name) print() # add contact elif choice == 2: database_name = c.get_database_name() if database_name == '': print('ERROR: Set database name') print() else: first_name = input("Enter first name: ") last_name = input("Enter last name: ") c.add_contact(first_name, last_name) print() # modify contact elif choice == 3: database_name = c.get_database_name() if database_name == '': print('ERROR: Set database name') print() else: contact_id = input("Enter contact id: ") first_name = input("Enter first name: ") last_name = input("Enter last name: ") c.modify_contact(contact_id, first_name, last_name) print() # add phone elif choice == 4: database_name = c.get_database_name() if database_name == '': print('ERROR: Set database name') print() else: contact_id = input("Enter contact id: ") phone_type = input("Enter phone type: ") phone_number = input("Enter phone number: ") c.add_phone(contact_id, phone_type, phone_number) print() # modify phone elif choice == 5: database_name = c.get_database_name() if database_name == '': print('ERROR: Set database name') print() else: phone_id = input("Enter phone id: ") phone_type = input("Enter phone type: ") phone_number = input("Enter phone number: ") c.modify_phone(phone_id, phone_type, phone_number) print() # print report elif choice == 6: database_name = c.get_database_name() if database_name == '': print('ERROR: Set database name') print() else: list = c.get_contact_phone_list() print('=======================================================') print('(id) Contact (id) Phone Numbers ') print('======================= ==============================') previous_id = 0 for x in list: if x[0] == previous_id: print(f'{"":5}{" ":20}{"("+str(x[3])+")":5}{x[5]+": "+x[6]:25}') else: print(f'{"("+str(x[0])+")":5}{x[1]+" "+x[2]:20}{"("+str(x[3])+")":5}{x[5]+": "+x[6]:25}') previous_id = x[0] print('=======================================================') print() #EXIT elif choice == 9: break contacts.py: import sqlite3class Contacts: def __init__(self): connection = sqlite3.connect('intern.db') cursor = connection.cursor() self.file='' def set_database_name(self,file): connection = sqlite3.connect('intern.db') cursor = connection.cursor() cursor.execute('''CREATE TABLE IF NOT EXISTS contacts(contact_id INTEGER PRIMARY KEY AUTOINCREMENT, first_name TEXT , last_name TEXT);''') cursor.execute('''CREATE TABLE IF NOT EXISTS phones(phone_id INTEGER PRIMARY KEY AUTOINCREMENT,contact_id INT,phone_type TEXT,phone_number TEXT);''') self.file=file connection.commit() connection.close() def get_database_name(self): return self.file def add_contact(self,first,last): connection = sqlite3.connect('intern.db') cursor = connection.cursor() cursor.execute("INSERT INTO contacts (first_name, last_name) VALUES(?, ?)",(first,last)) connection.commit() connection.close() def modify_contact(self,ids,first,last): connection = sqlite3.connect('intern.db') cursor = connection.cursor() sql_update_query = '''UPDATE contacts SET first_name=? WHERE contact_id =?;''' data = (first,ids) cursor.execute(sql_update_query, data) sql_update_query = '''UPDATE contacts SET last_name=? WHERE contact_id =?;''' data = (last,ids) cursor.execute(sql_update_query, data) connection.commit() connection.close() def add_phone(self,ids,ptype,num): connection = sqlite3.connect('intern.db') cursor = connection.cursor() cursor.execute("INSERT INTO phones (contact_id,phone_type,phone_number) VALUES(?,?,?)",(ids,ptype,num)) connection.commit() connection.close() def modify_phone(self,ids,ptype,num): connection = sqlite3.connect('intern.db') cursor = connection.cursor() sql_update_query = '''UPDATE phones SET phone_type=? WHERE phone_id =?;''' data = (ptype,ids) cursor.execute(sql_update_query, data) sql_update_query = '''UPDATE phones SET phone_number=? WHERE phone_id =?;''' data = (num,ids) cursor.execute(sql_update_query, data) connection.commit() def get_contact_phone_list(self): connection = sqlite3.connect('intern.db') cursor = connection.cursor() x=cursor.execute('''SELECT contacts.*, phones.* FROM contacts LEFT JOIN phones ON contacts.contact_id=phones.contact_id''') connection.close() return xScreenshot of code: please go thru the snapshots provided below for better understanding of Indentation of code. main.py- contacts.py:

1. Write a Python program that performs as a Tuffy Titan Contacts phone list. You are given the main.py file and are required to create the Contacts class. 2. The following is the Entity-Relationship Diagram for the data structure: Entity-Relationship Diagram contacts contact_id first_name last_name 1. The following is some sample data to help visualize the data model: Sample Data Phone Numbers Home: (224)965-7800 Cell: (113)290-9210 Home: (227)673-8398 Work: (726)114-4178 Cell: (488)190-7360 Cell: (388)897-6231 Work: (675)903-1290 Cell: (747)582-9543 Home: (370)737-9472 Business: (605)101-7583 Contact Anna Kendrick Rebel Wilson Skylar Astin Adam DeVine phones phone_id contact_id phone_type phone_number 1. Create a Contacts class to meet the following requirements: i. Create a file named contacts.py. a. Define a method named init_ to meet the following requirements: a. Declare a class variable to store the database file and intitialize it to an empty string. b. Define a method named set_database_name to meet the following requirements: a. Take a database file name as a positional parameter and assign the value to the class variable. b. If the file already exists, do nothing (we want to preserve any data in the file for continued use.) c. If the file does not exisit, connect to the sqlite3 file and create the contacts table and the phones table using the proper SQL CREATE TABLE statement. Use the same field names as those used in the Entity-Relationship diagram above. Use integers for all the id's and text for all the other data.

Database System Concepts

7th Edition

ISBN:9780078022159

Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Publisher:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Chapter1: Introduction

Section: Chapter Questions

Problem 1PE

See similar textbooks

c = contacts.Contacts()

	while True:
	print(" *** TUFFY TITAN CONTACTS MAIN MENU")
	print()
	print("1. Set database name")
	print("2. Add contact")
	print("3. Modify contact")
	print("4. Add phone")
	print("5. Modify phone")
	print("6. Print contact phone list")
	print("9. Exit the program")
	print()
	choice=int(input("Enter menu choice: "))
	print()

	# set database name
	ifchoice==1:
	database_name=input("Enter database name: ")
	c.set_database_name(database_name)
	print()

	# add contact
	elifchoice==2:
	database_name=c.get_database_name()
	ifdatabase_name=='':
	print('ERROR: Set database name')
	print()
	else:
	first_name=input("Enter first name: ")
	last_name=input("Enter last name: ")
	c.add_contact(first_name, last_name)
	print()

	# modify contact
	elifchoice==3:
	database_name=c.get_database_name()
	ifdatabase_name=='':
	print('ERROR: Set database name')
	print()
	else:
	contact_id=input("Enter contact id: ")
	first_name=input("Enter first name: ")
	last_name=input("Enter last name: ")
	c.modify_contact(contact_id, first_name, last_name)
	print()

	# add phone
	elifchoice==4:
	database_name=c.get_database_name()
	ifdatabase_name=='':
	print('ERROR: Set database name')
	print()
	else:
	contact_id=input("Enter contact id: ")
	phone_type=input("Enter phone type: ")
	phone_number=input("Enter phone number: ")
	c.add_phone(contact_id, phone_type, phone_number)
	print()

	# modify phone
	elifchoice==5:
	database_name=c.get_database_name()
	ifdatabase_name=='':
	print('ERROR: Set database name')
	print()
	else:
	phone_id=input("Enter phone id: ")
	phone_type=input("Enter phone type: ")
	phone_number=input("Enter phone number: ")
	c.modify_phone(phone_id, phone_type, phone_number)
	print()

	# print report
	elifchoice==6:
	database_name=c.get_database_name()
	ifdatabase_name=='':
	print('ERROR: Set database name')
	print()
	else:
	list=c.get_contact_phone_list()
	print('=======================================================')
	print('(id) Contact (id) Phone Numbers ')
	print('======================= ==============================')
	previous_id=0
	forxinlist:
	ifx[0] ==previous_id:
	print(f'{"":5}{" ":20}{"("+str(x[3])+")":5}{x[5]+": "+x[6]:25}')
	else:
	print(f'{"("+str(x[0])+")":5}{x[1]+" "+x[2]:20}{"("+str(x[3])+")":5}{x[5]+": "+x[6]:25}')
	previous_id=x[0]
	print('=======================================================')
	print()

	#EXIT
	elifchoice==9:
	break;