__init__.py
3.26 KB
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
from sqlalchemy.ext.declarative import declarative_base
from zope.sqlalchemy import register
from sqlalchemy import Column, DateTime, Float, ForeignKey, Integer, SmallInteger, String, engine_from_config, func
from opensipkd.base.models import Base, NamaModel, DefaultModel, TABLE_ARGS
from opensipkd.base import get_settings
from opensipkd.models import User
from sqlalchemy.orm import (scoped_session, sessionmaker)
# session_factory = sessionmaker()
# BphtbDBSession = scoped_session(session_factory)
# BphtbBase = declarative_base()
# bphtb_schema = 'bphtb'
# register(BphtbDBSession)
# BPHTB_ARGS = {'extend_existing': True, 'schema': bphtb_schema}
class Coba(Base, NamaModel):
__tablename__="coba"
__table_args__ = (TABLE_ARGS,)
kode = Column(String(255))
nama = Column(String(255))
file_1 = Column(String(255))
file_2 = Column(String(255))
file_3 = Column(String(255))
money = Column(Float)
date_os = Column(DateTime(timezone=False))
date_ori = Column(DateTime(timezone=False))
date_part =Column(DateTime(timezone=False))
time_ori = Column(DateTime(timezone=False))
date_time = Column(DateTime(timezone=False))
check_box = Column(SmallInteger)
select_combo = Column(SmallInteger)
select_combo2 =Column(String(255))
file_upload = Column(String(255))
img_upload = Column(String(255))
option_list = Column(Integer)
option_box = Column(String(255))
class CobaItems(Base, DefaultModel):
__tablename__="coba_items"
__table_args__ = (TABLE_ARGS,)
coba_id = Column(Integer, ForeignKey(Coba.id))
user_id = Column(Integer, ForeignKey(User.id))
qty = Column(Integer)
price = Column(Integer)
amount = Column(Integer)
# class BphtbModel(CommonModel):
# def save(self, session=BphtbDBSession):
# if self.id:
# session.merge(self)
# else:
# session.add(self)
# @classmethod
# def count(cls, session=BphtbDBSession):
# return session.query(func.count('id')).scalar()
# @classmethod
# def query(cls, session=BphtbDBSession):
# return session.query(cls)
# @classmethod
# def query_id(cls, id, session=BphtbDBSession):
# return cls.query().filter_by(id=id)
# @classmethod
# def delete(cls, id, session=BphtbDBSession):
# cls.query_id(id, session).delete()
# @classmethod
# def query_kode(cls, kode, session=BphtbDBSession):
# return cls.query(session).filter_by(kode=kode)
# @classmethod
# def query_kode_rek(cls, rekeningkd, session=BphtbDBSession):
# return cls.query(session).filter_by(rekeningkd=rekeningkd)
# @classmethod
# def query_nama(cls, nama, session=BphtbDBSession):
# return cls.query(session).filter_by(nama=nama)
# @classmethod
# def query_nik(cls, nik, session=BphtbDBSession):
# return cls.query(session).filter_by(nik_pemohon=nik)
# from .invoice import Invoice
# from .payment import Payment, BphtbPayment
# from .validasi import BphtbValidasi, BphtbApproval, BphtbApprovalFinal
# from .validasi import BphtbValidasiUser, BphtbValidasiLevel
# from .ref import Propinsi, Dati2, Kelurahan, Kecamatan, BphtbAlasanPengurang
# from .ref import BphtbPerhitungan, BphtbHukum, BphtbStatusHak
# from .ppat import BphtbPpat, BphtbPpatUser