/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

  1. """
  2. Migration script to add columns for tracking whether pages are deleted and
  3. publicly accessible.
  4. """
  5. from sqlalchemy import *
  6. from migrate import *
  7. from migrate.changeset import *
  8. import logging
  9. log = logging.getLogger( __name__ )
  10. metadata = MetaData( migrate_engine )
  11. def upgrade():
  12. print __doc__
  13. metadata.reflect()
  14. Page_table = Table( "page", metadata, autoload=True )
  15. c = Column( "published", Boolean, index=True, default=False )
  16. c.create( Page_table )
  17. assert c is Page_table.c.published
  18. c = Column( "deleted", Boolean, index=True, default=False )
  19. c.create( Page_table )
  20. assert c is Page_table.c.deleted
  21. def downgrade():
  22. metadata.reflect()
  23. Page_table = Table( "page", metadata, autoload=True )
  24. Page_table.c.published.drop()
  25. Page_table.c.deleted.drop()