| Line 199... |
Line 199... |
| 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 |
excludeBrands = ["Live Demo", "FOC", "Dummy", "FOC HANDSET"]
|
| 203 |
for tag, item in tuples:
|
203 |
for tag, item in tuples:
|
| 204 |
if item.brand in :
|
204 |
if item.brand in excludeBrands:
|
| 205 |
continue
|
205 |
continue
|
| 206 |
if not catalogMap.has_key(item.catalog_item_id):
|
206 |
if not catalogMap.has_key(item.catalog_item_id):
|
| 207 |
catalogObj = {}
|
207 |
catalogObj = {}
|
| 208 |
catalogObj['feature'] = ""
|
208 |
catalogObj['feature'] = ""
|
| 209 |
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]))
|