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)
