| Line 2700... |
Line 2700... |
| 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 session.query(func.count(distinct(Item.catalog_item_id))).join((PrivateDeals,Item.id==PrivateDeals.item_id)).filter(PrivateDeals.isActive==True)
|
2705 |
return session.query(func.count(distinct(Item.catalog_item_id))).join((PrivateDeals,Item.id==PrivateDeals.item_id)).filter(PrivateDeals.isActive==True).scalar()
|
| 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 []
|