/lib/galaxy/model/migrate/versions/0021_user_prefs.py
https://bitbucket.org/h_morita_dbcls/galaxy-central · Python · 45 lines · 31 code · 10 blank · 4 comment · 4 complexity · 050d439decdf9b9b452852bcb5c1db19 MD5 · raw file
- """
- This migration script adds a user preferences table to Galaxy.
- """
- from sqlalchemy import *
- from migrate import *
- import datetime
- now = datetime.datetime.utcnow
- import logging
- log = logging.getLogger( __name__ )
- metadata = MetaData( migrate_engine )
- def display_migration_details():
- print ""
- print "This migration script adds a user preferences table to Galaxy."
- print ""
- # New table to support user preferences.
- UserPreference_table = Table( "user_preference", metadata,
- Column( "id", Integer, primary_key=True ),
- Column( "user_id", Integer, ForeignKey( "galaxy_user.id" ), index=True ),
- Column( "name", Unicode( 255 ), index=True),
- Column( "value", Unicode( 1024 ) ) )
- def upgrade():
- display_migration_details()
- metadata.reflect()
- try:
- UserPreference_table.create()
- except Exception, e:
- print str(e)
- log.debug( "Creating user_preference table failed: %s" % str( e ) )
- def downgrade():
- metadata.reflect()
- try:
- UserPreference_table.drop()
- except Exception, e:
- print str(e)
- log.debug( "Dropping user_preference table failed: %s" % str( e ) )