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.0004_indexes_and_defaults
"""
"""
import logging
from sqlalchemy import (
MetaData,
Table
)
from galaxy.model.migrate.versions.util import (
add_index,
engine_false
)
log = logging.getLogger(__name__)
metadata = MetaData()
[docs]def upgrade(migrate_engine):
print(__doc__)
metadata.bind = migrate_engine
metadata.reflect()
User_table = Table("galaxy_user", metadata, autoload=True)
# The next add_index() calls are not needed any more after commit
# 7ee93c0995123b0f357abd649326295dfa06766c , but harmless
add_index('ix_galaxy_user_deleted', User_table, 'deleted')
add_index('ix_galaxy_user_purged', User_table, 'purged')
# Set the default data in the galaxy_user table, but only for null values
cmd = f"UPDATE galaxy_user SET deleted = {engine_false(migrate_engine)} WHERE deleted is null"
try:
migrate_engine.execute(cmd)
except Exception:
log.exception("Setting default data for galaxy_user.deleted column failed.")
cmd = f"UPDATE galaxy_user SET purged = {engine_false(migrate_engine)} WHERE purged is null"
try:
migrate_engine.execute(cmd)
except Exception:
log.exception("Setting default data for galaxy_user.purged column failed.")
add_index('ix_hda_copied_from_library_dataset_dataset_association_id',
'history_dataset_association',
'copied_from_library_dataset_dataset_association_id', metadata)