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
import sys
from configparser import ConfigParser
from argparse import ArgumentParser
from sqlalchemy import (
create_engine,
or_,
)
from sqlalchemy.orm import sessionmaker
from opensipkd.base.models import User
from opensipkd.hosting.models import TaskModel
STATUS = dict(
draft=1,
analisa=2,
design=2,
development=3,
qc=4,
implementation=5,
selesai=6)
STATUS_LIST = list(STATUS.keys())
KET_STATUS = [
'',
'Draft',
'Analisa & Design',
'Development',
'QC',
'Implementation',
'Selesai']
pars = ArgumentParser()
pars.add_argument('conf')
pars.add_argument('--search', required=True)
option = pars.parse_args(sys.argv[1:])
conf = ConfigParser()
conf.read(option.conf)
db_url = conf.get('main', 'db_url')
engine = create_engine(db_url)
session_factory = sessionmaker(bind=engine)
DBSession = session_factory()
q = DBSession.query(TaskModel, User).\
outerjoin(User, TaskModel.cu_id == User.id)
tokens = option.search.lower().split()
for token in tokens:
if token in STATUS_LIST:
status_id = STATUS[token]
q = q.filter(TaskModel.status == status_id)
else:
q = q.filter(or_(
User.user_name.ilike(f'%{token}%'),
TaskModel.nama.ilike(f'%{token}%'),
TaskModel.notes.ilike(f'%{token}%')))
no = 0
for task, user in q.order_by(TaskModel.id):
no += 1
ket_status = KET_STATUS[task.status]
print('-' * 50)
print(f'#{no} {task.id} {ket_status}, {user.user_name}, {task.nama}')
print(task.notes)