| Line 15... |
Line 15... |
| 15 |
to_t_vendor_item_pricing
|
15 |
to_t_vendor_item_pricing
|
| 16 |
import datetime
|
16 |
import datetime
|
| 17 |
import sys
|
17 |
import sys
|
| 18 |
from shop2020.utils.Utils import log_entry, to_py_date, log_risky_flag
|
18 |
from shop2020.utils.Utils import log_entry, to_py_date, log_risky_flag
|
| 19 |
from sqlalchemy import desc, asc
|
19 |
from sqlalchemy import desc, asc
|
| - |
|
20 |
from sqlalchemy.orm.exc import MultipleResultsFound, NoResultFound
|
| 20 |
from shop2020.model.v1.catalog.impl.CategoryManager import CategoryManager
|
21 |
from shop2020.model.v1.catalog.impl.CategoryManager import CategoryManager
|
| 21 |
from sqlalchemy.sql.expression import and_, distinct, func
|
22 |
from sqlalchemy.sql.expression import and_, distinct, func
|
| 22 |
from string import Template
|
23 |
from string import Template
|
| 23 |
from shop2020.clients.HelperClient import HelperClient
|
24 |
from shop2020.clients.HelperClient import HelperClient
|
| 24 |
|
25 |
|
| Line 760... |
Line 761... |
| 760 |
vendor = warehouse.vendor
|
761 |
vendor = warehouse.vendor
|
| 761 |
|
762 |
|
| 762 |
try:
|
763 |
try:
|
| 763 |
item_pricing = VendorItemPricing.query.filter_by(vendor=vendor, item=item).one()
|
764 |
item_pricing = VendorItemPricing.query.filter_by(vendor=vendor, item=item).one()
|
| 764 |
return item_pricing
|
765 |
return item_pricing
|
| 765 |
except sqlalchemy.orm.exc.MultipleResultsFound:
|
766 |
except MultipleResultsFound:
|
| 766 |
raise InventoryServiceException(110, "Multiple pricing information present for Vendor: " + vendor.name + " and Item: " + str(item_id))
|
767 |
raise InventoryServiceException(110, "Multiple pricing information present for Vendor: " + vendor.name + " and Item: " + str(item_id))
|
| 767 |
except sqlalchemy.orm.exc.NoResultFound:
|
768 |
except NoResultFound:
|
| 768 |
raise InventoryServiceException(111, "Missing pricing information for Vendor: " + vendor.name + " and Item: " + str(item_id))
|
769 |
raise InventoryServiceException(111, "Missing pricing information for Vendor: " + vendor.name + " and Item: " + str(item_id))
|
| 769 |
|
770 |
|
| 770 |
def add_category(t_category):
|
771 |
def add_category(t_category):
|
| 771 |
category = Category.get_by(id=t_category.id)
|
772 |
category = Category.get_by(id=t_category.id)
|
| 772 |
if category is None:
|
773 |
if category is None:
|