def get_by_region_prefix(self, prefix, 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('%' + prefix + '%')).order_by(
self.model.fk_region_id).all()
def get_by_supradesa_code(self,
supradesa_code,
type=4,
page_sort_params=None):
query = self.db.session.query(self.model)
if supradesa_code == 'lokpri':
query = query.filter(self.model.is_lokpri == True).filter(
self.model.type == type)
else:
query = query.filter(
self.model.id.like(supradesa_code +
'%')).filter(self.model.type == type)
query = QueryHelper.build_page_sort_query(query, self.model,
page_sort_params)
return query.all()
def get_apbdes():
page_sort_params = QueryHelper.get_page_sort_params_from_request(request)
entities = apbdes_repository.all(page_sort_params)
result = ApbdesModelSchema(many=True).dump(entities)
return jsonify(result.data)
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 get_statistic():
page_sort_params = QueryHelper.get_page_sort_params_from_request(request)
entities = statistic_repository.all(page_sort_params)
result = StatisticModelSchema(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).first()
def get_regions():
page_sort_params = QueryHelper.get_page_sort_params_from_request(request)
entities = region_repository.all(page_sort_params=page_sort_params)
result = RegionModelSchema(many=True).dump(entities)
return jsonify(result.data)
def get_by_supraadesa_code(self, supradesa_code='lokpri', 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.order_by(self.model.supradesa_code == supradesa_code) \
.all()
def get_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.filter(self.model.pemetaan_desa_boundary > 0) \
.order_by(self.model.fk_region_id) \
.all()
def get_penduduks():
page_sort_params = QueryHelper.get_page_sort_params_from_request(request)
entities = penduduk_repository.all(page_sort_params)
result = PendudukModelSchemaIso(many=True).dump(entities)
return jsonify(result.data)
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()
