Subversion Repositories SmartDukaan

    return item

    return item

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.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.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_search_result_count(search_terms):

def get_search_result_count(search_terms):

    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.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))

    return query.count()

    return query.count()

def __clear_homepage_cache():

def __clear_homepage_cache():

    try:

    try: