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)
