kelurahan.py

from sqlalchemy import (
    Column,
    String,
    Integer,
    )
from sqlalchemy.ext.declarative import declared_attr


class KelurahanMixin:
    @declared_attr
    def __tablename__(self):
        return 'ref_kelurahan'

    @declared_attr
    def __table_args__(self):
        return dict(schema='pbb')

    @declared_attr
    def kd_propinsi(self):
        return Column(String(2), primary_key=True)

    @declared_attr
    def kd_dati2(self):
        return Column(String(2), primary_key=True)

    @declared_attr
    def kd_kecamatan(self):
        return Column(String(3), primary_key=True)

    @declared_attr
    def kd_kelurahan(self):
        return Column(String(3), primary_key=True)

    @declared_attr
    def kd_sektor(self):
        return Column(String(2), nullable=False)

    @declared_attr
    def nm_kelurahan(self):
        return Column(String(30), nullable=False)

    @declared_attr
    def no_kelurahan(self):
        return Column(Integer)

    @declared_attr
    def kd_pos_kelurahan(self):
        return Column(String(5))