Dfyjkt

I am not very familiar with Python or SQL and have been tasked with creating a search results page to display user information from an SQL database. I am using flask, sending JSON objects from the python back-end to the javascript/jquery front-end. I have managed to display a user when there is only one user returned from a search (a search by email address) with the following code:

 user = db.execute(
 'SELECT * FROM user WHERE email = ?', (emailInput,)
 ).fetchone()
 if user is None:
 user_details = 
 'first' : 'error'
 
 y = json.dumps(user_details)
 return jsonify(y)
 if user['first'] is None:
 first = ""
 else:
 first = user['first']
 if user['email'] is None:
 email = ""
 else:
 email = user['email']
 if user['last'] is None:
 last = ""
 else:
 last = user['last']
 if user['address_line1'] is None:
 address_line1 = ""
 else:
 address_line1 = user['address_line1']
 if user['address_line2'] is None:
 address_line2 = ""
 else:
 address_line2 = user['address_line2']
 if user['username'] is None:
 username = ""
 else:
 username = user['username']
 user_details = 
 'first': first,
 'last': last,
 'email': email,
 'address1': address_line1,
 'address2': address_line2,
 'username': username
 
 y = json.dumps(user_details)
 return jsonify(y)

Now I want to upgrade this code with a fetchall() to return the user_details of every user fetched by the SQL call but I don't know how to go about it. Thanks in advance for the help.

EDIT:
what I really need help with is turning multiple structs like these:

 user_details = 
 'first': first,
 'last': last,
 'email': email,
 'address1': address_line1,
 'address2': address_line2,
 'username': username
 

into one big struct like this:

 users = 
 user_details1 = 
 'first': first,
 'last': last,
 'email': email,
 'address1': address_line1,
 'address2': address_line2,
 'username': username
 
 user_details2 = 
 'first': first,
 'last': last,
 'email': email,
 'address1': address_line1,
 'address2': address_line2,
 'username': username
 
 etc.
 

Instead of spending a few hours solving this specific SQL problem, spend a few hours learning an ORM like sqlalchemy so you never have to write SQL again :)

fetchall returns a list of lists, so you just need to iterate over the outer list (rows of the table). For example:

users = db.execute(
 'SELECT * FROM user WHERE email = ?', (emailInput,)
 ).fetchall()
for user in users:
 if user['first'] is None:
 <etc>