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
import sys
from datetime import (
date,
datetime,
)
from argparse import ArgumentParser
from configparser import ConfigParser
from sqlalchemy import create_engine
from sqlalchemy.orm import sessionmaker
from zope.sqlalchemy import register
import transaction
from pbb_parser import Parser
default_tgl = date.today().strftime('%d-%m-%Y')
help_tgl = f'default {default_tgl}'
pars = ArgumentParser()
pars.add_argument('conf')
pars.add_argument('--tgl-awal', default=default_tgl, help=help_tgl)
pars.add_argument('--tgl-akhir', default=default_tgl, help=help_tgl)
pars.add_argument('--reversal', action='store_true')
option = pars.parse_args(sys.argv[1:])
conf = ConfigParser()
conf.read(option.conf)
settings = conf['app:main']
engine = create_engine(settings['sqlalchemy.url'])
pbb_engine = create_engine(settings['simpbb.url'])
factory = sessionmaker(bind=engine)
pbb_factory = sessionmaker(bind=pbb_engine)
db_session = factory()
pbb_session = pbb_factory()
register(db_session)
tgl_awal = datetime.strptime(option.tgl_awal, '%d-%m-%Y')
tgl_awal = tgl_awal.date()
tgl_akhir = datetime.strptime(option.tgl_akhir, '%d-%m-%Y')
tgl_akhir = tgl_akhir.date()
p = Parser(db_session, pbb_session, tgl_awal, tgl_akhir)
with transaction.manager:
if option.reversal:
p.reversal()
else:
p.payment()