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 tool_shed.webapp.model.migrate.versions.0021_change_repository_type_value
"""Migration script to change repository.type column value from generic to unrestricted."""
import logging
import sys
from sqlalchemy import MetaData
log = logging.getLogger(__name__)
log.setLevel(logging.DEBUG)
handler = logging.StreamHandler(sys.stdout)
format = "%(name)s %(levelname)s %(asctime)s %(message)s"
formatter = logging.Formatter(format)
handler.setFormatter(formatter)
log.addHandler(handler)
metadata = MetaData()
[docs]def upgrade(migrate_engine):
print(__doc__)
metadata.bind = migrate_engine
metadata.reflect()
# Update the type column to have the default unrestricted value.
cmd = "UPDATE repository SET type = 'unrestricted' WHERE type = 'generic'"
migrate_engine.execute(cmd)
[docs]def downgrade(migrate_engine):
metadata.bind = migrate_engine
metadata.reflect()
# Update the type column to have the default generic value.
cmd = "UPDATE repository SET type = 'generic' WHERE type = 'unrestricted'"
migrate_engine.execute(cmd)