Subversion Repositories SmartDukaan

Rev

Rev 5333 | Rev 5381 | Go to most recent revision | Show entire file | Ignore whitespace | Details | Blame | Last modification | View Log | RSS feed

Rev 5333 Rev 5336
Line 40... Line 40...
40 
from_user = "cnc.center@shop2020.in"
 40 
from_user = "cnc.center@shop2020.in"
41 
from_pwd = "5h0p2o2o"
 41 
from_pwd = "5h0p2o2o"
42 
 
 42 
 
43 
def initialize(dbname='catalog', db_hostname="localhost"):
 43 
def initialize(dbname='catalog', db_hostname="localhost"):
44 
    DataService.initialize(dbname, db_hostname)
 44 
    DataService.initialize(dbname, db_hostname)
45 
    __clear_item_availability_cache()
 - 
 
46 
 
 45
47 
def get_all_items_by_status(status, offset=0, limit=None):
 46 
def get_all_items_by_status(status, offset=0, limit=None):
48 
    query = Item.query
 47 
    query = Item.query
49 
    if status is not None:
 48 
    if status is not None:
50 
        query = query.filter_by(status=status)
 49 
        query = query.filter_by(status=status)
51 
    query = query.order_by(Item.product_group, Item.brand, Item.model_number, Item.model_name).offset(offset)
 50 
    query = query.order_by(Item.product_group, Item.brand, Item.model_number, Item.model_name).offset(offset)
Line 727... Line 726...
727 
        return [item_availability.warehouseId, item_availability.expectedDelay, item_availability.billingWarehouseId, item_availability.sellingPrice]
 726 
        return [item_availability.warehouseId, item_availability.expectedDelay, item_availability.billingWarehouseId, item_availability.sellingPrice]
728 
    else:
 727 
    else:
729 
        __update_item_availability_cache(item_id)
 728 
        __update_item_availability_cache(item_id)
730 
        return get_item_availability_for_location(item_id)
 729 
        return get_item_availability_for_location(item_id)
731
730
732 
def __clear_item_availability_cache():
 731 
def clear_item_availability_cache():
733 
    ItemAvailabilityCache.query.delete()
 732 
    ItemAvailabilityCache.query.delete()
734 
    session.commit()
 733 
    session.commit()
735 
 
 734 
 
736 
def __update_item_availability_cache(item_id):
 735 
def __update_item_availability_cache(item_id):
737 
    """
 736 
    """