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

             # use the opener to fetch a URL
             res = opener.open(top_level_url + "cache-admin/HomePageSnippets?_method=delete")
             print "Successfully cleared home page cache" + res.read()
     except:
         print "Unable to clear cache, still should continue with other operations"
+def get_pending_orders_inventory():
+    """
+    Returns a list of inventory stock for items for which there are pending orders.
+    """
+    pending_items_inventory = session.query(CurrentInventorySnapshot.item_id, func.sum(CurrentInventorySnapshot.availibility), func.sum(CurrentInventorySnapshot.reserved)).group_by(CurrentInventorySnapshot.item_id).having(func.sum(CurrentInventorySnapshot.reserved) > 0).all()
+    return pending_items_inventory
 def close_session():
     if session.is_active:
         print "session is active. closing it."
         session.close()

Subversion Repositories SmartDukaan