def get_single_commodity(request, asin):
'''
获取单条商品记录，根据指定的filed返回对应信息，默认全部返回
@param asin: 对应的ASIN
'''
db = get_mongo_db()
query_field = cu.generate_query(eval(request.GET.get('field', '[]')))
single_data = db.commodity.find_one({'ASIN': asin},
query_field)
del db
return JSONResponse(single_data)
def custom_query(request):
'''
Warning: this may be slow or cause damage to db
DO NOT use that if unnecessary
'''
if request.GET.get('query') or request.GET.get('ret'):
try:
page = int(request.GET.get('page', '1'))
except:
page = 1
page = page if page >0 else 1
db = get_mongo_db()
all_data=db.commodity.find(request.GET.get('query', {}),
request.GET.get('ret', {})).sort({'stats_info': -1}).skip((page-1)*ITEMS_PER_PAGE).limit(ITEMS_PER_PAGE)
return JSONResponse([data for data in all_data])
else:
return get_all_categories(request)
def get_all_categories(request):
'''
get all categories in commodity
@return: list of categories
'''
db = get_mongo_db()
if request.GET.get('category_name', None):
'''
Get products given category name
'''
query_field = cu.generate_query(eval(request.GET.get('field', '[]')))
category_set = re.sub(r'\$','&',request.GET.get('category_name')).split('>')
try:
page = int(request.GET.get('page', 1))
except:
page = 1
page = page if page > 0 else 1
all_data = db.commodity.find({'category':
{'$elemMatch':
{'$all':category_set}}},
query_field).sort('stats_info.review_count',-1).skip((page-1)*ITEMS_PER_PAGE).limit(ITEMS_PER_PAGE)
del db
return JSONResponse(map(lambda x:x, all_data))
'''
get whole category info
'''
all_category_info = db.commodity.distinct('category')
del db
return JSONResponse(map(lambda x:{'name': '>'.join(x)}, all_category_info))
