root/galaxy-central/lib/galaxy/model/migrate/versions/0032_stored_workflow_slug_column.py @ 2

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

from sqlalchemy import *
from migrate import *
from migrate.changeset import *

import logging
log = logging.getLogger( __name__ )

metadata = MetaData( migrate_engine )

def upgrade():
    
    print __doc__
    metadata.reflect()
    
    StoredWorkflow_table = Table( "stored_workflow", metadata, autoload=True )
    
    # Create slug column.
    c = Column( "slug", TEXT, index=True )
    c.create( StoredWorkflow_table )
    assert c is StoredWorkflow_table.c.slug
    
    # Create slug index.
    try:
        i = Index( "ix_stored_workflow_slug", StoredWorkflow_table.c.slug )
        i.create()
    except:
        # Mysql doesn't have a named index, but alter should work
        StoredWorkflow_table.c.slug.alter( unique=False )

def downgrade():
    metadata.reflect()

    StoredWorkflow_table = Table( "stored_workflow", metadata, autoload=True )
    StoredWorkflow_table.c.slug.drop()