import-sipkd-master.py
1.2 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
from sipkd_master_models import RekPendapatan, RekBelanja, RekBiaya, SipkdDBSession, SipkdBase
from eis_models import Rekening as EisRekening, EisBase, EisDBSession
from conf import sipkd_url, sipkd_url_master
from sqlalchemy import create_engine
from datetime import datetime
from datetime import date
eng_master = create_engine(sipkd_url_master)
SipkdDBSession.configure(bind=eng_master)
SipkdBase.metadata.bind = eng_master
SipkdBase.metadata.create_all(eng_master)
now = datetime.now()
tanggal = now.date()
tahun = now.strftime('%Y')
def import_rekening(tabel):
query = SipkdDBSession.query(tabel)
for row in query.all():
rek = EisDBSession.query(EisRekening).\
filter_by(tahun=tahun,
kode=row.kdper.strip()
).first()
if not rek:
rek = EisRekening()
rek.tahun = tahun
rek.kode = row.kdper.strip()
rek.nama = row.nmper.strip()
rek.level_id = row.kdper.strip().count('.')
EisDBSession.add(rek)
EisDBSession.flush()
EisDBSession.commit()
import_rekening(RekPendapatan)
import_rekening(RekBelanja)
import_rekening(RekBiaya)