propinsi.py

from sqlalchemy import (Column, String, )

from . import PbbmBase, PbbmDBSession, PBBM_ARGS, CommonModel


class Propinsi(PbbmBase, CommonModel):
    __tablename__ = 'ref_propinsi'
    kd_propinsi = Column(String(2), primary_key=True)
    nm_propinsi = Column(String(30))
    __table_args__ = (PBBM_ARGS,)
    
    @classmethod
    def query(cls):
        return PbbmDBSession.query(cls)

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