def do_upgrade(): from invenio.bibworkflow_model import BibWorkflowObject from invenio.webdeposit_models import Deposition ids = [] ids_wf = [] for b in BibWorkflowObject.query.all(): d = Deposition.get(b.id) if d.submitted and (d.workflow_object.version != 1 or d.workflow_object.workflow.status != 5): ids.append(b.id) ids_wf.append(d.workflow_object.id_workflow) ids = ", ".join(str(o) for o in ids) ids_wf = ", ".join("'%s'" % o for o in ids_wf) run_sql("UPDATE bwlOBJECT SET version=1 WHERE id in (%s)" % ids) run_sql("UPDATE bwlWORKFLOW SET status=5 WHERE uuid in (%s)" % ids_wf)