def all_bank_accts(self, client_id):
self.proj_zero_log("Attempting to get all bank accounts...")
sql = "select * from bank_accounts where holder_id = %s"
cursor = connection.cursor()
cursor.execute(sql, [client_id])
records = cursor.fetchall()
bank_acct_list = []
for record in records:
bank_acct = BankAcct(record[0], record[1], record[2],
float(str(record[3])), record[4])
bank_acct_list.append(bank_acct.json())
if records:
return bank_acct_list
else:
raise ResourceNotFound("Client not found.")
def some_bank_accts(
self, client_id,
conditions): # Condition req. for Pr. 0 hardcoded below:
self.proj_zero_log(
"Attempting to get bank accounts meeting condition...")
sql = "select * from bank_accounts where holder_id = %s and funds < 2000 and funds > 400"
cursor = connection.cursor()
cursor.execute(sql, [client_id])
records = cursor.fetchall()
bank_acct_list = []
for record in records:
bank_acct = BankAcct(record[0], record[1], record[2],
float(str(record[3])), record[4])
bank_acct_list.append(bank_acct.json())
if records:
return bank_acct_list
else:
raise ResourceNotFound("Client not found.")