Question

Lab 3: Databased Admin Tool Python

Objective: Develop an admin tool for username and password management. You will need to use the best data structure to store the data you read from UD.txt for efficient processing. You can accomplish these tasks with Dictionary or List.

The data file (UD.txt) :

FIRST NAME, LAST NAME,USERNAME,PASSWORD

Sam, DDal,sdd233,Pad231

Dave,Dcon,dcf987, BHYW4fw

Dell,Grant,dgr803,Sb83d2d

Mike,Kress,mkr212,UNNHS322

Lisa,Kate,lki065,dgw6234

Paul,Edward,ped332,9891ds

Youyou,Tranten,ytr876,dsid21kk

Nomi,Mhanken,nmh223,3282jd3d2

Write a program that imports the database from UD.txt

Give the following options:

A: Search by last name

B: Search by first name

C: Search by username

D: Display all users alphabetically by First name

E. Display all users alphabetically by Last name

F: Insert a user

1. When user select A, prompt the user “Enter user’s last name:”

If the user is found, display the user’s info. For example: Sam, DDal,sdd233,Pad231

If user not found, display “Not found”, and return the user to main menu

2. When user select B, prompt the user “Enter user’s first name:”

If the user is found, display the user’s info. For example: Sam, DDal,sdd233,Pad231

If user not found, display “Not found”, and return the user to main menu

3. When user select C, prompt the user “Enter user’s username:”

If the user is found, display the user’s info. For example: Sam, DDal,sdd233,Pad231

If user not found, display “Not found”, and return the user to main menu

4. For D, display all the user’s information with First name in alphabetically order. For example, with our current database, “Dave, Dcon,dcf987, BHYW4fw” will appear first, and “Youyou,Tranten,ytr876,dsid21kk” will appear last.
5. For E, display all the user’s information with Last name in alphabetically order. For example, with our current database, “Dave, Dcon,dcf987, BHYW4fw” will appear first, and “Youyou,Tranten,ytr876,dsid21kk” will appear last.
6. For F, prompt the user “Enter user info in the following format: First name, last name, username, password”, process the string and save the information into the UD.txt.

Important: Declare one function called “def output ()” to output information for option D and E.

Answer 1

source code:

#Please go through comments and modify if any thing required thank you

#screenshots provided for indentation and reference purposes

#output function for D and E options
#prints the list if provided
def output(data):
print('{0: <20}{1: <20}{2: <20}{3: <20}'.format("FIRST NAME","LAST NAME","USERNAME","PASSWORD"))
for ml in data:
print('{0: <20}{1: <20}{2: <20}{3: <20}'.format(ml[0],ml[1],ml[2],ml[3]))
  
#main function
def main():
file=open("UD.txt","r") #text file opening
ml=list()
i=0
for line in file: #reading line by line and listing all contents as each list
if i!=0:
ll=line.split(",")
ml.append(ll)
i=1
file.close() #closed text file
print("Select from following options:\n") #user given with options
print("A: Search by last name\nB: Search by first name\nC: Search by username\nD: Display all users alphabetically by First name\nE. Display all users alphabetically by Last name\nF: Insert a user\n")
ch=input("Q for quit.")
while(True):
if ch=='Q':#quits
break;
elif ch=='A':#searches content using last name
name=input("Enter last name to Search: ")
i=0
j=0
for ll in ml:
if ll[1]==name:
i=j
break;
j=j+1
if i==0:
print("Not Found")
else:
print('{0: <20}{1: <20}{2: <20}{3: <20}'.format(ml[i][0],ml[i][1],ml[i][2],ml[i][3]))
elif ch=='B':#searches name using first name
name=input("Enter first name to Search: ")
i=0
j=0
for ll in ml:
if ll[0]==name:
i=j
break;
j=j+1
if i==0:
print("Not Found")
else:
print('{0: <20}{1: <20}{2: <20}{3: <20}'.format(ml[i][0],ml[i][1],ml[i][2],ml[i][3]))
elif ch=='C':#searches using usrname
name=input("Enter username to Search: ")
i=0
j=0
for ll in ml:
if ll[2]==name:
i=j
break;
j=j+1
if i==0:
print("Not Found")
else:
print('{0: <20}{1: <20}{2: <20}{3: <20}'.format(ml[i][0],ml[i][1],ml[i][2],ml[i][3]))
elif ch=='D':#sorts the data using first name
rl=ml
rl.sort(key=lambda x:x[0])
output(rl)
elif ch=='E':#sorts data using last name
rl=ml
rl.sort(key=lambda x:x[1])
output(rl)
elif ch=='F':#writest to text file
det=input("Enter user info in the following format: First name, last name, username, password:")
file=open("UD.txt","a")
file.write("\n")
file.write(det)
file.close
print("Select from following options:\n")
print("A: Search by last name\nB: Search by first name\nC: Search by username\nD: Display all users alphabetically by First name\nE. Display all users alphabetically by Last name\nF: Insert a user\n")
ch=input("Q for quit.")

if __name__ == '__main__':
main()

#output function for D and E options #prints the list if provided def output (data): print(" (0: <20) I1: <20 12: <20) [3: <20)"-format ("PIRST NAME","LAST NAME""USERNAME","PASSWORD")) for ml in data: print ( '{0: く20H1; <20 } {2: <20}{3: <20 },"format (ril [oj,nl[1],ml [2],m1 [3])) main function def main): file=open ("UD-hat", "r") ml-list ) text file opening i-0 for line in file: #reading line by line and listing all contents as each list 11-line.split(",) ml.append (11) file.close ) print ("select from following options:\n") #user given with options print ("A: Search by last namelnB: Search by first name nC: Search by ranD: Display all users alphabetically by First namelnE. Dis ch-input("O for quit.") while (True): if ch-'0':#quits #c10ธed file text break; elif ch-: ' A':#searches content using last name name-input ("Enter last name to Search:") for 1l in ml: if 11[1]name: i-j break;

34 35 break; 36 37 j-j+1 if İ--0: 38 print ("Not Found") 39 else: 40 <20)(1: elif ch--'3':#searches name using first name name-input ("2nter first name to Search: print('{0: <20}{2: く2아 { 3: <20},"format(ml [i][0],ml [i] [1],ml [i] [2],ml [i] [3])) 41 42 i-0 43 45 46 for 1l in ml: if llo]--name: 47 48 49 break j-j+1 50 51 print("Not Found") 52 else: <20)(2: -20)(3: <20 }'.format (ml [i][0],al [i] [1],ml [i] [2],m1 [i] [3])) 53 print('{0: <20 } {1: 54 elif ch--'C'; earches using uamana name-input ("Enter as to Search: ") S5 56 57 S8 Eor 1l in ml: if 11 [2]=-name : 60 break; 61 j-j+1 62 63 64 if İ--0: print ("Not Found") 65 else:

56 i-0 57 58 for 11 in ml: 59 if 11 121--name: 60 61 break; i-j+1 62 63 64 print ("Not Found") 65 clsc: print' 10: <20)1: <20 (2: <20H3: <20'.format (ml [i] I0] ,mli] 1,mli] I2],ml i [3])) elif ch='D':#sorts the data using first name 67 68 rl.sort (key-lambda x:xI0]) output (rl) elif ch": 'E':#sorts data using last name 69 70 71 72 rl-ml 73 rl.sort (key-lambda x:x[1]) output (rl) elif ch--'F' : #KKAARak to text file det-input ("Enter user info in the file=open ("UD.ia紘", "a") file.write("n") 74 75 following format: First last password:") 76 name, name, umaamam , 78 79 file.write (det) file.close 80 print ("Select from following options:n") print ("A: Search by last name\nB: Search by first name\nC: Search by waamam忘\nD: Display all users alphabetically by Pirst name\nE, 1 ch-input (" for quit.") 81 82 84 85 86 曱if-name一-' 87 maLn' main)

Sellect from folLowing optilons: A: Search by last name B Search by first name C: Search by username D: Display all users alphabetically by First name E. Display all users alphabetically by Last name F: Insert a user for quit.A Enter last name to Search: Edward Paul Edward 9891ds ped332 Select from following options: A: Search by last name B: Search by first name C: Search by username D: Display all users alphabetically by First name E. Display all users alphabetically by Last name F: Insert a user Q for quit.B Enter first name to Search: name Not Found Select from following options: A: Search by last name B: Search by first name C: Search by username D: Display all users alphabetically by First name E. Display all users alphabetically by Last name F: Insert a user Q for quit.c

Q for quit.c Enter username to Search: ped332 Paul 9891ds ped332 Select from following options: A: Search by last name B Search by first name C: Search by username D: Display all users alphabetically by First name E. Display all users alphabetically by Last name F: Insert a user Q for quit.D FIRST NAME LAST NAME PASSWORD Dave Dcon dcf987 BHYW4fw Dell Grant dgr803 Sb83d2d lki065 Lisa Kate dgw6234 Mike Kress mkr212 UNNHS322 Nomi nmh223 3282jd3d2 Paul Edward 9891ds ped332 Sam DDal sdd233 Pad231 Youyou Tranten dsid21kk ytr876

Select from following options: A: Search by last name B: Search by first name C: Search by username D: Display all users alphabetically by First name E. Display all users alphabetically by Last name F: Insert a user for quit-E FIRST NAME LAST NAME PASSNORD sdd233 Pad231 Sam DDal Dave Dcon dcf987 BHYW4fw Paul Edward 9891ds ped332 Dell Grant dgr803 Sb83d2d Lisa Kate lki065 dgw6234 Mike Kress mkr212 UNNHS322 Nomi Mhanken nmh223 3282jd3d2 Youyou Tranten dsid21kk ytr876 Select from following options: A: Search by last name Search by first name C: Search by username D: Display all users alphabetically by First name E. Display all users alphabetically by Last name F: Insert a user

Select from following options: A: Search by last name B: Search by first name C: Search by username D: Display all users alphabetically by First name E. Display all users alphabetically by Last name F: Insert a user Q for quit.F Enter user info in the following format: First name, last name, username, password:new, new, new, new Select from following options: A: Search by last name B: Search by first name C: Search by username D: Display all users alphabetically by First name E. Display all users alphabetically by Last name F Insert a user Q for quit.o