WebSVN – SmartDukaan – Diff – //trunk/PyProj/src/shop2020/model/v1/catalog/impl/DataAcessors.py

 def get_all_fbd_listed_items():
     return Amazonlisted.query.filter(Amazonlisted.isFbd==True).all()
 def get_bulk_pricing_for_items(itemIds):
     itemMap = {}
+    if len(itemIds) ==0:
+        items = BulkItemPricing.query.all()
+    else:
-    items = BulkItemPricing.query.filter(BulkItemPricing.item_id.in_(itemIds)).all()
+        items = BulkItemPricing.query.filter(BulkItemPricing.item_id.in_(itemIds)).all()
     for item in items:
         if not itemMap.has_key(item.item_id):
             itemMap[item.item_id] = [to_t_bulk_pricing(item)]
         else:
             (itemMap.get(item.item_id)).append(to_t_bulk_pricing(item))
 def delete_bulk_pricing_for_item(itemId):
     session.query(BulkItemPricing).filter_by(item_id=itemId).delete()
     session.commit()
     return True
+def update_bulk_prices_on_production(itemId, bulkItemPricingList):
+    session.query(BulkItemPricing).filter_by(item_id=itemId).delete()
+    session.commit()
+    for bulkItem in bulkItemPricingList:
+        d_bulkItem = BulkItemPricing()
+        d_bulkItem.id = bulkItem.id
+        d_bulkItem.price = bulkItem.price
+        d_bulkItem.quantity = bulkItem.quantity
+        d_bulkItem.item_id = bulkItem.item_id
+    session.commit()
 if __name__=='__main__':
     DataService.initialize()
-    ut = get_bulk_pricing_for_items([21053])
+    #update_bulk_prices_on_production(21053,[])
-    print ut
-    ut= ut.get(21053)
-    ut = sorted(ut, key=lambda x: x.quantity, reverse=False)
+    print get_bulk_pricing_for_items([])
-    print ut

Subversion Repositories SmartDukaan

(root)//trunk/PyProj/src/shop2020/model/v1/catalog/impl/DataAcessors.py – Rev 18414 → 18450