Warning
This document is for an in-development version of Galaxy. You can alternatively view this page in the latest release if it exists or view the top of the latest release's documentation.
Source code for galaxy.model.migrate.versions.0161_add_workflow_invocation_output_table
"""
Migration script to add a new workflow_invocation_output_parameter table to track output parameters.
"""
from __future__ import print_function
import logging
from sqlalchemy import Column, ForeignKey, Integer, MetaData, Table
from galaxy.model.custom_types import JSONType
log = logging.getLogger(__name__)
metadata = MetaData()
workflow_invocation_output_parameter_table = Table(
"workflow_invocation_output_value", metadata,
Column("id", Integer, primary_key=True),
Column("workflow_invocation_id", Integer, ForeignKey("workflow_invocation.id"), index=True),
Column("workflow_step_id", Integer, ForeignKey("workflow_step.id")),
Column("workflow_output_id", Integer, ForeignKey("workflow_output.id"), index=True),
Column("value", JSONType),
)
[docs]def upgrade(migrate_engine):
print(__doc__)
metadata.bind = migrate_engine
metadata.reflect()
try:
workflow_invocation_output_parameter_table.create()
except Exception:
log.exception("Creating workflow_invocation_output_parameter table failed")
[docs]def downgrade(migrate_engine):
metadata.bind = migrate_engine
metadata.reflect()
try:
workflow_invocation_output_parameter_table.drop()
except Exception:
log.exception("Dropping workflow_invocation_output_parameter table failed")