| Line 197... |
Line 197... |
| 197 |
catalogMap = {}
|
197 |
catalogMap = {}
|
| 198 |
# stmt = session.query(PrivateDeals).filter_by(isActive=1).filter(now().between(PrivateDeals.startDate, PrivateDeals.endDate)).subquery()
|
198 |
# stmt = session.query(PrivateDeals).filter_by(isActive=1).filter(now().between(PrivateDeals.startDate, PrivateDeals.endDate)).subquery()
|
| 199 |
# query = session.query(Item, privateDealAlias.dealPrice).outerjoin((privateDealAlias, Item.id==privateDealAlias.item_id)).filter(Item.status != status.PHASED_OUT)
|
199 |
# query = session.query(Item, privateDealAlias.dealPrice).outerjoin((privateDealAlias, Item.id==privateDealAlias.item_id)).filter(Item.status != status.PHASED_OUT)
|
| 200 |
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))
|
200 |
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))
|
| 201 |
projection = {'defaultImageUrl':1}
|
201 |
projection = {'defaultImageUrl':1}
|
| - |
|
202 |
excludeBrands = ["Live Demo", "FOC", "Dummy", "FOC HANDSET"]
|
| 202 |
for tag, item in tuples:
|
203 |
for tag, item in tuples:
|
| 203 |
if item.brand == "Live Demo":
|
204 |
if item.brand in :
|
| 204 |
continue
|
205 |
continue
|
| 205 |
if not catalogMap.has_key(item.catalog_item_id):
|
206 |
if not catalogMap.has_key(item.catalog_item_id):
|
| 206 |
catalogObj = {}
|
207 |
catalogObj = {}
|
| 207 |
catalogObj['feature'] = ""
|
208 |
catalogObj['feature'] = ""
|
| 208 |
catalogObj['title'] = " ".join(filter(None, [item.brand, item.model_name, item.model_number]))
|
209 |
catalogObj['title'] = " ".join(filter(None, [item.brand, item.model_name, item.model_number]))
|