dat_subjek_pajak.py

from sqlalchemy import (Column, String,)
from ..models import PbbmBase, PbbmDBSession, CommonModel

class DatSubjekPajak(PbbmBase, CommonModel):
    __tablename__  = 'dat_subjek_pajak'
    subjek_pajak_id = Column(String(30), primary_key=True)
    nm_wp = Column(String(30))
    jalan_wp = Column(String(30))
    blok_kav_no_wp = Column(String(15))
    rw_wp = Column(String(2))
    rt_wp = Column(String(3))
    kelurahan_wp = Column(String(30))
    kota_wp = Column(String(30))
    kd_pos_wp = Column(String(5))
    telp_wp = Column(String(20))
    npwp = Column(String(15))
    status_pekerjaan_wp = Column(String(1))

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

    @classmethod
    def query_id(cls, id):
        return cls.query().\
                    filter_by(subjek_pajak_id = id)