Python ProgressWrapper.execute示例

示例#1

def downgrade(tables, tester, progress_reporter):
    op = ProgressWrapper(original_op, progress_reporter)
    op.drop_column(u"repository", "state")

    op.drop_table("repomirrorconfig")

    op.drop_table("repomirrorrule")

    for logentrykind in [
            "repo_mirror_enabled",
            "repo_mirror_disabled",
            "repo_mirror_config_changed",
            "repo_mirror_sync_started",
            "repo_mirror_sync_failed",
            "repo_mirror_sync_success",
            "repo_mirror_sync_now_requested",
            "repo_mirror_sync_tag_success",
            "repo_mirror_sync_tag_failed",
            "repo_mirror_sync_test_success",
            "repo_mirror_sync_test_failed",
            "repo_mirror_sync_test_started",
            "change_repo_state",
    ]:
        op.execute(tables.logentrykind.delete().where(
            tables.logentrykind.c.name == op.inline_literal(logentrykind)))

示例#2

def downgrade(tables, tester, progress_reporter):
  op = ProgressWrapper(original_op, progress_reporter)
  op.drop_column('repositorynotification', 'number_of_failures')
  op.execute(tables
             .logentrykind
             .delete()
             .where(tables.logentrykind.c.name == op.inline_literal('reset_repo_notification')))

示例#3

文件： 94836b099894_create_new_notification_type.py 项目： xzwupeng/quay

def downgrade(tables, tester, progress_reporter):
    op = ProgressWrapper(original_op, progress_reporter)
    op.execute(tables
               .externalnotificationevent
               .delete()
               .where(tables.
                      externalnotificationevent.c.name == op.inline_literal('build_cancelled')))

示例#4

def downgrade(tables, tester, progress_reporter):
    op = ProgressWrapper(original_op, progress_reporter)
    op.execute(
        tables.notificationkind.delete().where(
            tables.notificationkind.c.name == op.inline_literal("build_cancelled")
        )
    )

示例#5

文件： d8989249f8f6_add_change_tag_expiration_log_type.py 项目： zhill/quay

def downgrade(tables, tester, progress_reporter):
    op = ProgressWrapper(original_op, progress_reporter)
    op.execute(
        tables.logentrykind.delete().where(
            tables.logentrykind.c.name == op.inline_literal("change_tag_expiration")
        )
    )

示例#6

def downgrade(tables, tester, progress_reporter):
    op = ProgressWrapper(original_op, progress_reporter)
    ### commands auto generated by Alembic - please adjust! ###
    op.drop_column("repository", "trust_enabled")
    ### end Alembic commands ###

    op.execute(tables.logentrykind.delete().where(
        tables.logentrykind.name == op.inline_literal("change_repo_trust")))

示例#7

def downgrade(tables, tester, progress_reporter):
    op = ProgressWrapper(original_op, progress_reporter)
    for media_type in DOCKER_SCHEMA2_CONTENT_TYPES:
        op.execute(tables
                    .mediatype
                    .delete()
                    .where(tables.
                            mediatype.c.name == op.inline_literal(media_type)))

示例#8

def downgrade(tables, tester, progress_reporter):
    op = ProgressWrapper(original_op, progress_reporter)
    ### commands auto generated by Alembic - please adjust! ###
    op.drop_column("user", "given_name")
    op.drop_column("user", "family_name")
    op.drop_column("user", "company")
    ### end Alembic commands ###

    op.execute((tables.userpromptkind.delete().where(
        tables.userpromptkind.c.name == op.inline_literal("enter_name"))))

    op.execute((tables.userpromptkind.delete().where(
        tables.userpromptkind.c.name == op.inline_literal("enter_company"))))

示例#9

def downgrade(tables, tester, progress_reporter):
    op = ProgressWrapper(original_op, progress_reporter)
    for media_type in DOCKER_SCHEMA1_CONTENT_TYPES:
        op.execute(tables.mediatype.delete().where(
            tables.mediatype.c.name == op.inline_literal(media_type)))

    # ### commands auto generated by Alembic - please adjust! ###
    op.drop_table("tagmanifestlabelmap")
    op.drop_table("tagmanifesttomanifest")
    op.drop_table("manifestlegacyimage")
    op.drop_table("manifestlabel")
    op.drop_table("manifestblob")
    op.drop_table("manifest")

示例#10

def downgrade(tables, tester, progress_reporter):
    op = ProgressWrapper(original_op, progress_reporter)
    # ### commands auto generated by Alembic - please adjust! ###
    op.drop_table("appspecificauthtoken")
    # ### end Alembic commands ###

    op.execute(tables.logentrykind.delete().where(
        tables.logentrykind.name == op.inline_literal(
            "create_app_specific_token")))

    op.execute(tables.logentrykind.delete().where(
        tables.logentrykind.name == op.inline_literal(
            "revoke_app_specific_token")))

示例#11

def downgrade(tables, tester, progress_reporter):
    op = ProgressWrapper(original_op, progress_reporter)
    # ### commands auto generated by Alembic - please adjust! ###
    op.drop_column('repositorybuildtrigger', 'successive_internal_error_count')
    op.drop_column('repositorybuildtrigger', 'successive_failure_count')
    # ### end Alembic commands ###

    op.execute(tables.disablereason.delete().where(
        tables.disablereason.c.name == op.inline_literal(
            'successive_internal_error_count')))

    op.execute(tables.disablereason.delete().where(
        tables.disablereason.c.name == op.inline_literal(
            'successive_failure_count')))

示例#12

def downgrade(tables, tester, progress_reporter):
    op = ProgressWrapper(original_op, progress_reporter)
    # ### commands auto generated by Alembic - please adjust! ###
    op.drop_constraint(
        op.f('fk_repositorybuildtrigger_disabled_reason_id_disablereason'),
        'repositorybuildtrigger',
        type_='foreignkey')
    op.drop_index('repositorybuildtrigger_disabled_reason_id',
                  table_name='repositorybuildtrigger')
    op.drop_column(u'repositorybuildtrigger', 'enabled')
    op.drop_column(u'repositorybuildtrigger', 'disabled_reason_id')
    op.drop_table('disablereason')
    # ### end Alembic commands ###

    op.execute(tables.logentrykind.delete().where(
        tables.logentrykind.c.name == op.inline_literal(
            'toggle_repo_trigger')))

示例#13

文件： 61cadbacb9fc_add_ability_for_build_triggers_to_be_.py 项目： zhill/quay

def downgrade(tables, tester, progress_reporter):
    op = ProgressWrapper(original_op, progress_reporter)
    # ### commands auto generated by Alembic - please adjust! ###
    op.drop_constraint(
        op.f("fk_repositorybuildtrigger_disabled_reason_id_disablereason"),
        "repositorybuildtrigger",
        type_="foreignkey",
    )
    op.drop_index("repositorybuildtrigger_disabled_reason_id",
                  table_name="repositorybuildtrigger")
    op.drop_column(u"repositorybuildtrigger", "enabled")
    op.drop_column(u"repositorybuildtrigger", "disabled_reason_id")
    op.drop_table("disablereason")
    # ### end Alembic commands ###

    op.execute(tables.logentrykind.delete().where(
        tables.logentrykind.c.name == op.inline_literal(
            "toggle_repo_trigger")))

示例#14

文件： 3e8cc74a1e7b_add_severity_and_media_type_to_global_.py 项目： xzwupeng/quay

def downgrade(tables, tester, progress_reporter):
    op = ProgressWrapper(original_op, progress_reporter)
    # ### commands auto generated by Alembic - please adjust! ###
    op.drop_constraint(op.f('fk_messages_media_type_id_mediatype'),
                       'messages',
                       type_='foreignkey')
    op.drop_index('messages_uuid', table_name='messages')
    op.drop_index('messages_severity', table_name='messages')
    op.drop_index('messages_media_type_id', table_name='messages')
    op.alter_column('messages',
                    'uuid',
                    existing_type=mysql.VARCHAR(length=36),
                    nullable=True)
    op.drop_column('messages', 'severity')
    op.drop_column('messages', 'media_type_id')
    # ### end Alembic commands ###

    op.execute(tables.mediatype.delete().where(
        tables.mediatype.c.name == op.inline_literal('text/markdown')))

示例#15

文件： 3e8cc74a1e7b_add_severity_and_media_type_to_global_.py 项目： zhangli19817/quay

def downgrade(tables, tester, progress_reporter):
    op = ProgressWrapper(original_op, progress_reporter)
    # ### commands auto generated by Alembic - please adjust! ###
    op.drop_constraint(op.f("fk_messages_media_type_id_mediatype"),
                       "messages",
                       type_="foreignkey")
    op.drop_index("messages_uuid", table_name="messages")
    op.drop_index("messages_severity", table_name="messages")
    op.drop_index("messages_media_type_id", table_name="messages")
    op.alter_column("messages",
                    "uuid",
                    existing_type=mysql.VARCHAR(length=36),
                    nullable=True)
    op.drop_column("messages", "severity")
    op.drop_column("messages", "media_type_id")
    # ### end Alembic commands ###

    op.execute(tables.mediatype.delete().where(
        tables.mediatype.c.name == op.inline_literal("text/markdown")))

示例#16

文件： cc6778199cdb_repository_mirror_notification.py 项目： xzwupeng/quay

def downgrade(tables, tester, progress_reporter):
    op = ProgressWrapper(original_op, progress_reporter)

    op.execute(tables.notificationkind.delete().where(
        tables.notificationkind.c.name == op.inline_literal(
            'repo_mirror_sync_started')))
    op.execute(tables.notificationkind.delete().where(
        tables.notificationkind.c.name == op.inline_literal(
            'repo_mirror_sync_success')))
    op.execute(tables.notificationkind.delete().where(
        tables.notificationkind.c.name == op.inline_literal(
            'repo_mirror_sync_failed')))

    op.execute(tables.externalnotificationevent.delete().where(
        tables.externalnotificationevent.c.name == op.inline_literal(
            'repo_mirror_sync_started')))
    op.execute(tables.externalnotificationevent.delete().where(
        tables.externalnotificationevent.c.name == op.inline_literal(
            'repo_mirror_sync_success')))
    op.execute(tables.externalnotificationevent.delete().where(
        tables.externalnotificationevent.c.name == op.inline_literal(
            'repo_mirror_sync_failed')))