def get_all_by_kabupaten(self, kabupaten_code, page_sort_params=None):
query = self.db.session.query(self.model)
query = QueryHelper.build_page_sort_query(query, self.model,
page_sort_params)
return query.filter(self.model.fk_region_id.like(kabupaten_code + '%')) \
.order_by(self.model.fk_region_id) \
.all()
def get_summaries(kabupaten_code):
page_sort_params = QueryHelper.get_page_sort_params_from_request(request)
entities = summary_repository.get_all_by_kabupaten(kabupaten_code,
page_sort_params)
result = SummaryModelSchema(many=True).dump(entities)
return jsonify(result.data)
def get_by_region(self, region_id, page_sort_params=None):
query = self.db.session.query(self.model)
query = QueryHelper.build_page_sort_query(query, self.model,
page_sort_params)
return query.filter(self.model.fk_region_id == region_id).all()
def all(self, is_lokpri=True, page_sort_params=None):
query = self.db.session.query(self.model) \
.filter(self.model.is_lokpri == is_lokpri)
query = QueryHelper.build_page_sort_query(query, self.model,
page_sort_params)
return query.all()
def all(self, page_sort_params=None):
query = self.db.session.query(self.model)
query = QueryHelper.build_page_sort_query(query, self.model,
page_sort_params)
return query.all()