def minister_questions_combined(): """ Mixture of old QuestionReplies and new CommitteeQuestion objects folded together in date order to support pagination. """ filters = get_filters() # To make pagination possible, we grab a combined list of IDs, # paginate that list, and then fetch the details. # get a combined list of IDs q1 = db.session.query(CommitteeQuestion.id, CommitteeQuestion.date.label("date"), literal_column("'cq'").label("type")) for f in filters: q1 = q1.filter_by(**f) q2 = db.session.query(QuestionReply.id, QuestionReply.start_date.label("date"), literal_column("'qr'").label("type")) for f in filters: q2 = q2.filter_by(**f) query = q1.union_all(q2).order_by(desc("date")) query, count, next = paginate_request_query(query) # pull out the IDs we want cq_ids = [c[0] for c in query if c[2] == 'cq'] qr_ids = [c[0] for c in query if c[2] == 'qr'] # get committee questions query = CommitteeQuestion.list()\ .filter(CommitteeQuestion.id.in_(cq_ids))\ .order_by(CommitteeQuestion.date.desc())\ .options( lazyload('minister'), joinedload('asked_by_member'), lazyload('asked_by_member.memberships')) for f in filters: query = query.filter_by(**f) objects = query.all() # get question reply objects query = QuestionReply.list()\ .filter(QuestionReply.id.in_(qr_ids))\ .order_by(QuestionReply.start_date.desc())\ .options( lazyload('minister')) for f in filters: query = query.filter_by(**f) # mash them together objects.extend(query.all()) # sort objects.sort( key=lambda x: getattr(x, 'date', getattr(x, 'start_date', None)), reverse=True) out = serializers.queryset_to_json(objects, count=count, next=next) return send_api_response(out)
def question_reply_committees(): """ A list of those committees that have received questions and replies. We might want to generalise this at some point """ items = Committee.for_related(QuestionReply).all() return send_api_response(serializers.queryset_to_json(items, count=len(items)))
def question_reply_committees(): """ A list of those committees that have received questions and replies. We might want to generalise this at some point """ items = Committee.for_related(QuestionReply).all() return send_api_response(serializers.queryset_to_json(items, count=len(items)))
def api_resource_list(base_query): for f in get_filters(): base_query = base_query.filter_by(**f) queryset, count, next = paginate_request_query(base_query) out = serializers.queryset_to_json(queryset, count=count, next=next) return send_api_response(out)
def api_resource_list(base_query): for f in get_filters(): base_query = base_query.filter_by(**f) queryset, count, next = paginate_request_query(base_query) out = serializers.queryset_to_json(queryset, count=count, next=next) return send_api_response(out)
def minister_questions_combined(): """ Mixture of old QuestionReplies and new CommitteeQuestion objects folded together in date order to support pagination. """ filters = get_filters() # To make pagination possible, we grab a combined list of IDs, # paginate that list, and then fetch the details. # get a combined list of IDs q1 = db.session.query(CommitteeQuestion.id, CommitteeQuestion.date.label("date"), literal_column("'cq'").label("type")) for f in filters: q1 = q1.filter_by(**f) q2 = db.session.query(QuestionReply.id, QuestionReply.start_date.label("date"), literal_column("'qr'").label("type")) for f in filters: q2 = q2.filter_by(**f) query = q1.union_all(q2).order_by(desc("date")) query, count, next = paginate_request_query(query) # pull out the IDs we want cq_ids = [c[0] for c in query if c[2] == 'cq'] qr_ids = [c[0] for c in query if c[2] == 'qr'] # get committee questions query = CommitteeQuestion.list()\ .filter(CommitteeQuestion.id.in_(cq_ids))\ .order_by(CommitteeQuestion.date.desc())\ .options( lazyload('committee'), lazyload('minister'), joinedload('asked_by_member'), lazyload('asked_by_member.memberships')) for f in filters: query = query.filter_by(**f) objects = query.all() # get question reply objects query = QuestionReply.list()\ .filter(QuestionReply.id.in_(qr_ids))\ .order_by(QuestionReply.start_date.desc())\ .options( lazyload('committee'), lazyload('minister')) for f in filters: query = query.filter_by(**f) # mash them together objects.extend(query.all()) # sort objects.sort(key=lambda x: getattr(x, 'date', getattr(x, 'start_date', None)), reverse=True) out = serializers.queryset_to_json(objects, count=count, next=next) return send_api_response(out)
def api_resource(resource_id, base_query): try: resource = base_query.filter_by(id=resource_id).one() except NoResultFound: raise ApiException(404, "Not found") status_code = 200 if resource == "committee-meeting": if not resource.check_permission(): if current_user.is_anonymous(): status_code = 401 # Unauthorized, i.e. authentication is required else: status_code = 403 # Forbidden, i.e. the user is not subscribed return send_api_response(serializers.queryset_to_json(resource), status_code=status_code)
def api_resource(resource_id, base_query): try: resource = base_query.filter_by(id=resource_id).one() except NoResultFound: raise ApiException(404, "Not found") status_code = 200 if resource == "committee-meeting": if not resource.check_permission(): if current_user.is_anonymous(): status_code = 401 # Unauthorized, i.e. authentication is required else: status_code = 403 # Forbidden, i.e. the user is not subscribed return send_api_response(serializers.queryset_to_json(resource), status_code=status_code)