def get_resources():
"""
Gets a paginated list of resources.
If the URL parameters `language` or `category` are found
in the request, the list will be filtered by these parameters.
The filters are case insensitive.
"""
try:
resource_paginator = Paginator(Config.RESOURCE_PAGINATOR, request)
# Fetch the filter params from the url, if they were provided.
language = request.args.get('language')
category = request.args.get('category')
# Filter on language
if language and not category:
query = Resource.query.filter(
Resource.languages.any(
Language.name.ilike(language)
)
)
# Filter on category
elif category and not language:
query = Resource.query.filter(
Resource.category.has(
func.lower(Category.name) == category.lower()
)
)
# Filter on both
elif category and language:
query = Resource.query.filter(
and_(
Resource.languages.any(
Language.name.ilike(language)
),
Resource.category.has(
func.lower(Category.name) == category.lower()
)
)
)
# No filters
else:
query = Resource.query
resource_list = [
resource.serialize for resource in resource_paginator.items(query)
]
except Exception as e:
print_tb(e.__traceback__)
print(e)
resource_list = []
finally:
return jsonify(resource_list)
def get_languages():
language_paginator = Paginator(Config.LANGUAGE_PAGINATOR, request)
query = Language.query
language_list = [
language.serialize for language in language_paginator.items(query)
]
return standardize_response(language_list, None, "ok")
def get_resources():
"""
Gets a paginated list of resources.
If the URL parameters `language` or `category` are found
in the request, the list will be filtered by these parameters.
The filters are case insensitive.
"""
resource_paginator = Paginator(Config.RESOURCE_PAGINATOR, request)
# Fetch the filter params from the url, if they were provided.
language = request.args.get('language')
category = request.args.get('category')
updated_after = request.args.get('updated_after')
q = Resource.query
# Filter on language
if language:
q = q.filter(Resource.languages.any(Language.name.ilike(language)))
# Filter on category
if category:
q = q.filter(
Resource.category.has(
func.lower(Category.name) == category.lower()))
# Filter on updated_after
if updated_after:
try:
uaDate = parser.parse(updated_after)
if uaDate > datetime.now():
raise Exception("updated_after greater than today's date")
uaDate = uaDate.strftime("%Y-%m-%d")
except Exception as e:
logger.error(e)
message = 'The value for "updated_after" is invalid'
error = [{"code": "bad-value", "message": message}]
return standardize_response(None, error, "unprocessable-entity",
422)
q = q.filter(
or_(Resource.created_at >= uaDate,
Resource.last_updated >= uaDate))
try:
resource_list = [
resource.serialize for resource in resource_paginator.items(q)
]
except Exception as e:
logger.error(e)
return standardize_response(None, [{
"code": "bad-request"
}], "bad request", 400)
return standardize_response(resource_list, None, "ok")
def get_languages():
try:
language_paginator = Paginator(Config.LANGUAGE_PAGINATOR, Language, request)
language_list = [language.serialize for language in language_paginator.items]
except Exception as e:
print_tb(e.__traceback__)
print(e)
language_list = []
finally:
return jsonify(language_list)
def get_languages():
language_paginator = Paginator(Config.LANGUAGE_PAGINATOR, request)
query = Language.query
try:
language_list = [
language.serialize for language in language_paginator.items(query)
]
except Exception as e:
logger.exception(e)
return standardize_response(status_code=500)
return standardize_response(payload=dict(data=language_list))
def get_languages():
language_paginator = Paginator(Config.LANGUAGE_PAGINATOR, request)
query = Language.query
try:
language_list = [
language.serialize for language in language_paginator.items(query)
]
except Exception as e:
logger.error(e)
return standardize_response(None, [{"code": "bad-request"}], "bad request", 400)
return standardize_response(language_list, None, "ok")
def get_categories():
try:
category_paginator = Paginator(Config.CATEGORY_PAGINATOR, request)
query = Category.query
category_list = [
category.serialize for category in category_paginator.items(query)
]
except Exception as e:
logger.exception(e)
return standardize_response(status_code=500)
return standardize_response(payload=dict(data=category_list))
def get_categories():
try:
category_paginator = Paginator(Config.CATEGORY_PAGINATOR, request)
query = Category.query
category_list = [
category.serialize for category in category_paginator.items(query)
]
except Exception as e:
print_tb(e.__traceback__)
print(e)
category_list = []
finally:
return standardize_response(category_list, None, "ok")
def get_categories():
try:
category_paginator = Paginator(Config.CATEGORY_PAGINATOR, request)
query = Category.query
paginated_categories = category_paginator.paginated_data(query)
if not paginated_categories:
return redirect('/404')
category_list = [
category.serialize for category in paginated_categories.items
]
pagination_details = category_paginator.pagination_details(
paginated_categories)
except Exception as e:
logger.exception(e)
return standardize_response(status_code=500)
return standardize_response(
payload=dict(data=category_list, **pagination_details))
def get_languages():
language_paginator = Paginator(Config.LANGUAGE_PAGINATOR, request)
query = Language.query
try:
paginated_languages = language_paginator.paginated_data(query)
if not paginated_languages:
return redirect('/404')
language_list = [
language.serialize for language in paginated_languages.items
]
pagination_details = language_paginator.pagination_details(
paginated_languages)
except Exception as e:
logger.exception(e)
return standardize_response(status_code=500)
return standardize_response(
payload=dict(data=language_list, **pagination_details))
def get_resources():
"""
Gets a paginated list of resources.
If the URL parameters `language` or `category` are found
in the request, the list will be filtered by these parameters.
The filters are case insensitive.
"""
resource_paginator = Paginator(Config.RESOURCE_PAGINATOR, request)
# Fetch the filter params from the url, if they were provided.
language = request.args.get('language')
category = request.args.get('category')
updated_after = request.args.get('updated_after')
paid = request.args.get('paid')
q = Resource.query
# Filter on language
if language:
q = q.filter(Resource.languages.any(Language.name.ilike(language)))
# Filter on category
if category:
q = q.filter(
Resource.category.has(
func.lower(Category.name) == category.lower()))
# Filter on updated_after
if updated_after:
try:
uaDate = parser.parse(updated_after)
if uaDate > datetime.now():
raise Exception("updated_after greater than today's date")
uaDate = uaDate.strftime("%Y-%m-%d")
except Exception as e:
logger.exception(e)
message = 'The value for "updated_after" is invalid'
res = dict(errors=[{
'code': 'unprocessable-entity',
'message': message
}])
return standardize_response(payload=res, status_code=422)
q = q.filter(
or_(Resource.created_at >= uaDate,
Resource.last_updated >= uaDate))
# Filter on paid
if isinstance(paid, str):
paidAsBool = paid.lower() == 'true'
q = q.filter(Resource.paid == paidAsBool)
try:
paginated_resources = resource_paginator.paginated_data(q)
if not paginated_resources:
return redirect('/404')
resource_list = [
resource.serialize for resource in paginated_resources.items
]
pagination_details = resource_paginator.pagination_details(
paginated_resources)
except Exception as e:
logger.exception(e)
return standardize_response(status_code=500)
return standardize_response(
payload=dict(data=resource_list, **pagination_details))
