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