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

 '''
 from elixir import *
 from shop2020.model.v1.catalog.impl import DataService
 from shop2020.model.v1.catalog.impl.DataService import Item, \
     Warehouse, ItemInventoryHistory, CurrentInventorySnapshot, ItemInfo,\
-    ItemChangeLog, Category, EntityIDGenerator
+    ItemChangeLog, Category, EntityIDGenerator, VendorItemPricing
 from shop2020.thriftpy.model.v1.catalog.ttypes import \
     InventoryServiceException, status
 from shop2020.model.v1.catalog.impl.Convertors import to_t_item
 import datetime
 import sys
 def get_category_object():
     object = Category.get_by(id=1).object
     return object
+def get_item_pricing(item_id, warehouse_id):
+    item = Item.query.filter_by(id=item_id).first()
+    if item is None:
+        raise InventoryServiceException(101, "Bad Item")
+    warehouse = get_Warehouse(warehouse_id)
+    if not warehouse:
+        raise InventoryServiceException(108, "Bad Warehouse")
+    vendor = warehouse.vendor
+    try:
+        item_pricing = VendorItemPricing.query.filter_by(vendor=vendor, item=item).one()
+        return item_pricing
+    except sqlalchemy.orm.exc.MultipleResultsFound:
+        raise InventoryServiceException(110, "Multiple pricing information present for Vendor: " + vendor.name + " and Item: " + str(item_id))
+    except sqlalchemy.orm.exc.NoResultFound:
+        raise InventoryServiceException(111, "Missing pricing information for Vendor: " + vendor.name + " and Item: " + str(item_id))
 def close_session():
     if session.is_active:
         print "session is active. closing it."
         session.close()

Subversion Repositories SmartDukaan

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