Esempio n. 1
0
 def getResourceBySupplier(self, collectionCenterID):
     dao = ResourcesDAO()
     resources_list = dao.getResourceByCollectionCenterID(collectionCenterID)
     result_list = []
     for row in resources_list:
         result = self.build_resourcesBySupplier_dict(row)
         result_list.append(result)
     return jsonify(Resource=result_list)
Esempio n. 2
0
    def searchResources(self, args):
        rid = args.get('rid')
        rname = args.get('rname')
        rtype = args.get('rtype')
        buy_free = args.get('buy_free')
        ccid = args.get('ccid')
        marketprice = args.get('marketprice')
        qty = args.get('qty')

        dao = ResourcesDAO()

        if (len(args) == 1) and rid:
            resources_list = dao.getResourceById(rid)
            result_list = []
            for row in resources_list:
                result = self.build_resourcesInf_dict(row)
                result_list.append(result)
            return jsonify(Resource=result_list)


        elif (len(args) == 1) and rname:
            resources_list = dao.getResourceInfoByName(rname)
            result_list = []
            for row in resources_list:
                result = self.build_resourcesInf_dict(row)
                result_list.append(result)
            return jsonify(Resource=result_list)

        elif (len(args) == 1) and rtype:
            resources_list = dao.getResourceInfoByType(rtype)
            result_list = []
            for row in resources_list:
                result = self.build_resourcesInf_dict(row)
                result_list.append(result)
            return jsonify(Resource=result_list)

        elif (len(args) == 1) and buy_free:
            resources_list = dao.getResourceInfoByBF(buy_free)
            result_list = []
            for row in resources_list:
                result = self.build_resourcesInf_dict(row)
                result_list.append(result)
            return jsonify(Resource=result_list)

        elif (len(args) == 1) and ccid:
            resources_list = dao.getResourceByCollectionCenterID(ccid)
            result_list = []
            for row in resources_list:
                result = self.build_resourcesInf_dict(row)
                result_list.append(result)
            return jsonify(Resource=result_list)

        elif (len(args) == 1) and marketprice:
            resources_list = dao.getResourceByMarketPrice(marketprice)
            result_list = []
            for row in resources_list:
                result = self.build_resourcesInf_dict(row)
                result_list.append(result)
            return jsonify(Resource=result_list)

        elif (len(args) == 1) and qty:
            resources_list = dao.getResourceByQty(qty)
            result_list = []
            for row in resources_list:
                result = self.build_resourcesInf_dict(row)
                result_list.append(result)
            return jsonify(Resource=result_list)


        else:
            return jsonify(Error="Malformed query string"), 400
        result_list = []
        for row in resources_list:
            result = self.build_resources_dict(row)
            result_list.append(result)
        return jsonify(Resource=result_list)