kecamatan.py

from sqlalchemy import (
    Column, String, ForeignKeyConstraint,
)

from ..models import Dati2
from ..models import PbbmBase, PbbmDBSession, PBBM_ARGS, CommonModel
from ..tools import FixKecamatan


class Kecamatan(PbbmBase, CommonModel):
    __tablename__ = 'ref_kecamatan'
    kd_propinsi = Column(String(2), primary_key=True)
    kd_dati2 = Column(String(2), primary_key=True)
    kd_kecamatan = Column(String(3), primary_key=True)
    nm_kecamatan = Column(String(30))
    __table_args__ = (
        ForeignKeyConstraint([kd_propinsi, kd_dati2], [Dati2.kd_propinsi, Dati2.kd_dati2]),
        PBBM_ARGS)

    @property
    def kode(self):
        return self.kd_propinsi + self.kd_dati2 + self.kd_kecamatan

    @classmethod
    def query(cls):
        return PbbmDBSession.query(cls)

    @classmethod
    def query_id(cls, id):
        fxKode = FixKecamatan(id)
        return cls.query(). \
            filter_by(
            kd_propinsi=fxKode['kd_propinsi'],
            kd_dati2=fxKode['kd_dati2'],
            kd_kecamatan=fxKode['kd_kecamatan'],
        )