from sqlalchemy.orm import Session

from APPData.Model import CompanyModel as Model


def create_cashflow_by_id(db: Session, mongodb, _id, reportdate, condition, content):
    item = Model.CashFlow()
    item._id = _id
    item.reportdate = reportdate
    obj_id = mongodb.upsert_data(dbname="WR_DataBase", sheet="C6.3_现金流量表", condition=condition, data=content)
    item.obj_id = obj_id
    db.add(item)
    db.commit()
    return True


def find_cashflow_by_id(db: Session, mongodb, _id):
    db_item = db.query(Model.CashFlow).filter_by(_id=_id).all()
    data = list()
    for item in db_item:
        insert = mongodb.find_data_by_id(dbname="WR_DataBase", sheet="C6.3_现金流量表", _id=item.obj_id)
        data.append(insert)
    return data