| Line 130... |
Line 130... |
| 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)).filter(Tag_Listing.active==True)
|
| 135 |
projection={'thumbnailImageUrl':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]))
|
| 140 |
catalogObj['brand'] = item.brand
|
140 |
catalogObj['brand'] = item.brand
|
| 141 |
catalogObj['identifier'] = item.catalog_item_id
|
141 |
catalogObj['identifier'] = item.catalog_item_id
|
| 142 |
catalogObj['items'] = {}
|
142 |
catalogObj['items'] = {}
|
| 143 |
filterMap = {"_id":item.catalog_item_id}
|
143 |
filterMap = {"_id":item.catalog_item_id}
|
| 144 |
#Dont include it catalog not available
|
144 |
#Dont include it catalog not available
|
| 145 |
try:
|
145 |
try:
|
| 146 |
catalogObj['imageUrl'] = get_mongo_connection(options.mongoHost).CONTENT.siteContent.find_one(filterMap, projection)['thumbnailImageUrl']
|
146 |
catalogObj['imageUrl'] = get_mongo_connection(options.mongoHost).CONTENT.siteContent.find_one(filterMap, projection)['defaultImageUrl']
|
| 147 |
print catalogObj['imageUrl']
|
147 |
print catalogObj['imageUrl']
|
| 148 |
except:
|
148 |
except:
|
| 149 |
try:
|
149 |
try:
|
| 150 |
catalogObj['imageUrl'] = 'http://api.profittill.com/uploads/campaigns/' + str(item.catalog_item_id) + '.jpg'
|
150 |
catalogObj['imageUrl'] = 'http://api.profittill.com/uploads/campaigns/' + str(item.catalog_item_id) + '.jpg'
|
| 151 |
except:
|
151 |
except:
|