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.0127_output_collection_adjustments
"""
Migration script updating collections tables for output collections.
"""
from __future__ import print_function
import logging
from sqlalchemy import (
Column,
ForeignKey,
Integer,
MetaData,
Table,
TEXT,
Unicode
)
from galaxy.model.custom_types import TrimmedString
from galaxy.model.migrate.versions.util import (
add_column,
create_table,
drop_column,
drop_table
)
log = logging.getLogger(__name__)
metadata = MetaData()
JobToImplicitOutputDatasetCollectionAssociation_table = Table(
"job_to_implicit_output_dataset_collection", metadata,
Column("id", Integer, primary_key=True),
Column("job_id", Integer, ForeignKey("job.id"), index=True),
Column("dataset_collection_id", Integer, ForeignKey("dataset_collection.id"), index=True),
Column("name", Unicode(255))
)
[docs]def upgrade(migrate_engine):
print(__doc__)
metadata.bind = migrate_engine
metadata.reflect()
create_table(JobToImplicitOutputDatasetCollectionAssociation_table)
dataset_collection_table = Table("dataset_collection", metadata, autoload=True)
# need server_default because column in non-null
populated_state_column = Column('populated_state', TrimmedString(64), default='ok', server_default="ok", nullable=False)
add_column(populated_state_column, dataset_collection_table, metadata)
populated_message_column = Column('populated_state_message', TEXT, nullable=True)
add_column(populated_message_column, dataset_collection_table, metadata)
[docs]def downgrade(migrate_engine):
metadata.bind = migrate_engine
metadata.reflect()
drop_table(JobToImplicitOutputDatasetCollectionAssociation_table)
dataset_collection_table = Table("dataset_collection", metadata, autoload=True)
drop_column('populated_state', dataset_collection_table)
drop_column('populated_state_message', dataset_collection_table)