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.0004_indexes_and_defaults

"""
"""
from __future__ import print_function

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 = "UPDATE galaxy_user SET deleted = %s WHERE deleted is null" % engine_false(migrate_engine) try: migrate_engine.execute(cmd) except Exception: log.exception("Setting default data for galaxy_user.deleted column failed.") cmd = "UPDATE galaxy_user SET purged = %s WHERE purged is null" % engine_false(migrate_engine) 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