| Line 133... |
Line 133... |
| 133 |
#stmt = session.query(PrivateDeals).filter_by(isActive=1).filter(now().between(PrivateDeals.startDate, PrivateDeals.endDate)).subquery()
|
133 |
#stmt = session.query(PrivateDeals).filter_by(isActive=1).filter(now().between(PrivateDeals.startDate, PrivateDeals.endDate)).subquery()
|
| 134 |
#query = session.query(Item, privateDealAlias.dealPrice).outerjoin((privateDealAlias, Item.id==privateDealAlias.item_id)).filter(Item.status != status.PHASED_OUT)
|
134 |
#query = session.query(Item, privateDealAlias.dealPrice).outerjoin((privateDealAlias, Item.id==privateDealAlias.item_id)).filter(Item.status != status.PHASED_OUT)
|
| 135 |
tuples = session.query(Tag_Listing, Item).join((Item, Item.id==Tag_Listing.item_id)).filter(or_(Item.status==status.ACTIVE, Item.status==status.PAUSED_BY_RISK, Item.status==status.PARTIALLY_ACTIVE))
|
135 |
tuples = session.query(Tag_Listing, Item).join((Item, Item.id==Tag_Listing.item_id)).filter(or_(Item.status==status.ACTIVE, Item.status==status.PAUSED_BY_RISK, Item.status==status.PARTIALLY_ACTIVE))
|
| 136 |
projection={'defaultImageUrl':1}
|
136 |
projection={'defaultImageUrl':1}
|
| 137 |
for tag, item in tuples:
|
137 |
for tag, item in tuples:
|
| - |
|
138 |
if item.brand == "Live Demo":
|
| - |
|
139 |
continue
|
| 138 |
if not catalogMap.has_key(item.catalog_item_id):
|
140 |
if not catalogMap.has_key(item.catalog_item_id):
|
| 139 |
catalogObj = {}
|
141 |
catalogObj = {}
|
| 140 |
catalogObj['title'] = " ".join(filter(None, [item.brand, item.model_name, item.model_number]))
|
142 |
catalogObj['title'] = " ".join(filter(None, [item.brand, item.model_name, item.model_number]))
|
| 141 |
catalogObj['brand'] = (item.brand)
|
143 |
catalogObj['brand'] = (item.brand)
|
| 142 |
if item.brand == 'Huawei' or item.brand == 'Honor':
|
144 |
if item.brand == 'Huawei' or item.brand == 'Honor':
|