Subversion Repositories SmartDukaan

Rev

Rev 26882 | Rev 26886 | Go to most recent revision | Show entire file | Ignore whitespace | Details | Blame | Last modification | View Log | RSS feed

Rev 26882 Rev 26885
Line 147... Line 147...
147 
                catalogObj['brand'] = ('Huawei', 'Honor')
 147 
                catalogObj['brand'] = ('Huawei', 'Honor')
148 
            if item.brand == 'Mi' or item.brand == 'Xiaomi' or item.brand == 'Redmi':
 148 
            if item.brand == 'Mi' or item.brand == 'Xiaomi' or item.brand == 'Redmi':
149 
                catalogObj['brand'] = ('Mi', 'Xiaomi', 'Redmi')
 149 
                catalogObj['brand'] = ('Mi', 'Xiaomi', 'Redmi')
150 
            catalogObj['identifier'] = item.catalog_item_id
 150 
            catalogObj['identifier'] = item.catalog_item_id
151 
            catalogObj['items'] = {}
 151 
            catalogObj['items'] = {}
152 
            catalogObj['hot_deals'] = "False"
 - 
 
153 
            filterMap = {"_id":item.catalog_item_id}
 152 
            filterMap = {"_id":item.catalog_item_id}
154 
            #Dont include it catalog not available
 153 
            #Dont include it catalog not available
155 
            try:
 154 
            try:
156 
                catalogObj['imageUrl'] = get_mongo_connection(options.mongoHost).CONTENT.siteContent.find_one(filterMap, projection)['defaultImageUrl']
 155 
                catalogObj['imageUrl'] = get_mongo_connection(options.mongoHost).CONTENT.siteContent.find_one(filterMap, projection)['defaultImageUrl']
157 
                print catalogObj['imageUrl']
 156 
                print catalogObj['imageUrl']
Line 177... Line 176...
177 
            catalogObj['create_timestamp'] = to_java_date(tag.create_timestamp)
 176 
            catalogObj['create_timestamp'] = to_java_date(tag.create_timestamp)
178 
            catalogMap[item.catalog_item_id] = catalogObj
 177 
            catalogMap[item.catalog_item_id] = catalogObj
179 
 
 178 
 
180 
        catalogObj = catalogMap.get(item.catalog_item_id)
 179 
        catalogObj = catalogMap.get(item.catalog_item_id)
181 
 
 180 
 
182 
        if tag.hot_deals:
 - 
 
183 
            catalogObj['hot_deals'] = "True"
 181 
        catalogObj['hot_deals'] = tag.hot_deals
184 
        if tag.active and not catalogObj['items'].has_key(item.id):
 182 
        if tag.active and not catalogObj['items'].has_key(item.id):
185 
            catalogObj['items'][item.id] = {'color': item.color.replace("f_", ""), 'tagPricing':[]}
 183 
            catalogObj['items'][item.id] = {'color': item.color.replace("f_", ""), 'tagPricing':[]}
186 
            itemMap = catalogObj['items'].get(item.id)
 184 
            itemMap = catalogObj['items'].get(item.id)
187 
            itemMap['tagPricing'].append(tag)
 185 
            itemMap['tagPricing'].append(tag)
188
186
Line 195... Line 193...
195 
            tags = itemMap['tagPricing']
 193 
            tags = itemMap['tagPricing']
196 
            for tag in tags:
 194 
            for tag in tags:
197 
                itemObj = {'id':('itemtag-%s-%s'%(itemId, tag.tag_id)), 'color_s':itemMap['color'],  'itemId_i': itemId, 'tagId_i':tag.tag_id,
195 
                itemObj = {'id':('itemtag-%s-%s'%(itemId, tag.tag_id)), 'color_s':itemMap['color'],  'itemId_i': itemId, 'tagId_i':tag.tag_id,
198 
                           'mop_f': tag.mop, 'sellingPrice_f': tag.selling_price, 'active_b' : tag.active}
 196 
                           'mop_f': tag.mop, 'sellingPrice_f': tag.selling_price, 'active_b' : tag.active}
199 
            itemObjs.append(itemObj)
 197 
            itemObjs.append(itemObj)
200 
        catalogObj = {'id':'catalog' + str(catalogId), 'rank_i':catalogMap['rank'], 'title_s': catalogMap['title'],'hot_deals_b':catalogMap['hot_deals'],
198 
        catalogObj = {'id':'catalog' + str(catalogId), 'rank_i':catalogMap['rank'], 'title_s': catalogMap['title'],
- 
 
 199 
                      'hot_deals_b':catalogMap['hot_deals'],
201 
                      '_childDocuments_':itemObjs,
 200 
                      '_childDocuments_':itemObjs,
202 
                      'child_b' : len(itemObjs) > 0,
201 
                      'child_b' : len(itemObjs) > 0,
203 
                      'catalogId_i':catalogId,
202 
                      'catalogId_i':catalogId,
204 
                      'imageUrl_s': catalogMap['imageUrl'].replace("saholic", "smartdukaan"),
203 
                      'imageUrl_s': catalogMap['imageUrl'].replace("saholic", "smartdukaan"),
205 
                      'feature_s':catalogMap['feature'],
 204 
                      'feature_s':catalogMap['feature'],
Line 208... Line 207...
208 
                      'subCategoryId_i':catalogMap['subCategoryId']}
 207 
                      'subCategoryId_i':catalogMap['subCategoryId']}
209 
        print catalogObj
 208 
        print catalogObj
210 
        catalogObjs.append(catalogObj)
 209 
        catalogObjs.append(catalogObj)
211 
    solr.delete(q='*:*')
 210 
    solr.delete(q='*:*')
212 
    solr.add(catalogObjs)
 211 
    solr.add(catalogObjs)
213
- 
 
214
- 
 
215
- 
 
216 
    #items = Item.query.filter(Item.risky==True).filter(or_(Item.status==status.ACTIVE)).all()
 - 
 
217 
#    global con
 - 
 
218 
#    if con is None:
 - 
 
219 
#        print "Establishing connection %s host and port %d" %(host,port)
 - 
 
220 
#        try:
 - 
 
221 
#            con = pymongo.MongoClient(host, port)
 - 
 
222 
#        except Exception, e:
 - 
 
223 
#            print e
 - 
 
224 
#            return None
 - 
 
225 
#    return con
 - 
 
226 
 
 212 
 
227 
def pushData():
 213 
def pushData():
228 
    #rankPoints = populateRankPoints()
 - 
 
229 
    populateTagItems()
 214 
    populateTagItems()
230 
    #orderedMap = orderIt
 - 
 
231 
    #convertToSolrDoc()
- 
 
232
215
233 
if __name__=='__main__':
 216 
if __name__=='__main__':
234 
    pushData()
 217 
    pushData()
235 
    #solr.delete(q='*:*')
 - 
 
236 
    #solr.add([{'_childDocuments_': [{'itemId_i': 26564L, 'mop_f': 100.0, 'tagId_i': 2L, 'sellingPrice_f': 2600.0, 'color_s': '', 'id': 'itemtag-26564-2'}, {'itemId_i': 1, 'mop_f': 460.0, 'tagId_i': 2, 'sellingPrice_f': 500.0, 'color_s': 'Black', 'id': 'dummy'}], 'catalogId_i': 1019937L, 'rank_i': 500000, 'id': 'catalog1019937', 'title_s': 'Micromax Spark Vdeo Q415'}, {'_childDocuments_': [{'itemId_i': 26691L, 'mop_f': 4500.0, 'tagId_i': 4L, 'sellingPrice_f': 4299.0, 'color_s': 'Gold', 'id': 'itemtag-26691-4'}], 'catalogId_i': 1020034L, 'rank_i': 500000, 'id': 'catalog1020034', 'title_s': 'Samsung Z2'}, {'_childDocuments_': [{'itemId_i': 21585L, 'mop_f': 33000.0, 'tagId_i': 4L, 'sellingPrice_f': 31990.0, 'color_s': '', 'id': 'itemtag-21585-4'}], 'catalogId_i': 1015720L, 'rank_i': 500000, 'id': 'catalog1015720', 'title_s': 'HTC One A9 16GB'}, {'_childDocuments_': [{'itemId_i': 15663L, 'mop_f': 8000.0, 'tagId_i': 4L, 'sellingPrice_f': 7529.0, 'color_s': 'Black', 'id': 'itemtag-15663-4'}], 'catalogId_i': 1010735L, 'rank_i': 500000, 'id': 'catalog1010735', 'title_s': 'HTC Desire 210 Dual SIM'}, {'_childDocuments_': [{'itemId_i': 15549L, 'mop_f': 11000.0, 'tagId_i': 4L, 'sellingPrice_f': 10599.0, 'color_s': 'Matte Blue', 'id': 'itemtag-15549-4'}], 'catalogId_i': 1010312L, 'rank_i': 500000, 'id': 'catalog1010312', 'title_s': 'HTC Desire 310'}, {'_childDocuments_': [{'itemId_i': 18083L, 'mop_f': 10500.0, 'tagId_i': 4L, 'sellingPrice_f': 9999.0, 'color_s': 'Black', 'id': 'itemtag-18083-4'}], 'catalogId_i': 1012434L, 'rank_i': 500000, 'id': 'catalog1012434', 'title_s': 'HTC Desire 326G'}, {'_childDocuments_': [{'itemId_i': 26864L, 'mop_f': 3500.0, 'tagId_i': 4L, 'sellingPrice_f': 3299.0, 'color_s': 'Black', 'id': 'itemtag-26864-4'}], 'catalogId_i': 1020180L, 'rank_i': 500000, 'id': 'catalog1020180', 'title_s': 'Intex Aqua A4'}, {'_childDocuments_': [{'itemId_i': 26872L, 'mop_f': 4500.0, 'tagId_i': 4L, 'sellingPrice_f': 4299.0, 'color_s': 'Black', 'id': 'itemtag-26872-4'}], 'catalogId_i': 1020185L, 'rank_i': 500000, 'id': 'catalog1020185', 'title_s': 'Karbonn Indian 9 4G VoLTE'}, {'_childDocuments_': [{'itemId_i': 16404L, 'mop_f': 13950.0, 'tagId_i': 4L, 'sellingPrice_f': 13799.0, 'color_s': 'Pearl White', 'id': 'itemtag-16404-4'}], 'catalogId_i': 1011256L, 'rank_i': 500000, 'id': 'catalog1011256', 'title_s': 'HTC Desire 516 Dual SIM'}, {'_childDocuments_': [{'itemId_i': 26860L, 'mop_f': 3300.0, 'tagId_i': 4L, 'sellingPrice_f': 3199.0, 'color_s': 'Black', 'id': 'itemtag-26860-4'}], 'catalogId_i': 1020025L, 'rank_i': 500000, 'id': 'catalog1020025', 'title_s': 'Karbonn A40 Indian'}, {'_childDocuments_': [{'itemId_i': 26614L, 'mop_f': 4000.0, 'tagId_i': 4L, 'sellingPrice_f': 3890.0, 'color_s': 'Champagne', 'id': 'itemtag-26614-4'}], 'catalogId_i': 1019962L, 'rank_i': 500000, 'id': 'catalog1019962', 'title_s': 'Intex Aqua Strong 5.1 Plus'}])
 -