Question

For this problem, assume salesperson data are stored in a database table named staff. Also assume the columns in the table are named name, carsSold, and totalSales Write a Python function named getSalesSortedByNames. Your function will have 2 parameters. The first parameter is a database cursor and the second parameter is a float. Your function should start by retrieving those rows in the staff table whose totalsales field is equal to the second parameter. (The next paragraph shows the Python code that does this retrieval.) The function should then add each row to a list and have that list sorted by the name field. In order to do this sort, you will need to write a key selector function (hint: the name field is in column 0). Finally, your function should return the sorted list. its second parameter i If your getSalesSortedByNames's first parameter is named cur and named sales, this Python code will retrieve the rows from the database cur.execute 'SELECT FROM staff WHERE totalSales-?', (sales,)) Example and result: Assume that cur is a cursor for a database whose staff table has the following data carsSold totalSales 10.25 8.25 8.25 20.0 name 10 print (getSalesSortedByNames (cur, would result in the following output: 8.25)) "name": "E","carsSold": 6, "totalSales" 8.25), ("name": "H","carsSold": 9, "totalSales": 8.25)1

Answer 1

def getSalesSortedByNames(cur,sales):
    cur.execute('SELECT * FROM staff WHERE totalSales = ?',(sales,))
    rows = cur.fetchall()
    listDict=[]
    for row in rows:
        d={}
        d["name"]=row[0]
        d["carsSold"]=row[1]
        d["totalSales"]=row[2]
        listDict.append(d)
    sList=sorted(listDict,key=lambda i:i["name"])
    return sList