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()