def upgrade(migrate_engine): metadata = sa.MetaData() metadata.bind = migrate_engine sa.Table('sourcestamps', metadata, sa.Column('id', sa.Integer, primary_key=True), sa.Column('ss_hash', sa.String(40), nullable=False), sa.Column('branch', sa.String(256)), sa.Column('revision', sa.String(256)), sa.Column('patchid', sa.Integer, sa.ForeignKey('patches.id')), sa.Column('repository', sa.String(length=512), nullable=False, server_default=''), sa.Column('codebase', sa.String(256), nullable=False, server_default=sa.DefaultClause("")), sa.Column('project', sa.String(length=512), nullable=False, server_default=''), sa.Column('created_at', sa.Integer, nullable=False)) # Specify what the new table should look like changes = sa.Table('changes', metadata, sa.Column('changeid', sa.Integer, primary_key=True), sa.Column('author', sa.String(256), nullable=False), sa.Column('comments', sa.String(1024), nullable=False), sa.Column('branch', sa.String(256)), sa.Column('revision', sa.String(256)), sa.Column('revlink', sa.String(256)), sa.Column('when_timestamp', sa.Integer, nullable=False), sa.Column('category', sa.String(256)), sa.Column('repository', sa.String(length=512), nullable=False, server_default=''), sa.Column('codebase', sa.String(256), nullable=False, server_default=sa.DefaultClause("")), sa.Column('project', sa.String(length=512), nullable=False, server_default=''), sa.Column('sourcestampid', sa.Integer, sa.ForeignKey('sourcestamps.id')) ) # Now drop column changeset.drop_column( sa.Column('is_dir', sa.SmallInteger, nullable=False), table=changes, metadata=metadata, engine=migrate_engine) # re-create all indexes on the table - sqlite dropped them if migrate_engine.dialect.name == 'sqlite': idx = sa.Index('changes_branch', changes.c.branch) idx.create() idx = sa.Index('changes_revision', changes.c.revision) idx.create() idx = sa.Index('changes_author', changes.c.author) idx.create() idx = sa.Index('changes_category', changes.c.category) idx.create() idx = sa.Index('changes_when_timestamp', changes.c.when_timestamp) idx.create() idx = sa.Index('changes_sourcestampid', changes.c.sourcestampid) idx.create()
def remove_buildername(migrate_engine): metadata = sa.MetaData() metadata.bind = migrate_engine sa.Table('builders', metadata, autoload=True) sa.Table('buildsets', metadata, autoload=True) # Specify what the new table should look like buildrequests = sa.Table( 'buildrequests', metadata, sa.Column('id', sa.Integer, primary_key=True), sa.Column('buildsetid', sa.Integer, sa.ForeignKey("buildsets.id"), nullable=False), sa.Column('builderid', sa.Integer, sa.ForeignKey('builders.id'), nullable=False), sa.Column('priority', sa.Integer, nullable=False, server_default=sa.DefaultClause("0")), sa.Column('complete', sa.Integer, server_default=sa.DefaultClause("0")), sa.Column('results', sa.SmallInteger), sa.Column('submitted_at', sa.Integer, nullable=False), sa.Column('complete_at', sa.Integer), sa.Column('waited_for', sa.SmallInteger, server_default=sa.DefaultClause("0")), ) changeset.drop_column(sa.Column('buildername', sa.String(length=256), nullable=False), table=buildrequests, metadata=metadata, engine=migrate_engine) changeset.alter_column(sa.Column('builderid', sa.Integer, sa.ForeignKey("builders.id"), nullable=False), table='buildrequests', metadata=metadata, engine=migrate_engine) idx = sa.Index('buildrequests_builderid', buildrequests.c.builderid) idx.create(migrate_engine) idx = sa.Index('buildrequests_buildsetid', buildrequests.c.buildsetid) idx.create(migrate_engine) idx = sa.Index('buildrequests_complete', buildrequests.c.complete) idx.create(migrate_engine)
def upgrade(migrate_engine): metadata = sa.MetaData() metadata.bind = migrate_engine sautils.Table( "sourcestamps", metadata, sa.Column("id", sa.Integer, primary_key=True), sa.Column("ss_hash", sa.String(40), nullable=False), sa.Column("branch", sa.String(256)), sa.Column("revision", sa.String(256)), sa.Column("patchid", sa.Integer, sa.ForeignKey("patches.id")), sa.Column("repository", sa.String(length=512), nullable=False, server_default=""), sa.Column("codebase", sa.String(256), nullable=False, server_default=sa.DefaultClause("")), sa.Column("project", sa.String(length=512), nullable=False, server_default=""), sa.Column("created_at", sa.Integer, nullable=False), ) # Specify what the new table should look like changes = sautils.Table( "changes", metadata, sa.Column("changeid", sa.Integer, primary_key=True), sa.Column("author", sa.String(256), nullable=False), sa.Column("comments", sa.String(1024), nullable=False), sa.Column("branch", sa.String(256)), sa.Column("revision", sa.String(256)), sa.Column("revlink", sa.String(256)), sa.Column("when_timestamp", sa.Integer, nullable=False), sa.Column("category", sa.String(256)), sa.Column("repository", sa.String(length=512), nullable=False, server_default=""), sa.Column("codebase", sa.String(256), nullable=False, server_default=sa.DefaultClause("")), sa.Column("project", sa.String(length=512), nullable=False, server_default=""), sa.Column("sourcestampid", sa.Integer, sa.ForeignKey("sourcestamps.id")), ) # Now drop column changeset.drop_column( sa.Column("is_dir", sa.SmallInteger, nullable=False), table=changes, metadata=metadata, engine=migrate_engine ) # re-create all indexes on the table - sqlite dropped them if migrate_engine.dialect.name == "sqlite": idx = sa.Index("changes_branch", changes.c.branch) idx.create() idx = sa.Index("changes_revision", changes.c.revision) idx.create() idx = sa.Index("changes_author", changes.c.author) idx.create() idx = sa.Index("changes_category", changes.c.category) idx.create() idx = sa.Index("changes_when_timestamp", changes.c.when_timestamp) idx.create() idx = sa.Index("changes_sourcestampid", changes.c.sourcestampid) idx.create()
def remove_buildername(migrate_engine): metadata = sa.MetaData() metadata.bind = migrate_engine sa.Table('builders', metadata, autoload=True) sa.Table('buildsets', metadata, autoload=True) # Specify what the new table should look like buildrequests = sa.Table('buildrequests', metadata, sa.Column('id', sa.Integer, primary_key=True), sa.Column('buildsetid', sa.Integer, sa.ForeignKey("buildsets.id"), nullable=False), sa.Column('builderid', sa.Integer, sa.ForeignKey('builders.id'), nullable=False), sa.Column('priority', sa.Integer, nullable=False, server_default=sa.DefaultClause("0")), sa.Column('complete', sa.Integer, server_default=sa.DefaultClause("0")), sa.Column('results', sa.SmallInteger), sa.Column('submitted_at', sa.Integer, nullable=False), sa.Column('complete_at', sa.Integer), sa.Column('waited_for', sa.SmallInteger, server_default=sa.DefaultClause("0")), ) changeset.drop_column( sa.Column('buildername', sa.String(length=256), nullable=False), table=buildrequests, metadata=metadata, engine=migrate_engine) changeset.alter_column( sa.Column('builderid', sa.Integer, sa.ForeignKey("builders.id"), nullable=False), table='buildrequests', metadata=metadata, engine=migrate_engine) idx = sa.Index('buildrequests_builderid', buildrequests.c.builderid) idx.create(migrate_engine) idx = sa.Index('buildrequests_buildsetid', buildrequests.c.buildsetid) idx.create(migrate_engine) idx = sa.Index('buildrequests_complete', buildrequests.c.complete) idx.create(migrate_engine)
def upgrade(migrate_engine): metadata = sa.MetaData() metadata.bind = migrate_engine # Specify what the new table should look like schedulers = sa.Table("schedulers", metadata, # unique ID for scheduler sa.Column('schedulerid', sa.Integer, primary_key=True), # TODO: rename to id # scheduler's name in master.cfg sa.Column('name', sa.String(128), nullable=False), # scheduler's class name, basically representing a "type" for the state sa.Column('class_name', sa.String(128), nullable=False), ) # Now drop column changeset.drop_column( sa.Column('state', sa.String(128), nullable=False), table=schedulers, metadata=metadata, engine=migrate_engine)
def upgrade(migrate_engine): metadata = sa.MetaData() metadata.bind = migrate_engine # Specify what the new table should look like schedulers = sautils.Table( "schedulers", metadata, # unique ID for scheduler sa.Column("schedulerid", sa.Integer, primary_key=True), # TODO: rename to id # scheduler's name in master.cfg sa.Column("name", sa.String(128), nullable=False), # scheduler's class name, basically representing a "type" for the state sa.Column("class_name", sa.String(128), nullable=False), ) # Now drop column changeset.drop_column( sa.Column("state", sa.String(128), nullable=False), table=schedulers, metadata=metadata, engine=migrate_engine )
def downgrade(): drop_column(myth_systemrole, hosts) drop_column(mythremote, hosts) drop_column(myththeme, hosts)
def downgrade(): drop_column(col, GroupsTable)
def upgrade(migrate_engine): metadata = sa.MetaData() metadata.bind = migrate_engine sautils.Table('sourcestamps', metadata, sa.Column('id', sa.Integer, primary_key=True), sa.Column('ss_hash', sa.String(40), nullable=False), sa.Column('branch', sa.String(256)), sa.Column('revision', sa.String(256)), sa.Column( 'patchid', sa.Integer, sa.ForeignKey('patches.id')), sa.Column('repository', sa.String(length=512), nullable=False, server_default=''), sa.Column('codebase', sa.String(256), nullable=False, server_default=sa.DefaultClause("")), sa.Column('project', sa.String(length=512), nullable=False, server_default=''), sa.Column('created_at', sa.Integer, nullable=False)) # Specify what the new table should look like changes = sautils.Table('changes', metadata, sa.Column( 'changeid', sa.Integer, primary_key=True), sa.Column( 'author', sa.String(256), nullable=False), sa.Column( 'comments', sa.String(1024), nullable=False), sa.Column('branch', sa.String(256)), sa.Column('revision', sa.String(256)), sa.Column('revlink', sa.String(256)), sa.Column( 'when_timestamp', sa.Integer, nullable=False), sa.Column('category', sa.String(256)), sa.Column('repository', sa.String(length=512), nullable=False, server_default=''), sa.Column('codebase', sa.String(256), nullable=False, server_default=sa.DefaultClause("")), sa.Column('project', sa.String(length=512), nullable=False, server_default=''), sa.Column('sourcestampid', sa.Integer, sa.ForeignKey('sourcestamps.id')) ) # Now drop column changeset.drop_column( sa.Column('is_dir', sa.SmallInteger, nullable=False), table=changes, metadata=metadata, engine=migrate_engine) # re-create all indexes on the table - sqlite dropped them if migrate_engine.dialect.name == 'sqlite': idx = sa.Index('changes_branch', changes.c.branch) idx.create() idx = sa.Index('changes_revision', changes.c.revision) idx.create() idx = sa.Index('changes_author', changes.c.author) idx.create() idx = sa.Index('changes_category', changes.c.category) idx.create() idx = sa.Index('changes_when_timestamp', changes.c.when_timestamp) idx.create() idx = sa.Index('changes_sourcestampid', changes.c.sourcestampid) idx.create()
def downgrade(migrate_engine): metadata = DeclarativeBase.metadata metadata.bind = migrate_engine drop_column(Status.__table__.c.group_id, table=Status.__table__)
def downgrade(migrate_engine): metadata = DeclarativeBase.metadata metadata.bind = migrate_engine drop_column(User.__table__.c.username, table=User.__table__)
def downgrade(): drop_column(col, PeopleTable)
def downgrade(): # Operations to reverse the above upgrade go here. drop_column(description, shows_table)
def downgrade(): drop_column(myth_role, hosts) drop_column(myth_remote, hosts) drop_column(myth_theme, hosts)