calculate_data.py

def has_child(DBS, table, kode): #TODO filter parameterized
    qry = DBS.query(table).filter(table.kode.like(kode+'.%')).\
          order_by(table.kode)
    row = qry.first()
    return row

def calculate_data(DBS, table):
    qry = DBS.query(table).order_by(table.kode)
    rows = qry.all()
    parents = []
    results = []
    jml = 0
    for row in rows:
        if has_child(DBS, table, row.kode):
            parents.append(dict(id = row.id, kode=row.kode, jumlah=0))
            kode = row.kode
            jml = 0
        else:
            if row.jumlah: 
                jml = jml + row.jumlah