Question

Lab 4: Databased Admin Tool Continued Python

Objective: In the previous lab, you developed an admin tool for username and password management. You accomplished the tasks with Dictionary or List. Here, use class to design your own data structure to accomplish a similar task.

The UD.txt datafile:

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, your program can search for users’ password.

Give the following options:

A: Search by (firstname, lastname) (the first and last name is separated by “,”)

B: Search by username

C: Insert a user

E. Display all users

1. Create a Userdata class based on the “UD.txt”. Create private data fields for FIRST NAME, LAST NAME,USERNAME,PASSWORD. Create an __init__ method to initialize each user object. Create 8 class methods. A set and a get method for each of the data fields (since FIRST NAME, LAST NAME,USERNAME,PASSWORD are all private, you need to use class methods to access them).
2. Save your class object in a list (you need to use a LIST).
3. When user select A, prompt the user “Enter user’s name in the form: Firstname Lastname”

If the user is found, display the user’s password, and return the user to menu.

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

4. When user select B, prompt the user “Enter user’s username:”

If the user is found, display the user’s password, and return the user to menu.

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

5. For C, 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 and dictionaries.
6. For D, display all user data fields.

Draw the UML diagram for the class and upload with your .py file. Follow the file submission rule.

Answer 1

## PYTHON CODE BEGINS ##

# For the regex used in re.split()
import re

# Class for an entry in the database
class UserData:
    # Constructor
    def __init__(self, firstName, lastName, username, password):
        self.__firstName = firstName
        self.__lastName = lastName
        self.__username = username
        self.__password = password
    # Accessors
    def setFirstName(self, firstName):
        self.__firstName = firstName
    def setLastName(self, lastName):
        self.__lastName = lastName  
    def setUsername(self, username):
        self.__username = username
    def setPassword(self, password):
        self.__password = password
    def getFirstName(self):
        return self.__firstName
    def getLastName(self):
        return self.__lastName
    def getUsername(self):
        return self.__username
    def getPassword(self):
        return self.__password

# Function to load up the database form file
def importDatabase():
    db = []
    datafile = open("UD.txt", "r")
    lines = datafile.readlines()
    lines = lines[1:]
    for line in lines:
        line = re.split(', |,', line)
        firstName, lastName, username, password = line
        db.append(UserData(firstName, lastName, username, password))
    return db

# Function to search the database by name
def searchByName(database):
    firstName, lastName = input("Enter user’s name in the form: Firstname Lastname: ").split()
    for entry in database:
        # print("comparing", firstName, "with", entry.getFirstName(), "and", lastName, "with", entry.getLastName())
        if(entry.getFirstName() == firstName and entry.getLastName() == lastName):
            # print("FOUND MATCH!!!")
            print(entry.getPassword())
            return
    print("Not found")

# Function to search the database by username
def searchByUsername(database):
    username = input("Enter user’s username: ")
    for entry in database:
        if(entry.getUsername() == username):
            print(entry.getPassword())
            return
    print("Not found")

# Function to insert a new entry
def insertUser(database):
    firstName, lastName, username, password = input("Enter user info in the following format: First name, last name, username, password: ").split(', ')
    database.append(UserData(firstName, lastName, username, password))

# Function to display all the entries in the database
def displayAllUsers(database):
    for entry in database:
        print("First Name :", entry.getFirstName())
        print("Last Name :", entry.getLastName())
        print("Username :", entry.getUsername())
        print("Password :", entry.getPassword())
        print("")

# Function to display the menu
def menu():
    print('A: Search by (firstname, lastname) (the first and last name is separated by “,”)')
    print('B: Search by username')
    print('C: Insert a user')
    print('D. Display all users')

# Main program
def main():
    database = importDatabase()
    while True:
        menu()
        choice = input()
        if choice in ['A', 'a']:
            searchByName(database)
        elif choice in ['B', 'b']:
            searchByUsername(database)
        elif choice in ['C', 'c']:
            insertUser(database)
        elif choice in ['D', 'd']:
            displayAllUsers(database)
        else:
            break

if __name__ == "__main__":
    main()

## PYTHON CODE ENDS ##