usaha.py

import colander
from sqlalchemy import (
    Column,
    Integer,
    DateTime,
    String,
    SmallInteger
)
from sqlalchemy.ext.hybrid import hybrid_property

from . import PAD_TABLE_ARGS, DefaultModel, Base


class PjdlUsaha(Base, DefaultModel):
    __tablename__ = 'pad_usaha'
    __table_args__ = PAD_TABLE_ARGS

    id = Column(Integer, primary_key=True)
    usahanm = Column(String(50), nullable=False)
    so = Column(String(1))
    tmt = Column(DateTime)
    enabled = Column(SmallInteger)
    create_date = Column(DateTime)
    create_uid = Column(Integer)
    write_date = Column(DateTime)
    write_uid = Column(Integer)


    @hybrid_property
    def nama(self):
        return self.usahanm

    @nama.setter
    def nama(self, kode):
        self.usahanm = kode

    @classmethod
    def query_nama(cls, nama):
        return cls.query().filter(cls.usahanm == nama)

    @classmethod
    def query_register(cls, order_field="usahanm"):
        return cls.query_from(columns =[cls.usahanm.label('Nama'),
                                        cls.so.label('Self/Official'),
                                        cls.tmt.label('tmt'), cls.enabled.label('Status')]). \
            order_by(getattr(cls, order_field))

    @classmethod
    def get_list(cls):
        r = [("","Pilih Usaha")]
        q = cls.query().order_by(cls.usahanm)
        for row in q:
            g = (str(row.id), f"{row.nama}")
            r.append(g)
        return r