jurnal.py

from sqlalchemy.ext.declarative import declarative_base
from sqlalchemy.orm.exc import NoResultFound
from sqlalchemy.orm import (
    relationship,
    backref
    )
from sqlalchemy import (Column, Integer, String, SmallInteger, UniqueConstraint, 
                        Date, BigInteger, ForeignKey, func, extract, case, DateTime, Float)
from ..models import SipkdBase, SipkdDBSession

class Jurnal(SipkdBase):
    __tablename__  = 'jurnal'
    __table_args__ = {'extend_existing':True}    
    jbku       = Column(String(2), primary_key=True)
    kdstatus   = Column(String(3), primary_key=True)
    unitkey    = Column(String(10), primary_key=True)
    nobkuskpd  = Column(String(100), primary_key=True)
    nobukti    = Column(String(100), primary_key=True)
    tglbukti   = Column(DateTime)
    uraian     = Column(String(4096))
    kdprgrm    = Column(String(10))
    kdkeg      = Column(String(10))
    keybend    = Column(String(10))
    jns_jurnal = Column(String(2))
    jmatangd   = Column(String(1))
    mtgkeyd    = Column(String(10))
    kdperd     = Column(String(30))
    nmperd     = Column(String(1024))
    nilaid     = Column(Float)
    jmatangk   = Column(String(1))
    mtgkeyk    = Column(String(10))
    kdperk     = Column(String(30))
    nmperk     = Column(String(1024))
    nilaik     = Column(Float)
    jurnal     = Column(Integer)
    tgl_valid  = Column(DateTime)