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 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():
drop_column(col, GroupsTable)
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():
# 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)
def downgrade():
drop_column(col, PeopleTable)
def downgrade():
drop_column(myth_role, hosts)
drop_column(myth_remote, hosts)
drop_column(myth_theme, hosts)
