WebSVN – SmartDukaan – Diff – /trunk/PyDTR/src/dtr/storage/Mongo.py

     else:
         collection.insert(data)
         get_mongo_connection().Catalog.MasterData.update({'_id':data['sku']},{"$set":{'updatedOn':to_java_date(datetime.now())}},multi=False)
         return {1:"Data added successfully"}
-def searchCollection(class_name, sku, skuBundleId, offset, limit):
+def searchCollection(class_name, sku, skuBundleId):
     data = []
     collection = get_mongo_connection().Catalog[class_name]
+    if sku is not None:
-    cursor = collection.find({'sku':sku})
+        cursor = collection.find({'sku':sku})
-    for val in cursor:
+        for val in cursor:
-        master = list(get_mongo_connection().Catalog.MasterData.find({'_id':val['sku']}))
+            master = list(get_mongo_connection().Catalog.MasterData.find({'_id':val['sku']}))
-        if len(master) > 0:
+            if len(master) > 0:
-            val['brand'] = master[0]['brand']
+                val['brand'] = master[0]['brand']
-            val['source_product_name'] = master[0]['source_product_name']
+                val['source_product_name'] = master[0]['source_product_name']
-            val['skuBundleId'] = master[0]['skuBundleId']
+                val['skuBundleId'] = master[0]['skuBundleId']
-        else:
+            else:
-            val['brand'] = ""
+                val['brand'] = ""
-            val['source_product_name'] = ""
+                val['source_product_name'] = ""
-            val['skuBundleId'] = ""
+                val['skuBundleId'] = ""
-        data.append(val)
+            data.append(val)
+        return data
+    else:
+        skuIds = get_mongo_connection().MasterData.find({'skuBundleId':skuBundleId}).distinct('_id')
+        for sku in skuIds:
+            cursor = collection.find({'sku':sku})
+            for val in cursor:
+                master = list(get_mongo_connection().Catalog.MasterData.find({'_id':val['sku']}))
+                if len(master) > 0:
+                    val['brand'] = master[0]['brand']
+                    val['source_product_name'] = master[0]['source_product_name']
+                    val['skuBundleId'] = master[0]['skuBundleId']
+                else:
+                    val['brand'] = ""
+                    val['source_product_name'] = ""
+                    val['skuBundleId'] = ""
+                data.append(val)
-    return data
+        return data
 def main():

Subversion Repositories SmartDukaan

(root)/trunk/PyDTR/src/dtr/storage/Mongo.py – Rev 14497 → 14499