| Line 129... |
Line 129... |
| 129 |
tagRankingList = [catalogId for (catalogId,) in tagRankingList]
|
129 |
tagRankingList = [catalogId for (catalogId,) in tagRankingList]
|
| 130 |
|
130 |
|
| 131 |
catalogMap = {}
|
131 |
catalogMap = {}
|
| 132 |
#stmt = session.query(PrivateDeals).filter_by(isActive=1).filter(now().between(PrivateDeals.startDate, PrivateDeals.endDate)).subquery()
|
132 |
#stmt = session.query(PrivateDeals).filter_by(isActive=1).filter(now().between(PrivateDeals.startDate, PrivateDeals.endDate)).subquery()
|
| 133 |
#query = session.query(Item, privateDealAlias.dealPrice).outerjoin((privateDealAlias, Item.id==privateDealAlias.item_id)).filter(Item.status != status.PHASED_OUT)
|
133 |
#query = session.query(Item, privateDealAlias.dealPrice).outerjoin((privateDealAlias, Item.id==privateDealAlias.item_id)).filter(Item.status != status.PHASED_OUT)
|
| 134 |
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)).filter(Tag_Listing.active==True)
|
134 |
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 |
projection={'defaultImageUrl':1}
|
135 |
projection={'defaultImageUrl':1}
|
| 136 |
for tag, item in tuples:
|
136 |
for tag, item in tuples:
|
| 137 |
if not catalogMap.has_key(item.catalog_item_id):
|
137 |
if not catalogMap.has_key(item.catalog_item_id):
|
| 138 |
catalogObj = {}
|
138 |
catalogObj = {}
|
| 139 |
catalogObj['title'] = " ".join(filter(None, [item.brand, item.model_name, item.model_number]))
|
139 |
catalogObj['title'] = " ".join(filter(None, [item.brand, item.model_name, item.model_number]))
|