def delete_request(self, request_id):
dao = RequestDAO()
if not dao.getRequestById(request_id):
return jsonify(Error="Post not found."), 404
else:
dao.delete(request_id)
return jsonify(DeleteStatus="OK"), 200
def insert_request_json(self, json):
dao = RequestDAO()
category_id = json['category_id']
person_id = json['person_id']
name = json['name']
quantity = json['quantity']
description = json['description']
needed = quantity
unit_price = json['max_unit_price']
address = json['address']
city = json['city']
zip_code = json['zip_code']
if person_id and category_id and name and needed and description and unit_price and quantity \
and address and city and zip_code:
resource_id = ResourceDAO().insert(person_id, name, quantity,
category_id)
request_id = dao.insert(resource_id, person_id, description,
needed, unit_price, address, city,
zip_code)
result = self.build_request_attributes(request_id, resource_id,
category_id, person_id,
name, quantity, description,
needed, unit_price, address,
city, zip_code)
return jsonify(Request=result), 201
else:
return jsonify(Error="Unexpected attributes in post request"), 400
def get_request_by_id(self, request_id):
dao = RequestDAO()
row = dao.getRequestById(request_id)
if not row:
return jsonify(Error="Post Not Found"), 404
else:
result = self.build_request_dict(row)
return jsonify(Request_Post=result)
def get_total_needed_requests_per_category(self):
dao = RequestDAO()
count_list = dao.getTotalNeededRequestsPerCategory()
result_list = []
for row in count_list:
result = self.build_request_count(row)
result_list.append(result)
return jsonify(Needed_Request_Count=result_list)
def get_all_needed_requests(self):
dao = RequestDAO()
request_list = dao.getAllNeededRequests()
result_list = []
for row in request_list:
result = self.build_request_dict(row)
result_list.append(result)
return jsonify(Needed_Requests=result_list)
def get_needed_requests_by_person_id(self, person_id):
dao = RequestDAO()
request_list = dao.getNeededRequestsByPersonId(person_id)
result_list = []
for row in request_list:
result = self.build_request_dict(row)
result_list.append(result)
return jsonify(Request_Posts=result_list)
def insert_fulfilledRequest(self, form):
if len(form) != 3:
return jsonify(Error="Malformed post request"), 400
else:
dao = FulfilledRequestDAO()
request_id = form['request_id']
person_id = form['person_id']
fquantity = int(form['fquantity'])
if person_id and request_id and fquantity:
requestRow = RequestDAO().getRequestById(request_id)
request = RequestHandler().build_request_dict(requestRow)
sellerAccountRow = AccountDAO().getAccountByPersonId(person_id)
sellerAccount = AccountHandler().build_account_dict(
sellerAccountRow)
buyerAccountRow = AccountDAO().getAccountByPersonId(
int(request.get("person_id")))
buyerAccount = AccountHandler().build_account_dict(
buyerAccountRow)
if request.get("needed") < fquantity:
return jsonify(Error="Resource overflow"), 400
elif buyerAccount.get("balance") < (
fquantity * request.get("max_unit_price")):
return jsonify(Error="Insufficient funds"), 400
else:
transactionTotal = fquantity * request.get(
"max_unit_price")
new_needed = request.get("needed") - fquantity
newSellerBalance = sellerAccount.get(
"balance") + transactionTotal
newBuyerBalance = buyerAccount.get(
"balance") - transactionTotal
fulfilledRequest_id = dao.insert(
request_id, person_id, fquantity,
request.get("max_unit_price"))
RequestDAO().updateStock(int(request.get("request_id")),
new_needed)
AccountDAO().updateBalance(
int(sellerAccount.get("account_id")), newSellerBalance)
AccountDAO().updateBalance(
int(buyerAccount.get("account_id")), newBuyerBalance)
result = self.build_fulfilled_request_attributes(
fulfilledRequest_id, request_id, person_id, fquantity,
request.get("max_unit_price"))
return jsonify(FulfilledRequest=result), 201
else:
return jsonify(
Error="Unexpected attributes in post request"), 400
def update_request(self, request_id, form):
dao = RequestDAO()
if not dao.getRequestById(request_id):
return jsonify(Error="Post not found."), 404
else:
if len(form) != 6:
return jsonify(Error="Malformed update request"), 400
else:
description = form['description']
unit_price = form['max_unit_price']
needed = form['needed']
address = form['address']
city = form['city']
zip_code = form['zip_code']
if int(needed) < 0:
return jsonify(
Error="Cannot put negative value in needed"), 400
if description and unit_price and needed:
dao.update(request_id, description, needed, unit_price,
address, city, zip_code)
row = dao.getRequestById(request_id)
result = self.build_request_dict(row)
return jsonify(Part=result), 200
else:
return jsonify(
Error="Unexpected attributes in update request"), 400
def search_needed_requests(self, args):
max_price = args.get('max_unit_price')
category = args.get('category')
name = args.get('name')
dao = RequestDAO()
if len(args) == 2 and max_price and category:
request_list = dao.getNeededRequestsByMaxPriceAndCategory(
max_price, category)
elif len(args) == 1 and max_price:
request_list = dao.getNeededRequestsByMaxPrice(max_price)
elif len(args) == 1 and category:
request_list = dao.getNeededRequestsByCategory(category)
elif len(args) == 1 and name:
request_list = dao.getNeededRequestsByName(name)
else:
return jsonify(Error="Malformed query string"), 400
result_list = []
for row in request_list:
result = self.build_request_dict(row)
result_list.append(result)
return jsonify(Request_Posts=result_list)
def get_total_needed_requests(self):
dao = RequestDAO()
amount = dao.getTotalNeededRequests()
return jsonify(Total_Needed_Requests=amount)
def get_total_requests(self):
dao = RequestDAO()
amount = dao.getTotalRequests()
return jsonify(Total_Requests=amount)