This document is for an old release 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.0093_add_job_params_col

Migration script to add a 'params' column to the 'job' table.

import logging

from sqlalchemy import Column, MetaData, Table

# Need our custom types, but don't import anything else from model
from galaxy.model.custom_types import TrimmedString

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

# Column to add.
params_col = Column("params", TrimmedString(255), index=True)

[docs]def upgrade(migrate_engine): metadata.bind = migrate_engine print(__doc__) metadata.reflect() # Add column to Job table. try: Job_table = Table("job", metadata, autoload=True) params_col.create(Job_table, index_name="ix_job_params") assert params_col is Job_table.c.params except Exception: log.exception("Adding column 'params' to job table failed.")
[docs]def downgrade(migrate_engine): metadata.bind = migrate_engine metadata.reflect() # Drop column from Job table. try: Job_table = Table("job", metadata, autoload=True) params_col = Job_table.c.params params_col.drop() except Exception: log.exception("Dropping column 'params' from job table failed.")