def delete_account(client_id, account_id):
try:
account = Account(int(account_id), "", 0, int(client_id))
account = AccountService.delete_account(account)
return jsonify(account.json()
), 205 # 205 if success && 404 if no such account
except ResourceNotFound as r:
return r.message, 404
def get_all_accounts(self, client_id):
sql = "SELECT * FROM accounts WHERE account_client_id = %s"
cursor = connection.cursor()
cursor.execute(sql, [client_id])
records = cursor.fetchall()
account_list = []
if records:
for record in records:
account = Account(record[0], record[1], float(record[2]),
record[3])
account_list.append(account.json())
return account_list
else:
raise ResourceNotFound(
f"Client with id: {client_id} has no accounts.")
def get_movie_amount_filter(self, account):
sql = "SELECT * FROM accounts WHERE account_client_id = %s AND ( amount < %s AND amount > s% )"
cursor = connection.cursor()
cursor.execute(
sql, (int(account.account_client_id), float(
account.account_id), float(account.account_amount)))
records = cursor.fetchall
account_list = []
if records:
for record in records:
account = Account(record[0], record[1], float(record[2]),
record[3])
account_list.append(account.json())
return account_list
else:
raise ResourceNotFound(
f"Client with id: {account.account_client_id} has no accounts."
)
def get_all_accounts_in_range(self, account):
sql = "SELECT * FROM accounts WHERE account_client_id = %s"
less = float(account.account_name)
more_than = float(account.account_amount)
cursor = connection.cursor()
cursor.execute(sql, [account.account_client_id])
records = cursor.fetchall()
account_list = []
if records:
for record in records:
temp_account = Account(record[0], record[1], float(record[2]),
record[3])
if less > temp_account.account_amount & temp_account.account_amount > more_than:
account_list.append(temp_account.json())
return account_list
else:
raise ResourceNotFound(
f"Client with id: {account.account_client_id} has no accounts."
)