def upgrade(tables, tester, progress_reporter):
op = ProgressWrapper(original_op, progress_reporter)
# ### commands auto generated by Alembic - please adjust! ###
op.create_table(
"disablereason",
sa.Column("id", sa.Integer(), nullable=False),
sa.Column("name", sa.String(length=255), nullable=False),
sa.PrimaryKeyConstraint("id", name=op.f("pk_disablereason")),
)
op.create_index("disablereason_name",
"disablereason", ["name"],
unique=True)
op.bulk_insert(
tables.disablereason,
[
{
"id": 1,
"name": "user_toggled"
},
],
)
op.bulk_insert(tables.logentrykind, [
{
"name": "toggle_repo_trigger"
},
])
op.add_column(u"repositorybuildtrigger",
sa.Column("disabled_reason_id", sa.Integer(), nullable=True))
op.add_column(
u"repositorybuildtrigger",
sa.Column("enabled",
sa.Boolean(),
nullable=False,
server_default=sa.sql.expression.true()),
)
op.create_index(
"repositorybuildtrigger_disabled_reason_id",
"repositorybuildtrigger",
["disabled_reason_id"],
unique=False,
)
op.create_foreign_key(
op.f("fk_repositorybuildtrigger_disabled_reason_id_disablereason"),
"repositorybuildtrigger",
"disablereason",
["disabled_reason_id"],
["id"],
)
# ### end Alembic commands ###
# ### population of test data ### #
tester.populate_column("repositorybuildtrigger", "disabled_reason_id",
tester.TestDataType.Foreign("disablereason"))
tester.populate_column("repositorybuildtrigger", "enabled",
tester.TestDataType.Boolean)
def upgrade(tables, tester, progress_reporter):
op = ProgressWrapper(original_op, progress_reporter)
# ### commands auto generated by Alembic - please adjust! ###
op.add_column(
"messages",
sa.Column("media_type_id",
sa.Integer(),
nullable=False,
server_default="1"))
op.add_column(
"messages",
sa.Column("severity",
sa.String(length=255),
nullable=False,
server_default="info"),
)
op.alter_column(
"messages",
"uuid",
existing_type=mysql.VARCHAR(length=36),
server_default="",
nullable=False,
)
op.create_index("messages_media_type_id",
"messages", ["media_type_id"],
unique=False)
op.create_index("messages_severity",
"messages", ["severity"],
unique=False)
op.create_index("messages_uuid", "messages", ["uuid"], unique=False)
op.create_foreign_key(
op.f("fk_messages_media_type_id_mediatype"),
"messages",
"mediatype",
["media_type_id"],
["id"],
)
# ### end Alembic commands ###
op.bulk_insert(tables.mediatype, [
{
"name": "text/markdown"
},
])
# ### population of test data ### #
tester.populate_column("messages", "media_type_id",
tester.TestDataType.Foreign("mediatype"))
tester.populate_column("messages", "severity", lambda: "info")
tester.populate_column("messages", "uuid", tester.TestDataType.UUID)
def upgrade(tables, tester, progress_reporter):
op = ProgressWrapper(original_op, progress_reporter)
# ### commands auto generated by Alembic - please adjust! ###
op.create_table(
'disablereason', sa.Column('id', sa.Integer(), nullable=False),
sa.Column('name', sa.String(length=255), nullable=False),
sa.PrimaryKeyConstraint('id', name=op.f('pk_disablereason')))
op.create_index('disablereason_name',
'disablereason', ['name'],
unique=True)
op.bulk_insert(
tables.disablereason,
[
{
'id': 1,
'name': 'user_toggled'
},
],
)
op.bulk_insert(tables.logentrykind, [
{
'name': 'toggle_repo_trigger'
},
])
op.add_column(u'repositorybuildtrigger',
sa.Column('disabled_reason_id', sa.Integer(), nullable=True))
op.add_column(
u'repositorybuildtrigger',
sa.Column('enabled',
sa.Boolean(),
nullable=False,
server_default=sa.sql.expression.true()))
op.create_index('repositorybuildtrigger_disabled_reason_id',
'repositorybuildtrigger', ['disabled_reason_id'],
unique=False)
op.create_foreign_key(
op.f('fk_repositorybuildtrigger_disabled_reason_id_disablereason'),
'repositorybuildtrigger', 'disablereason', ['disabled_reason_id'],
['id'])
# ### end Alembic commands ###
# ### population of test data ### #
tester.populate_column('repositorybuildtrigger', 'disabled_reason_id',
tester.TestDataType.Foreign('disablereason'))
tester.populate_column('repositorybuildtrigger', 'enabled',
tester.TestDataType.Boolean)
def upgrade(tables, tester, progress_reporter):
op = ProgressWrapper(original_op, progress_reporter)
op.create_table(
"repositorykind",
sa.Column("id", sa.Integer(), nullable=False),
sa.Column("name", sa.String(length=255), nullable=False),
sa.PrimaryKeyConstraint("id", name=op.f("pk_repositorykind")),
)
op.create_index("repositorykind_name",
"repositorykind", ["name"],
unique=True)
op.bulk_insert(
tables.repositorykind,
[
{
"id": 1,
"name": "image"
},
{
"id": 2,
"name": "application"
},
],
)
op.add_column(
u"repository",
sa.Column("kind_id", sa.Integer(), nullable=False, server_default="1"))
op.create_index("repository_kind_id",
"repository", ["kind_id"],
unique=False)
op.create_foreign_key(
op.f("fk_repository_kind_id_repositorykind"),
"repository",
"repositorykind",
["kind_id"],
["id"],
)
# ### population of test data ### #
tester.populate_column("repository", "kind_id",
tester.TestDataType.Foreign("repositorykind"))
def upgrade(tables, tester, progress_reporter):
op = ProgressWrapper(original_op, progress_reporter)
# ### commands auto generated by Alembic - please adjust! ###
op.add_column(
'messages',
sa.Column('media_type_id',
sa.Integer(),
nullable=False,
server_default='1'))
op.add_column(
'messages',
sa.Column('severity',
sa.String(length=255),
nullable=False,
server_default='info'))
op.alter_column('messages',
'uuid',
existing_type=mysql.VARCHAR(length=36),
server_default='',
nullable=False)
op.create_index('messages_media_type_id',
'messages', ['media_type_id'],
unique=False)
op.create_index('messages_severity',
'messages', ['severity'],
unique=False)
op.create_index('messages_uuid', 'messages', ['uuid'], unique=False)
op.create_foreign_key(op.f('fk_messages_media_type_id_mediatype'),
'messages', 'mediatype', ['media_type_id'], ['id'])
# ### end Alembic commands ###
op.bulk_insert(tables.mediatype, [
{
'name': 'text/markdown'
},
])
# ### population of test data ### #
tester.populate_column('messages', 'media_type_id',
tester.TestDataType.Foreign('mediatype'))
tester.populate_column('messages', 'severity', lambda: 'info')
tester.populate_column('messages', 'uuid', tester.TestDataType.UUID)
def upgrade(tables, tester, progress_reporter):
op = ProgressWrapper(original_op, progress_reporter)
op.create_table(
'repositorykind', sa.Column('id', sa.Integer(), nullable=False),
sa.Column('name', sa.String(length=255), nullable=False),
sa.PrimaryKeyConstraint('id', name=op.f('pk_repositorykind')))
op.create_index('repositorykind_name',
'repositorykind', ['name'],
unique=True)
op.bulk_insert(
tables.repositorykind,
[
{
'id': 1,
'name': 'image'
},
{
'id': 2,
'name': 'application'
},
],
)
op.add_column(
u'repository',
sa.Column('kind_id', sa.Integer(), nullable=False, server_default='1'))
op.create_index('repository_kind_id',
'repository', ['kind_id'],
unique=False)
op.create_foreign_key(op.f('fk_repository_kind_id_repositorykind'),
'repository', 'repositorykind', ['kind_id'], ['id'])
# ### population of test data ### #
tester.populate_column('repository', 'kind_id',
tester.TestDataType.Foreign('repositorykind'))
