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.0032_stored_workflow_slug_column

"""
Migration script to add slug column for stored workflow.
"""

import logging

from sqlalchemy import (
    Column,
    MetaData,
    Table,
    TEXT
)

from galaxy.model.migrate.versions.util import (
    add_column,
    add_index,
    drop_column
)

log = logging.getLogger(__name__)
metadata = MetaData()


[docs]def upgrade(migrate_engine): print(__doc__) metadata.bind = migrate_engine metadata.reflect() StoredWorkflow_table = Table("stored_workflow", metadata, autoload=True) c = Column("slug", TEXT) add_column(c, StoredWorkflow_table, metadata) # Index needs to be added separately because MySQL cannot index a TEXT/BLOB # column without specifying mysql_length add_index('ix_stored_workflow_slug', StoredWorkflow_table, 'slug')
[docs]def downgrade(migrate_engine): metadata.bind = migrate_engine metadata.reflect() drop_column('slug', 'stored_workflow', metadata)