kecamatan.py
1.84 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
from . import PAD_TABLE_ARGS, DefaultModel, Base, DBSession
from sqlalchemy import (
Column,
Integer,
DateTime,
String,
SmallInteger
)
from sqlalchemy.ext.hybrid import hybrid_property
class PjdlKecamatan(Base, DefaultModel):
__tablename__ = 'tblkecamatan'
__table_args__ = PAD_TABLE_ARGS
id = Column(Integer, primary_key=True)
kecamatankd = Column(String(2), nullable=False, unique=True)
kecamatannm = Column(String(50))
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 kode(self):
return self.kecamatankd
@kode.setter
def kode(self, kode):
self.kecamatankd = kode
@hybrid_property
def nama(self):
return self.kecamatannm
@nama.setter
def nama(self, kode):
self.kecamatannm = kode
@classmethod
def get_kecamatannama(cls):
q = DBSession.query(
cls.kecamatannm
)
return q.all
@classmethod
def query_kode(cls, kode):
return cls.query().filter(cls.kecamatankd == kode)
@classmethod
def query_nama(cls, nama):
return cls.query().filter(cls.kecamatannm == nama)
@classmethod
def query_register(cls, order_field="kecamatannm"):
return cls.query_from(columns =[cls.kecamatankd.label('Kode Kecamatan'),
cls.kecamatannm.label('Kecamatan'),
cls.enabled.label('Aktif')]).\
order_by(getattr(cls, order_field))
@classmethod
def get_list(cls):
r = []
q = cls.query().order_by(cls.kecamatannm)
for row in q:
g = (str(row.id), f"{row.kode}/ {row.nama}")
r.append(g)
return r