perolehan.py

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


class PerolehanMixin:
    @declared_attr
    def __tablename__(self):
        return 'bphtb_perolehan'

    @declared_attr
    def id(self):
        return Column(Integer, primary_key=True)

    @declared_attr
    def nama(self):
        return Column(String(100), nullable=False)

    @declared_attr
    def npoptkp(self):
        return Column(Integer, nullable=False)

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

    @declared_attr
    def singkatan(self):
        return Column(String(20))

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