def get_all_users(): # Retrieve all User from User and return
sql = "SELECT * FROM users"
cursor = connection.cursor()
cursor.execute(sql)
records = cursor.fetchall()
user_list = []
for record in records:
users = Users(record[0], record[1], record[2], record[3],
record[4], record[5])
user_list.append(users.json())
return user_list
def get_all_users():
sql = "SELECT * FROM banking.users"
cursor = connection.cursor()
cursor.execute(sql)
records = cursor.fetchall()
user_list = []
for record in records:
user = Users(record[0], record[1], record[2], record[3])
user_list.append(user.json())
return user_list
