/lib/galaxy/model/migrate/versions/0023_page_published_and_deleted_columns.py
https://bitbucket.org/h_morita_dbcls/galaxy-central · Python · 35 lines · 21 code · 10 blank · 4 comment · 0 complexity · a575351a5d913184eea69e7af5d0ecbd MD5 · raw file
- """
- Migration script to add columns for tracking whether pages are deleted and
- publicly accessible.
- """
- from sqlalchemy import *
- from migrate import *
- from migrate.changeset import *
- import logging
- log = logging.getLogger( __name__ )
- metadata = MetaData( migrate_engine )
- def upgrade():
-
- print __doc__
- metadata.reflect()
-
- Page_table = Table( "page", metadata, autoload=True )
-
- c = Column( "published", Boolean, index=True, default=False )
- c.create( Page_table )
- assert c is Page_table.c.published
-
- c = Column( "deleted", Boolean, index=True, default=False )
- c.create( Page_table )
- assert c is Page_table.c.deleted
- def downgrade():
- metadata.reflect()
- Page_table = Table( "page", metadata, autoload=True )
- Page_table.c.published.drop()
- Page_table.c.deleted.drop()