예제 #1
0
def get_user_rate():
    rows = Rating.query.all()
    rating_list = []
    for row in rows:
        rating_list.append(Rating.as_dict(row))
    user_rate_dict = reader.get_user_rate(rating_list)

    return user_rate_dict
예제 #2
0
def show_user_rate():
    rows = Rating.query.all()
    rating_list = []
    for row in rows[:1000]:
        rating_list.append(Rating.as_dict(row))
    user_rate_dict = reader.get_user_rate(rating_list)

    return json.dumps(user_rate_dict)
예제 #3
0
def rating_query_all():
    rows = Rating.query.all()
    response = {}
    rating_list = []
    for row in rows[:100]:
        rating_list.append(Rating.as_dict(row))

    response['ok'] = True
    response['data'] = rating_list

    return json.dumps(response)
예제 #4
0
def rating_user_book(user_id, book_id):
    row = Rating.query.filter_by(user_id=user_id, book_id=book_id).first()

    response = {}
    if row is not None:
        rating = Rating.as_dict(row)
        response = {'ok': True, 'data': rating}

    else:
        response = {'ok': False, 'data': {}}

    return json.dumps(response)
예제 #5
0
def show_specific_user_rate(user_id):
    ratings = Rating.query.filter_by(user_id=user_id)
    print(ratings)
    rating_list = []
    response = {}
    for row in ratings:
        tmp_dict = Rating.as_dict(row)
        # 过滤评分为 0 的图书
        if tmp_dict['score'] == '0':
            continue
        rating_list.append(tmp_dict)

    if ratings is not []:
        response['ok'] = True
        response['data'] = rating_list

    return json.dumps(response)