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