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)
[docs]def downgrade(migrate_engine): pass