Subversion Repositories SmartDukaan

Rev

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

Rev 20058 Rev 20059
Line 1373... Line 1373...
1373 
        query = query.limit(limit)
 1373 
        query = query.limit(limit)
1374 
    items = query.all()
 1374 
    items = query.all()
1375 
    return items
 1375 
    return items
1376 
 
 1376 
 
1377 
def get_search_result_count(search_terms):
 1377 
def get_search_result_count(search_terms):
- 
 
 1378 
    d_item = None
- 
 
 1379
1378 
    query = Item.query
 1380 
    query = Item.query
1379
1381
- 
 
 1382 
    if len(search_terms) ==1:
- 
 
 1383 
        """If length of search_term list is 1, then most probably user is trying to find items by item_id"""
- 
 
 1384 
        try:
- 
 
 1385 
            item_id = int(search_terms[0])
- 
 
 1386 
            d_item = query.filter(Item.id == item_id).first()
- 
 
 1387 
        except:
- 
 
 1388 
            """Not item_id.Lets find search_terms in brand, model_name,...etc"""
- 
 
 1389
- 
 
 1390 
    if d_item is None:
1380 
    search_terms = ['%' + search_term + '%' for search_term in search_terms]
 1391 
        search_terms = ['%' + search_term + '%' for search_term in search_terms]
1381
1392
1382 
    for search_term in search_terms:
 1393 
        for search_term in search_terms:
1383 
        query_clause = []
 1394 
            query_clause = []
1384 
        query_clause.append(Item.brand.like(search_term))
 1395 
            query_clause.append(Item.brand.like(search_term))
1385 
        query_clause.append(Item.model_number.like(search_term))
 1396 
            query_clause.append(Item.model_number.like(search_term))
1386 
        query_clause.append(Item.model_name.like(search_term))
 1397 
            query_clause.append(Item.model_name.like(search_term))
1387 
        query = query.filter(or_(*query_clause))
 1398 
            query = query.filter(or_(*query_clause))
- 
 
 1399 
    else:
- 
 
 1400 
        query = query.filter(Item.catalog_item_id == d_item.catalog_item_id)
1388
1401
1389 
    return query.count()
 1402 
    return query.count()
1390 
 
 1403 
 
1391 
def __clear_homepage_cache():
 1404 
def __clear_homepage_cache():
1392 
    try:
 1405 
    try:
Line 3428... Line 3441...
3428 
    return itemWarrantyMap
 3441 
    return itemWarrantyMap
3429 
 
 3442 
 
3430 
if __name__=='__main__':
 3443 
if __name__=='__main__':
3431 
    DataService.initialize()
 3444 
    DataService.initialize()
3432 
    #update_bulk_prices_on_production(21053,[])
 3445 
    #update_bulk_prices_on_production(21053,[])
3433 
    search_terms = ["1100111"]
 3446 
    search_terms = ["12206"]
3434 
    search_items(search_terms, 0, 20)
 3447 
    print search_items(search_terms, 0, 20)
- 
 
 3448 
    print get_search_result_count(search_terms)
3435
3449
3436 

            3450