def getToolsById(self, rid):
dao = ToolsDAO()
row = dao.getToolsById(rid)
if not row:
return jsonify(Error="Tools Not Found"), 404
else:
tools = self.build_tools_dict(row)
return jsonify(Tools=tools)
def getAllTools(self):
dao = ToolsDAO()
tools_list = dao.getAllTools()
result_list = []
for row in tools_list:
result = self.build_tools_dict(row)
result_list.append(result)
return jsonify(Tools=result_list)
def getToolsSuppliersByRegion(self, region):
dao = ToolsDAO()
suppliers_list = dao.getToolsSuppliersByRegion(region)
if not suppliers_list:
return jsonify(Error="No Suppliers found"), 404
else:
result_list = []
for row in suppliers_list:
result = self.build_suppliertools_dict(row)
result_list.append(result)
return jsonify(Suppliers=result_list)
def getToolsByPrice(self, price):
dao = ToolsDAO()
tools_list = dao.getToolsByPrice(price)
if not tools_list:
return jsonify(Error="No Tools found"), 404
else:
result_list = []
for row in tools_list:
result = self.build_tools_dict(row)
result_list.append(result)
return jsonify(Tools=result_list)
def searchToolsRequests(self, args):
if len(args) > 4:
return jsonify(Error="Malformed search string."), 400
else:
rid = args.get("rid")
name = args.get("name")
brand = args.get("brand")
price = args.get("price")
dao = ToolsDAO()
tools_list = []
if (len(args) == 2) and name and brand:
tools_list = dao.getToolsByRequestsNameAndBrand(name, brand)
elif (len(args) == 1) and rid:
tools_list = dao.getToolsRequestsById(rid)
elif (len(args) == 1) and name:
tools_list = dao.getToolsRequestsByName(name)
elif (len(args) == 1) and brand:
tools_list = dao.getToolsRequestsByBrand(brand)
elif (len(args) == 1) and price:
tools_list = dao.getToolsRequestsByPrice(price)
else:
return jsonify(Error="Malformed query string"), 400
result_list = []
for row in tools_list:
result = self.build_requesttools_dict(row)
result_list.append(result)
return jsonify(Tools=result_list)
def insertTools(self, form):
if len(form) != 5:
return jsonify(Error="Malformed POST request"), 400
else:
sid = form['sid']
qty = form['qty']
name = form['name']
brand = form['brand']
price = form['price']
if sid and qty and name and brand and price:
rid = ResourcesDAO().insert(sid, qty)
dao = ToolsDAO()
dao.insert(rid, name, brand, price)
result = self.build_tools_attributes(rid, name, brand, price)
return jsonify(Tools=result), 201
else:
return jsonify(
Error="Unexpected attributes in POST request"), 400