def update_db_zbfile(zbfile, event):
    """
    on update the zbfile in the db is updated
    """
    if zbfile.isTemporary(): return
    utils = getToolByName(zbfile, "plone_utils")

    session = getUtility(IDatabase, 'zb.database').session

    workflowTool = getToolByName(zbfile, "portal_workflow")
    wfstatus = workflowTool.getStatusOf('zb.workspaces_zbfile_workflow', zbfile)['review_state']

    dbutil = dbutility()
    status_id = dbutil.get_status_id(wfstatus)

    if zbfile.zbfile_id:
        try:
            dbzbfile = session.query(dbzbfileclass).filter_by(zbfile_id=zbfile.zbfile_id).first()
            if dbzbfile:
                dbzbfile.plone_uid = zbfile.UID()
                dbzbfile.file_nm = zbfile.getId()
                dbzbfile.file_nm_disp = zbfile.Title()
                dbzbfile.status_id = status_id
                dbzbfile.end_date = zbfile.end_date
                dbzbfile.file_size = float(zbfile.get_size()) / (1024.0*1024.0)
                dbzbfile.file_dur = zbfile.get_duration()
        except:
            msg = sys.exc_info()[0]
            LOG.error(msg)
    else:
        # file doesn't exist already
        pass

    session.flush()