def searchResources(self, args): resourcename = args.get("resourcename") supplierid = args.get("supplierid") attributename = args.get("attributename") dao = ResourcesDAO() resources_list = [] if (len(args) == 2) and resourcename and supplierid: resources_list = dao.getResourcesByNameAndSupplier(resourcename, supplierid) elif (len(args) == 1) and resourcename: resources_list = dao.getResourcesByName(resourcename) elif (len(args) == 1) and supplierid: resources_list = dao.getResourcesBySupplier(supplierid) elif (len(args) == 1) and attributename: resources_list = dao.getResourcesByAttributeName(attributename) else: return jsonify(Error="Malformed query string"), 400 result_list = [] for row in resources_list: result = self.build_resource_dict(row) result_list.append(result) return jsonify(Resources=result_list)
def searchResources(self, args): rid = args.get('rid') rname = args.get('rname') rtype = args.get('rtype') rprice = args.get('rprice') rlocation = args.get('rlocation') rstock = args.get('rstock') dao = ResourcesDAO() resources_list = [] if (len(args) == 5) and rname and rtype and rprice and rstock and rlocation: resources_list = dao.getResourcesByNameandTypeandPriceandStockandLocation( rname, rtype, rprice, rstock, rlocation) if (len(args) == 4) and rname and rtype and rprice and rstock: resources_list = dao.getResourcesByNameandTypeandPriceandStock( rname, rtype, rprice, rstock) if (len(args) == 4) and rname and rtype and rprice and rlocation: resources_list = dao.getResourcesByNameandTypeandPriceandLocation( rname, rtype, rprice, rlocation) if (len(args) == 4) and rname and rtype and rstock and rlocation: resources_list = dao.getResourcesByNameandTypeandStockandLocation( rname, rtype, rstock, rlocation) if (len(args) == 4) and rname and rprice and rstock and rlocation: resources_list = dao.getResourcesByNameandPriceandStockandLocation( rname, rprice, rstock, rlocation) if (len(args) == 4) and rtype and rprice and rstock and rlocation: resources_list = dao.getResourcesByTypeandPriceandStockandLocation( rtype, rprice, rstock, rlocation) if (len(args) == 3) and rname and rtype and rprice: resources_list = dao.getResourcesByNameandTypeandPrice( rname, rtype, rprice) if (len(args) == 3) and rname and rtype and rstock: resources_list = dao.getResourcesByNameandTypeandStock( rname, rtype, rstock) if (len(args) == 3) and rname and rtype and rlocation: resources_list = dao.getResourcesByNameandTypeandLocation( rname, rtype, rlocation) if (len(args) == 3) and rname and rprice and rstock: resources_list = dao.getResourcesByNameandPriceandStock( rname, rprice, rstock) if (len(args) == 3) and rname and rprice and rlocation: resources_list = dao.getResourcesByNameandPriceandLocation( rname, rprice, rlocation) if (len(args) == 3) and rname and rstock and rlocation: resources_list = dao.getResourcesByNameandStockandLocation( rname, rstock, rlocation) if (len(args) == 3) and rtype and rprice and rstock: resources_list = dao.getResourcesByTypeandPriceandStock( rtype, rprice, rstock) if (len(args) == 3) and rtype and rprice and rlocation: resources_list = dao.getResourcesByTypeandPriceandLocation( rtype, rprice, rlocation) if (len(args) == 3) and rtype and rstock and rlocation: resources_list = dao.getResourcesByTypeandStockandLocation( rtype, rstock, rlocation) if (len(args) == 3) and rprice and rstock and rlocation: resources_list = dao.getResourcesByPriceandStockandLocation( rprice, rstock, rlocation) if (len(args) == 2) and rname and rtype: resources_list = dao.getResourcesByNameandType(rname, rtype) if (len(args) == 2) and rname and rprice: resources_list = dao.getResourcesByNameandPrice(rname, rprice) if (len(args) == 2) and rname and rstock: resources_list = dao.getResourcesByNameandStock(rname, rstock) if (len(args) == 2) and rname and rlocation: resources_list = dao.getResourcesByNameandLocation( rname, rlocation) if (len(args) == 2) and rtype and rprice: resources_list = dao.getResourcesByTypeandPrice(rtype, rprice) if (len(args) == 2) and rtype and rstock: resources_list = dao.getResourcesByTypeandStock(rtype, rstock) if (len(args) == 2) and rtype and rlocation: resources_list = dao.getResourcesByTypeandLocation( rtype, rlocation) if (len(args) == 2) and rprice and rstock: resources_list = dao.getResourcesByPriceandStock(rprice, rstock) if (len(args) == 2) and rprice and rlocation: resources_list = dao.getResourcesByPriceandLocation( rprice, rlocation) if (len(args) == 2) and rstock and rlocation: resources_list = dao.getResourcesByStockandLocation( rstock, rlocation) if (len(args) == 1) and rname: resources_list = dao.getResourcesByName(rname) if (len(args) == 1) and rtype: resources_list = dao.getResourcesByType(rtype) if (len(args) == 1) and rprice: resources_list = dao.getResourcesByPrice(rprice) if (len(args) == 1) and rstock: resources_list = dao.getResourcesByStock(rstock) if (len(args) == 1) and rlocation: resources_list = dao.getResourcesByLocation(rlocation) else: return jsonify(Error="Malformed query string"), 400 result_list = [] for row in resources_list: result = self.build_resource_dict(row) result_list.append(result) return jsonify(Resources=result_list)