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

     for itemId, status in oosStatusMap.iteritems():
         if OOSStatus.query.filter_by(item_id = itemId, date = oosDate).first() is None:
             oosStatus = OOSStatus()
             oosStatus.item_id = itemId
             oosStatus.date = oosDate
-            oosStatus.status = status
+            oosStatus.is_oos = status
             if status == False:
                 order_count = 0
                 if orderCountByItemId.has_key(itemId):
                     order_count = orderCountByItemId[itemId]
             oosStatus.num_orders = order_count
             session.commit()
         else:
             print "OOS Status already exists for ItemID:"+str(itemId)
             """raise InventoryServiceException(101, "OOS Status already exists for ItemID:"+str(itemId) + " & Date:"+oosDate)"""
+def get_oos_statuses_for_x_days_for_item(itemId, days):
+    timestamp = datetime.datetime.now()
+    timestamp = timestamp - datetime.timedelta(days = 6)
+    return OOSStatus.query.filter_by(item_id = itemId).filter(OOSStatus.date > timestamp).all()

Subversion Repositories SmartDukaan