from base_models import ( Base, DBSession, ) from sismiop.query import Query from common.pbb.models import Models from common.pbb.structure import INVOICE_ID from conf import ( db_url, db_schema, ) engine = create_engine(db_url) Base.metadata.bind = engine DBSession.configure(bind=engine) models = Models(Base, db_schema) class InquiryByQuery(Query): def __init__(self, invoice_id_raw): Query.__init__(self, models, DBSession) self.invoice_id = FixLength(INVOICE_ID) self.invoice_id.set_raw(invoice_id_raw) q = self.query_invoice( self.invoice_id['Propinsi'], self.invoice_id['Kabupaten'], self.invoice_id['Kecamatan'], self.invoice_id['Kelurahan'], self.invoice_id['Blok'], self.invoice_id['Urut'], self.invoice_id['Jenis'], self.invoice_id['Tahun Pajak']) self.invoice = q.first() self.ket = None if not self.invoice:
from base_models import ( Base, DBSession, ) from sismiop.query import Reversal from common.pbb.models import Models from common.pbb.structure import INVOICE_ID from conf import ( db_url, db_schema, ) engine = create_engine(db_url) Base.metadata.bind = engine DBSession.configure(bind=engine) models = Models(Base, db_schema, None) class ReversalByQuery(Reversal): def __init__(self, invoice_id_raw): self.invoice_id = FixLength(INVOICE_ID) self.invoice_id.set_raw(invoice_id_raw) Reversal.__init__(self, models, DBSession, self.invoice_id['Propinsi'], self.invoice_id['Kabupaten'], self.invoice_id['Kecamatan'], self.invoice_id['Kelurahan'], self.invoice_id['Blok'], self.invoice_id['Urut'], self.invoice_id['Jenis'], self.invoice_id['Tahun Pajak']) def set_unpaid(self):
db_pool_size, db_max_overflow, persen_denda, nip_rekam_byr_sppt, host, ) engine = create_engine(db_url, pool_size=db_pool_size, max_overflow=db_max_overflow) Base = declarative_base() Base.metadata.bind = engine session_factory = sessionmaker() DBSession = scoped_session(session_factory) DBSession.configure(bind=engine) models = Models(Base, db_schema, iso_db_schema) query = Payment(models, DBSession) BANK_FIELDS = ('kd_kanwil', 'kd_kantor', 'kd_tp') PREFIX_NTP_FIELDS = BANK_FIELDS[:-1] class BaseResponse(object): def __init__(self, parent): self.parent = parent self.invoice_id = FixLength(INVOICE_ID) self.invoice_id_raw = parent.from_iso.get_invoice_id() self.invoice_id.set_raw(self.invoice_id_raw) def is_transaction_owner(self, pay):
iso_db_schema, payment_db_schema, db_pool_size, db_max_overflow, persen_denda, nip_rekam_byr_sppt, host, ) engine = create_engine(db_url, pool_size=db_pool_size, max_overflow=db_max_overflow) Base.metadata.bind = engine DBSession.configure(bind=engine) models = Models(Base, db_schema, iso_db_schema, payment_db_schema=payment_db_schema) BANK_FIELDS = ('kd_kanwil', 'kd_kantor', 'kd_tp') PREFIX_NTP_FIELDS = BANK_FIELDS[:-1] class BaseResponse(object): def __init__(self, parent): self.parent = parent self.invoice_id = FixLength(INVOICE_ID) self.invoice_id.set_raw(parent.from_iso.get_invoice_id()) self.invoice_id_raw = self.invoice_id.get_raw() def is_transaction_owner(self, pay): conf = host[self.parent.conf['name']]
from sqlalchemy import create_engine from tools import FixLength from base_models import ( Base, DBSession, ) from sismiop.query import Query from common.pbb.models import Models from common.pbb.structure import INVOICE_ID from conf import db_url engine = create_engine(db_url) Base.metadata.bind = engine DBSession.configure(bind=engine) models = Models(Base, None, None) class InquiryByQuery(Query): def __init__(self, invoice_id_raw): Query.__init__(self, models, DBSession) self.invoice_id = FixLength(INVOICE_ID) self.invoice_id.set_raw(invoice_id_raw) q = self.query_invoice( self.invoice_id['Propinsi'], self.invoice_id['Kabupaten'], self.invoice_id['Kecamatan'], self.invoice_id['Kelurahan'], self.invoice_id['Blok'], self.invoice_id['Urut'], self.invoice_id['Jenis'], self.invoice_id['Tahun Pajak']) self.invoice = q.first() self.ket = None if not self.invoice: return