kecamatan.py

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


class KecamatanMixin:
    @declared_attr
    def __tablename__(self):
        return 'ref_kecamatan'

    @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 nm_kecamatan(self):
        return Column(String(30), nullable=False)