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.0075_add_subindex_column_to_run_table
"""
Migration script to add a 'subindex' column to the run table.
"""
from __future__ import print_function
import logging
from sqlalchemy import Column, MetaData, Table
from galaxy.model.custom_types import TrimmedString
log = logging.getLogger(__name__)
metadata = MetaData()
[docs]def upgrade(migrate_engine):
metadata.bind = migrate_engine
print(__doc__)
metadata.reflect()
try:
Run_table = Table("run", metadata, autoload=True)
c = Column("subindex", TrimmedString(255), index=True)
c.create(Run_table, index_name="ix_run_subindex")
assert c is Run_table.c.subindex
except Exception:
log.exception("Adding the subindex column to the run table failed.")
[docs]def downgrade(migrate_engine):
metadata.bind = migrate_engine
metadata.reflect()
try:
Run_table = Table("run", metadata, autoload=True)
Run_table.c.subindex.drop()
except Exception:
log.exception("Dropping the subindex column from run table failed.")