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.0130_change_pref_datatype

"""
Migration script to change the 'value' column of 'user_preference' table from varchar to text.
"""
from __future__ import print_function

import logging

from sqlalchemy import MetaData, Table, Text

log = logging.getLogger(__name__)
metadata = MetaData()



[docs]def upgrade(migrate_engine):
    metadata.bind = migrate_engine
    print(__doc__)
    metadata.reflect()
    t = Table("user_preference", metadata, autoload=True)
    t.c.value.alter(type=Text)




[docs]def downgrade(migrate_engine):
    metadata.bind = migrate_engine
    metadata.reflect()

    # Pass, since we don't want to potentially truncate data.