fetchAccessMap.py

from mysql import connector

def fetchAccessMap(userEmail,
                   dbConnection,
                   patientOrDoctor # "doctor" or "patient"
                   ):
    
    cursor = dbConnection.cursor()

    if patientOrDoctor == "doctor":
        query = ("SELECT u.FirstName, u.LastName, u.Email FROM users u"
                 "JOIN accessMap AM" 
                 "ON AM.patient = u.Email"
                 "WHERE AM.doctor = %(EmailVal)s"
                )
    else:
        query = ("SELECT u.FirstName, u.LastName, u.Email FROM users u" 
                 "JOIN accessMap AM "
                 "ON AM.doctor = u.Email"
                 "WHERE AM.patient = %(EmailVal)s"
                )


    queryData = {
      'emailVal': userEmail 
    } # user primary key
    
    try:
        cursor.execute(query, queryData) # execute the changes
    except:
        return 2 #errorval

    
    returnList = []
    for (FirstName, LastName, Email) in cursor:
        # iterate through a set of tuples
        # the tuples are the rows
        returnList.append((FirstName, LastName, Email)) 


    cursor.close() # close cursor
    dbConnection.close() # close connection

    return returnList #return the map