Warning
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.")