Subversion Repositories SmartDukaan

Rev

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

Rev 11667 Rev 11741
Line 2697... Line 2697...
2697 
        print 'Exception in updating private deals'
 2697 
        print 'Exception in updating private deals'
2698 
        print e
 2698 
        print e
2699 
        return False
 2699 
        return False
2700 
 
 2700 
 
2701 
def get_private_deals_query():
 2701 
def get_private_deals_query():
2702 
        return session.query(Item).join((PrivateDeals,Item.id==PrivateDeals.item_id)).filter(PrivateDeals.isActive==True).group_by(Item.catalog_item_id)
 2702 
    return session.query(Item).join((PrivateDeals,Item.id==PrivateDeals.item_id)).filter(PrivateDeals.isActive==True).group_by(Item.catalog_item_id)
2703
2703
2704 
def get_private_deals_count():
 2704 
def get_private_deals_count():
2705 
        return get_private_deals_query().count()
 2705 
    return session.query(func.count(distinct(Item.catalog_item_id))).join((PrivateDeals,Item.id==PrivateDeals.item_id)).filter(PrivateDeals.isActive==True)
2706 
 
 2706 
 
2707 
def get_private_deals_catalog_ids(offset,limit):
 2707 
def get_private_deals_catalog_ids(offset,limit):
2708 
    private_deal_items = get_private_deals_query().offset(offset).limit(limit).all()
 2708 
    private_deal_items = get_private_deals_query().offset(offset).limit(limit).all()
2709 
    if private_deal_items is None:
 2709 
    if private_deal_items is None:
2710 
        return []
 2710 
        return []