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")))
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"))))
def downgrade(tables, tester, progress_reporter): op = ProgressWrapper(original_op, progress_reporter) op.drop_column("user", "location")
def downgrade(tables, tester, progress_reporter): op = ProgressWrapper(original_op, progress_reporter) # ### commands auto generated by Alembic - please adjust! ### op.drop_column("user", "maximum_queued_builds_count")
def downgrade(tables, tester, progress_reporter): op = ProgressWrapper(original_op, progress_reporter) # ### commands auto generated by Alembic - please adjust! ### op.drop_index('repositorybuildtrigger_disabled_datetime', table_name='repositorybuildtrigger') op.drop_column('repositorybuildtrigger', 'disabled_datetime')
def upgrade(tables, tester, progress_reporter): op = ProgressWrapper(original_op, progress_reporter) # ### commands auto generated by Alembic - please adjust! ### op.drop_index("oauthaccesstoken_refresh_token", table_name="oauthaccesstoken") op.drop_column(u"oauthaccesstoken", "refresh_token") op.drop_column("accesstoken", "code") op.drop_column("appspecificauthtoken", "token_code") op.drop_column("oauthaccesstoken", "access_token") op.drop_column("oauthapplication", "client_secret") op.drop_column("oauthauthorizationcode", "code") op.drop_column("repositorybuildtrigger", "private_key") op.drop_column("repositorybuildtrigger", "auth_token") # ### end Alembic commands ### # Overwrite all plaintext robot credentials. from app import app if app.config.get("SETUP_COMPLETE", False) or tester.is_testing(): while True: try: robot_account_token = RobotAccountToken.get(fully_migrated=False) robot_account = robot_account_token.robot_account robot_account.email = str(uuid.uuid4()) robot_account.save() federated_login = FederatedLogin.get(user=robot_account) federated_login.service_ident = "robot:%s" % robot_account.id federated_login.save() robot_account_token.fully_migrated = True robot_account_token.save() except RobotAccountToken.DoesNotExist: break
def upgrade(tables, tester, progress_reporter): op = ProgressWrapper(original_op, progress_reporter) # ### commands auto generated by Alembic - please adjust! ### op.drop_index("manifestblob_manifest_id_blob_index", table_name="manifestblob") op.drop_column("manifestblob", "blob_index")
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")))
def downgrade(tables, tester, progress_reporter): op = ProgressWrapper(original_op, progress_reporter) # ### commands auto generated by Alembic - please adjust! ### op.drop_column('user', 'creation_date')
def upgrade(tables, tester, progress_reporter): op = ProgressWrapper(original_op, progress_reporter) op.drop_column("imagestorage", "checksum")
def downgrade(tables, tester, progress_reporter): op = ProgressWrapper(original_op, progress_reporter) # ### commands auto generated by Alembic - please adjust! ### op.drop_index("user_last_accessed", table_name="user") op.drop_column("user", "last_accessed")
def upgrade(tables, tester, progress_reporter): op = ProgressWrapper(original_op, progress_reporter) # ### commands auto generated by Alembic - please adjust! ### op.drop_index("oauthaccesstoken_refresh_token", table_name="oauthaccesstoken") op.drop_column(u"oauthaccesstoken", "refresh_token") op.drop_column("accesstoken", "code") op.drop_column("appspecificauthtoken", "token_code") op.drop_column("oauthaccesstoken", "access_token") op.drop_column("oauthapplication", "client_secret") op.drop_column("oauthauthorizationcode", "code") op.drop_column("repositorybuildtrigger", "private_key") op.drop_column("repositorybuildtrigger", "auth_token") # ### end Alembic commands ### # Overwrite all plaintext robot credentials. from app import app if app.config.get("SETUP_COMPLETE", False) or tester.is_testing(): while True: try: robot_account_token = RobotAccountToken.get(fully_migrated=False) logger.debug("Found robot account token %s migrate", robot_account_token.id) robot_account = robot_account_token.robot_account assert robot_account.robot result = ( User.update(email=str(uuid.uuid4())) .where( User.id == robot_account.id, User.robot == True, User.uuid == robot_account.uuid, ) .execute() ) assert result == 1 try: federated_login = FederatedLogin.get(user=robot_account) assert federated_login.service.name == "quayrobot" federated_login.service_ident = "robot:%s" % robot_account.id federated_login.save() except FederatedLogin.DoesNotExist: pass robot_account_token.fully_migrated = True robot_account_token.save() logger.debug("Finished migrating robot account token %s", robot_account_token.id) except RobotAccountToken.DoesNotExist: break
def downgrade(tables, tester, progress_reporter): op = ProgressWrapper(original_op, progress_reporter) # ### commands auto generated by Alembic - please adjust! ### op.drop_index("queueitem_state_id", table_name="queueitem") op.drop_column("queueitem", "state_id")
def upgrade(tables, tester, progress_reporter): op = ProgressWrapper(original_op, progress_reporter) # ### commands auto generated by Alembic - please adjust! ### op.drop_index('oauthaccesstoken_refresh_token', table_name='oauthaccesstoken') op.drop_column(u'oauthaccesstoken', 'refresh_token') op.drop_column('accesstoken', 'code') op.drop_column('appspecificauthtoken', 'token_code') op.drop_column('oauthaccesstoken', 'access_token') op.drop_column('oauthapplication', 'client_secret') op.drop_column('oauthauthorizationcode', 'code') op.drop_column('repositorybuildtrigger', 'private_key') op.drop_column('repositorybuildtrigger', 'auth_token') # ### end Alembic commands ### # Overwrite all plaintext robot credentials. while True: try: robot_account_token = RobotAccountToken.get(fully_migrated=False) robot_account = robot_account_token.robot_account robot_account.email = str(uuid.uuid4()) robot_account.save() federated_login = FederatedLogin.get(user=robot_account) federated_login.service_ident = 'robot:%s' % robot_account.id federated_login.save() robot_account_token.fully_migrated = True robot_account_token.save() except RobotAccountToken.DoesNotExist: break
def downgrade(tables, tester, progress_reporter): op = ProgressWrapper(original_op, progress_reporter) # ### commands auto generated by Alembic - please adjust! ### op.drop_column(u"repositorybuildtrigger", "secure_private_key") op.drop_column(u"repositorybuildtrigger", "secure_auth_token") op.drop_index("oauthauthorizationcode_code", table_name="oauthauthorizationcode") op.create_index("oauthauthorizationcode_code", "oauthauthorizationcode", ["code"], unique=False) op.drop_index("oauthauthorizationcode_code_name", table_name="oauthauthorizationcode") op.drop_column(u"oauthauthorizationcode", "code_name") op.drop_column(u"oauthauthorizationcode", "code_credential") op.drop_column(u"oauthapplication", "secure_client_secret") op.drop_index("oauthaccesstoken_token_name", table_name="oauthaccesstoken") op.drop_column(u"oauthaccesstoken", "token_name") op.drop_column(u"oauthaccesstoken", "token_code") op.drop_column(u"emailconfirmation", "verification_code") op.drop_index("appspecificauthtoken_token_name", table_name="appspecificauthtoken") op.drop_column(u"appspecificauthtoken", "token_secret") op.drop_column(u"appspecificauthtoken", "token_name") op.drop_index("accesstoken_token_name", table_name="accesstoken") op.drop_column(u"accesstoken", "token_name") op.drop_column(u"accesstoken", "token_code") op.drop_table("robotaccounttoken")
def downgrade(tables, tester, progress_reporter): op = ProgressWrapper(original_op, progress_reporter) # ### commands auto generated by Alembic - please adjust! ### op.drop_column(u'repositorybuildtrigger', 'secure_private_key') op.drop_column(u'repositorybuildtrigger', 'secure_auth_token') op.drop_index('oauthauthorizationcode_code', table_name='oauthauthorizationcode') op.create_index('oauthauthorizationcode_code', 'oauthauthorizationcode', ['code'], unique=False) op.drop_index('oauthauthorizationcode_code_name', table_name='oauthauthorizationcode') op.drop_column(u'oauthauthorizationcode', 'code_name') op.drop_column(u'oauthauthorizationcode', 'code_credential') op.drop_column(u'oauthapplication', 'secure_client_secret') op.drop_index('oauthaccesstoken_token_name', table_name='oauthaccesstoken') op.drop_column(u'oauthaccesstoken', 'token_name') op.drop_column(u'oauthaccesstoken', 'token_code') op.drop_column(u'emailconfirmation', 'verification_code') op.drop_index('appspecificauthtoken_token_name', table_name='appspecificauthtoken') op.drop_column(u'appspecificauthtoken', 'token_secret') op.drop_column(u'appspecificauthtoken', 'token_name') op.drop_index('accesstoken_token_name', table_name='accesstoken') op.drop_column(u'accesstoken', 'token_name') op.drop_column(u'accesstoken', 'token_code') op.drop_table('robotaccounttoken')