def get_verdicts(): query = Verdict.query article_id = request.args.get('articleId') if article_id is not None: query = filter_verdicts_with_article_id(query, article_id) return listify(Verdict, includes=VERDICT_INCLUDES, page=request.args.get('page'), paginate=10, query=query)
def get_verdicts(): query = Verdict.query.order_by(desc(Verdict.scienceFeedbackPublishedDate)) content_id = request.args.get('contentId') keywords = request.args.get('keywords') if content_id is not None: query = query.filter_by(contentId=dehumanize(content_id)) if keywords is not None: query = keep_verdict_with_keywords(query, keywords) return listify(Verdict, includes=VERDICT_INCLUDES, page=request.args.get('page', 1), paginate=6, query=query)
def get_reviews(): check_has_role(current_user, 'EDITOR') query = Review.query content_id = request.args.get('contentId') if content_id is not None: query = query.filter_by(contentId=dehumanize(content_id)) keywords = request.args.get('keywords') if keywords is not None: query = get_reviews_join_query(query) query = get_reviews_query_with_keywords(query, keywords) return listify(Review, includes=REVIEW_INCLUDES, query=query, page=request.args.get('page', 1), paginate=10)
def get_reviews(): check_has_role(current_user, 'editor') query = Review.query article_id = request.args.get('articleId') if article_id is not None: query = filter_reviews_with_article_id(query, article_id) keywords = request.args.get('keywords') if keywords is not None: query = get_reviews_join_query(query) query = get_reviews_query_with_keywords(query, keywords) return listify(Review, includes=REVIEW_INCLUDES, query=query, page=request.args.get('page', 1), paginate=10)
def get_users(): check_has_role(current_user, 'admin') query = User.query roles = request.args.get('roles') if roles is not None: query = filter_users_with_roles(query, roles.split(',')) keywords = request.args.get('keywords') if keywords is not None: query = get_users_join_query(query) query = get_users_query_with_keywords(query, keywords) return listify(User, includes=USER_INCLUDES, page=request.args.get('page'), paginate=10, query=query, with_total_data_count=True)
def get_articles(): query = Article.query reviewable = request.args.get('reviewable') if reviewable == 'true': query = filter_articles_by_is_reviewable(query, True) elif reviewable == 'false': query = filter_articles_by_is_reviewable(query, False) keywords = request.args.get('keywords') if keywords is not None: query = get_articles_keywords_join_query(query) query = get_articles_query_with_keywords(query, keywords) return listify(Article, includes=ARTICLE_INCLUDES, query=query, page=request.args.get('page', 1), paginate=os.environ.get('ARTICLES_PAGINATION', 10), with_total_data_count=True)
def get_contents(): query = Content.query query = keep_contents_with_minimal_datum(query) reviewable = request.args.get('reviewable') if reviewable == 'true': query = filter_contents_by_is_reviewable(query, True) elif reviewable == 'false': query = filter_contents_by_is_reviewable(query, False) keywords = request.args.get('keywords') if keywords is not None: query = get_contents_keywords_join_query(query) query = keep_contents_with_keywords(query, keywords) return listify(Content, includes=CONTENT_INCLUDES, query=query, page=request.args.get('page', 1), paginate=os.environ.get('CONTENTS_PAGINATION', 10), with_total_data_count=True)
def get_appearances(): query = Appearance.query return listify(Appearance, query=query)
def get_claims(): query = Claim.query return listify(Claim, query=query)