Subversion Repositories SmartDukaan

def search_items(search_terms, offset, limit):

def search_items(search_terms, offset, limit):

    query = Item.query

    query = Item.query

    search_terms = ['%' + search_term + '%' for search_term in search_terms]

    search_terms = ['%' + search_term + '%' for search_term in search_terms]

    for search_term in search_terms:

    for search_term in search_terms:

        query_clause = []

        query_clause = []

        query_clause.append(Item.brand.like(search_term))

        query_clause.append(Item.brand.like(search_term))

        query_clause.append(Item.model_number.like(search_term))

        query_clause.append(Item.model_number.like(search_term))

        query_clause.append(Item.model_name.like(search_term))

        query_clause.append(Item.model_name.like(search_term))

        query = query.filter(or_(*query_clause))

        query = query.filter(or_(*query_clause))

    query = query.order_by(Item.product_group, Item.brand, Item.model_number, Item.model_name).offset(offset)

    query = query.order_by(Item.product_group, Item.brand, Item.model_number, Item.model_name).offset(offset)

    if limit:

    if limit:

        query = query.limit(limit)

        query = query.limit(limit)

    items = query.all()

    items = query.all()

    return items

    return items

def get_banner_details(name):

def get_banner_details(name):

    banner = Banner.get_by(bannerName=name)

    banner = Banner.get_by(bannerName=name)

    return banner  

    return banner  

def get_active_banners():

def get_active_banners():

    query= session.query(Banner)

    query= session.query(Banner)

    banner= query.filter_by(isActive =True).order_by(desc(Banner.priority)).all()

    banner= query.filter_by(isActive =True).order_by(desc(Banner.priority)).all()

    return banner

    return banner

def add_banner_map(bannerName, mapLink, coordinates):

def add_banner_map(bannerName, mapLink, coordinates):

    banner_map_details=BannerMap()

    banner_map_details=BannerMap()

    banner_map_details.bannerName=bannerName

    banner_map_details.bannerName=bannerName

    session.query(BannerMap.bannerName).filter_by(bannerName=name).delete()

    session.query(BannerMap.bannerName).filter_by(bannerName=name).delete()

    session.commit()

    session.commit()

    return True

    return True

def get_banner_map_details(name):

def get_banner_map_details(name):

    query= session.query(BannerMap)

    query= session.query(BannerMap)

    bannermap= query.filter_by(bannerName=name).all()

    bannermap= query.filter_by(bannerName=name).all()

    return bannermap

    return bannermap

def get_all_tags ():

def get_all_tags ():

    return [tuple[0] for tuple in session.query(EntityTag.tag).distinct().all()]

    return [tuple[0] for tuple in session.query(EntityTag.tag).distinct().all()]

            amazon_item.category=''

            amazon_item.category=''

        if amazonlisted.color:

        if amazonlisted.color:

            amazon_item.color=amazonlisted.color

            amazon_item.color=amazonlisted.color

        else:

        else:

            amazon_item.color=''

            amazon_item.color=''

    elif (amazonItem.asin!=amazonlisted.asin):

    elif (amazonItem.asin!=amazonlisted.asin):

        if amazonlisted.asin:

        if amazonlisted.asin:

            amazonItem.asin=amazonlisted.asin

            amazonItem.asin=amazonlisted.asin

        if amazonlisted.brand:

        if amazonlisted.brand:

            amazonItem.brand=amazonlisted.brand

            amazonItem.brand=amazonlisted.brand