def get_account_userid(userid):
sql = "SELECT * FROM banking.accounts where userid = %s"
cursor = connection.cursor()
cursor.execute(sql, [userid])
records = cursor.fetchall()
acct_list = []
for record in records:
acct = Accounts(record[0], record[1], record[2], record[3])
acct_list.append(acct.json())
return acct_list
def all_accts():
sql = "SELECT * FROM banking.accounts"
cursor = connection.cursor()
cursor.execute(sql)
records = cursor.fetchall()
acct_list = []
for record in records:
acct = Accounts(record[0], record[1], record[2], record[3])
acct_list.append(acct.json())
return acct_list
def get_account_userid_rng(userid, high, low):
sql = "SELECT * FROM banking.accounts where userid = %s and balance <= %s and balance >=%s"
cursor = connection.cursor()
cursor.execute(sql, [userid], [high], [low])
records = cursor.fetchall()
acct_list = []
for record in records:
acct = Accounts(record[0], record[1], record[2], record[3])
if float(acct.balance) < int(high) and float(
acct.balance) > int(low):
acct_list.append(acct.json())
else:
acct_list.clear()
return acct_list
