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