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)
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)
