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'))