db.py
959 Bytes
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
from sqlalchemy import func
from opensipkd.base.models import Parameter
def column_concat(*args):
cols = []
for arg in args:
if type(arg) == list:
for a in arg:
cols.append(a)
else:
cols.append(arg)
if not cols:
return ''
elif len(cols) == 1:
return cols[0]
# saat ini menggunakan recursive spertinya ada syntax pythonic
# func.concat(cols[i], for col in cols)
# lambda_concat = lambda args: func.concat(x, y) for x, y in zip(args[:-1], args[1:])
return func.concat(cols[0], column_concat(*cols[1:]))
def column_date(field, dt_format='YYYY-MM-DD HH:MI:SS'):
return func.to_char(field, dt_format)
def get_parameter(kode):
return Parameter.query_kode(kode).first()
def get_parameter_pasar(kode):
return Parameter.query_kode(kode).all()
def get_parameter_kebersihan(kode):
return Parameter.query_kode(kode).all()