pengurangan_covid.py

from sqlalchemy import (
    Column,
    Integer,
    BigInteger,
    String
)

from ..models import (
    CommonModel,
    PbbDBSession,
    PbbBase,
    PBB_ARGS
)


class PenguranganCovid(PbbBase, CommonModel):
    """
    Table pengurangan_covid yang digunakan di kota bogor.
    """
    __tablename__ = 'pengurangan_covid'
    __table_args__ = PBB_ARGS
    kd_propinsi = Column(String(2), primary_key=True)
    kd_dati2 = Column(String(2), primary_key=True)
    kd_kecamatan = Column(String(3), primary_key=True)
    kd_kelurahan = Column(String(3), primary_key=True)
    kd_blok = Column(String(3), primary_key=True)
    no_urut = Column(String(4), primary_key=True)
    kd_jns_op = Column(String(1), primary_key=True)
    thn_pajak_sppt = Column(String(4), primary_key=True)
    pembayaran_sppt_ke = Column(Integer, primary_key=True)
    denda = Column(BigInteger)
    bayar = Column(BigInteger)

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