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 upgrade(tables, tester, progress_reporter):
op = ProgressWrapper(original_op, progress_reporter)
### commands auto generated by Alembic - please adjust! ###
op.create_table(
"repositorysearchscore",
sa.Column("id", sa.Integer(), nullable=False),
sa.Column("repository_id", sa.Integer(), nullable=False),
sa.Column("score", sa.BigInteger(), nullable=False),
sa.Column("last_updated", sa.DateTime(), nullable=True),
sa.ForeignKeyConstraint(
["repository_id"],
["repository.id"],
name=op.f("fk_repositorysearchscore_repository_id_repository"),
),
sa.PrimaryKeyConstraint("id", name=op.f("pk_repositorysearchscore")),
)
op.create_index(
"repositorysearchscore_repository_id",
"repositorysearchscore",
["repository_id"],
unique=True,
)
op.create_index("repositorysearchscore_score", "repositorysearchscore", ["score"], unique=False)
### end Alembic commands ###
# ### population of test data ### #
tester.populate_table(
"repositorysearchscore",
[
("repository_id", tester.TestDataType.Foreign("repository")),
("score", tester.TestDataType.BigInteger),
("last_updated", tester.TestDataType.DateTime),
],
)
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 upgrade(tables, tester, progress_reporter):
op = ProgressWrapper(original_op, progress_reporter)
### commands auto generated by Alembic - please adjust! ###
op.create_table(
'repositorysearchscore', sa.Column('id', sa.Integer(), nullable=False),
sa.Column('repository_id', sa.Integer(), nullable=False),
sa.Column('score', sa.BigInteger(), nullable=False),
sa.Column('last_updated', sa.DateTime(), nullable=True),
sa.ForeignKeyConstraint(
['repository_id'], ['repository.id'],
name=op.f('fk_repositorysearchscore_repository_id_repository')),
sa.PrimaryKeyConstraint('id', name=op.f('pk_repositorysearchscore')))
op.create_index('repositorysearchscore_repository_id',
'repositorysearchscore', ['repository_id'],
unique=True)
op.create_index('repositorysearchscore_score',
'repositorysearchscore', ['score'],
unique=False)
### end Alembic commands ###
# ### population of test data ### #
tester.populate_table('repositorysearchscore', [
('repository_id', tester.TestDataType.Foreign('repository')),
('score', tester.TestDataType.BigInteger),
('last_updated', tester.TestDataType.DateTime),
])
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.create_index("queueitem_state_id",
"queueitem", ["state_id"],
unique=False)
def upgrade(tables, tester, progress_reporter):
op = ProgressWrapper(original_op, progress_reporter)
# ### commands auto generated by Alembic - please adjust! ###
op.create_table(
"robotaccountmetadata",
sa.Column("id", sa.Integer(), nullable=False),
sa.Column("robot_account_id", sa.Integer(), nullable=False),
sa.Column("description", UTF8CharField(length=255), nullable=False),
sa.Column("unstructured_json", sa.Text(), nullable=False),
sa.ForeignKeyConstraint(
["robot_account_id"],
["user.id"],
name=op.f("fk_robotaccountmetadata_robot_account_id_user"),
),
sa.PrimaryKeyConstraint("id", name=op.f("pk_robotaccountmetadata")),
)
op.create_index(
"robotaccountmetadata_robot_account_id",
"robotaccountmetadata",
["robot_account_id"],
unique=True,
)
# ### end Alembic commands ###
# ### population of test data ### #
tester.populate_table(
"robotaccountmetadata",
[
("robot_account_id", tester.TestDataType.Foreign("user")),
("description", tester.TestDataType.UTF8Char),
("unstructured_json", tester.TestDataType.JSON),
],
)
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('queueitem', sa.Column('state_id', sa.String(length=255), nullable=False, server_default=''))
op.create_index('queueitem_state_id', 'queueitem', ['state_id'], unique=False)
# ### end Alembic commands ###
# ### population of test data ### #
tester.populate_column('queueitem', 'state_id', tester.TestDataType.String)
def upgrade(tables, tester, progress_reporter):
op = ProgressWrapper(original_op, progress_reporter)
# ### commands auto generated by Alembic - please adjust! ###
op.add_column("user", sa.Column("last_accessed", sa.DateTime(), nullable=True))
op.create_index("user_last_accessed", "user", ["last_accessed"], unique=False)
# ### end Alembic commands ###
# ### population of test data ### #
tester.populate_column("user", "last_accessed", tester.TestDataType.DateTime)
def upgrade(tables, tester, progress_reporter):
op = ProgressWrapper(original_op, progress_reporter)
# Backfill the queueitem table's state_id field with unique values for all entries which are
# empty.
conn = op.get_bind()
conn.execute("update queueitem set state_id = id where state_id = ''")
# ### commands auto generated by Alembic - please adjust! ###
op.drop_index("queueitem_state_id", table_name="queueitem")
op.create_index("queueitem_state_id", "queueitem", ["state_id"], unique=True)
def downgrade(tables, tester, progress_reporter):
op = ProgressWrapper(original_op, progress_reporter)
# ### commands auto generated by Alembic - please adjust! ###
op.add_column(
'manifestblob',
sa.Column('blob_index',
mysql.INTEGER(display_width=11),
autoincrement=False,
nullable=True))
op.create_index('manifestblob_manifest_id_blob_index',
'manifestblob', ['manifest_id', 'blob_index'],
unique=True)
def upgrade(tables, tester, progress_reporter):
op = ProgressWrapper(original_op, progress_reporter)
# ### commands auto generated by Alembic - please adjust! ###
op.add_column('repositorybuildtrigger',
sa.Column('disabled_datetime', sa.DateTime(), nullable=True))
op.create_index('repositorybuildtrigger_disabled_datetime',
'repositorybuildtrigger', ['disabled_datetime'],
unique=False)
# ### end Alembic commands ###
# ### population of test data ### #
tester.populate_column('repositorybuildtrigger', 'disabled_datetime',
tester.TestDataType.DateTime)
def upgrade(tables, tester, progress_reporter):
op = ProgressWrapper(original_op, progress_reporter)
# ### commands auto generated by Alembic - please adjust! ###
op.create_table(
"appspecificauthtoken",
sa.Column("id", sa.Integer(), nullable=False),
sa.Column("user_id", sa.Integer(), nullable=False),
sa.Column("uuid", sa.String(length=36), nullable=False),
sa.Column("title", UTF8CharField(length=255), nullable=False),
sa.Column("token_code", sa.String(length=255), nullable=False),
sa.Column("created", sa.DateTime(), nullable=False),
sa.Column("expiration", sa.DateTime(), nullable=True),
sa.Column("last_accessed", sa.DateTime(), nullable=True),
sa.ForeignKeyConstraint(
["user_id"], ["user.id"],
name=op.f("fk_appspecificauthtoken_user_id_user")),
sa.PrimaryKeyConstraint("id", name=op.f("pk_appspecificauthtoken")),
)
op.create_index("appspecificauthtoken_token_code",
"appspecificauthtoken", ["token_code"],
unique=True)
op.create_index("appspecificauthtoken_user_id",
"appspecificauthtoken", ["user_id"],
unique=False)
op.create_index(
"appspecificauthtoken_user_id_expiration",
"appspecificauthtoken",
["user_id", "expiration"],
unique=False,
)
op.create_index("appspecificauthtoken_uuid",
"appspecificauthtoken", ["uuid"],
unique=False)
# ### end Alembic commands ###
op.bulk_insert(
tables.logentrykind,
[
{
"name": "create_app_specific_token"
},
{
"name": "revoke_app_specific_token"
},
],
)
# ### population of test data ### #
tester.populate_table(
"appspecificauthtoken",
[
("user_id", tester.TestDataType.Foreign("user")),
("uuid", tester.TestDataType.UUID),
("title", tester.TestDataType.UTF8Char),
("token_code", tester.TestDataType.String),
("created", tester.TestDataType.DateTime),
("expiration", tester.TestDataType.DateTime),
("last_accessed", tester.TestDataType.DateTime),
],
)
def upgrade(tables, tester, progress_reporter):
op = ProgressWrapper(original_op, progress_reporter)
# ### commands auto generated by Alembic - please adjust! ###
op.create_index(
"repositorytag_repository_id_lifetime_end_ts",
"repositorytag",
["repository_id", "lifetime_end_ts"],
unique=False,
)
op.create_index(
"tag_repository_id_lifetime_end_ms",
"tag",
["repository_id", "lifetime_end_ms"],
unique=False,
)
op.create_index(
"repositorytag_repository_id_lifetime_start_ts",
"repositorytag",
["repository_id", "lifetime_start_ts"],
unique=False,
)
op.create_index(
"tag_repository_id_lifetime_start_ms",
"tag",
["repository_id", "lifetime_start_ms"],
unique=False,
)
def upgrade(tables, tester, progress_reporter):
op = ProgressWrapper(original_op, progress_reporter)
# ### commands auto generated by Alembic - please adjust! ###
op.create_table(
"logentry3",
sa.Column("id", sa.BigInteger(), nullable=False),
sa.Column("kind_id", sa.Integer(), nullable=False),
sa.Column("account_id", sa.Integer(), nullable=False),
sa.Column("performer_id", sa.Integer(), nullable=True),
sa.Column("repository_id", sa.Integer(), nullable=True),
sa.Column("datetime", sa.DateTime(), nullable=False),
sa.Column("ip", sa.String(length=255), nullable=True),
sa.Column("metadata_json", sa.Text(), nullable=False),
sa.PrimaryKeyConstraint("id", name=op.f("pk_logentry3")),
)
op.create_index("logentry3_account_id_datetime",
"logentry3", ["account_id", "datetime"],
unique=False)
op.create_index("logentry3_datetime",
"logentry3", ["datetime"],
unique=False)
op.create_index("logentry3_performer_id_datetime",
"logentry3", ["performer_id", "datetime"],
unique=False)
op.create_index(
"logentry3_repository_id_datetime_kind_id",
"logentry3",
["repository_id", "datetime", "kind_id"],
unique=False,
)
def upgrade(tables, tester, progress_reporter):
op = ProgressWrapper(original_op, progress_reporter)
### commands auto generated by Alembic - please adjust! ###
op.create_index('queueitem_processing_expires_available',
'queueitem', ['processing_expires', 'available'],
unique=False)
op.create_index('queueitem_pe_aafter_qname_rremaining_available',
'queueitem', [
'processing_expires', 'available_after', 'queue_name',
'retries_remaining', 'available'
],
unique=False)
op.create_index('queueitem_pexpires_aafter_rremaining_available',
'queueitem', [
'processing_expires', 'available_after',
'retries_remaining', 'available'
],
unique=False)
op.create_index('queueitem_processing_expires_queue_name_available',
'queueitem',
['processing_expires', 'queue_name', 'available'],
unique=False)
op.drop_index('queueitem_available', table_name='queueitem')
op.drop_index('queueitem_available_after', table_name='queueitem')
op.drop_index('queueitem_processing_expires', table_name='queueitem')
op.drop_index('queueitem_retries_remaining', table_name='queueitem')
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 downgrade(tables, tester, progress_reporter):
op = ProgressWrapper(original_op, progress_reporter)
# ### commands auto generated by Alembic - please adjust! ###
op.add_column(
u'oauthaccesstoken',
sa.Column('refresh_token', sa.String(length=255), nullable=True))
op.create_index('oauthaccesstoken_refresh_token',
'oauthaccesstoken', ['refresh_token'],
unique=False)
op.add_column(
'repositorybuildtrigger',
sa.Column('auth_token', sa.String(length=255), nullable=True))
op.add_column('repositorybuildtrigger',
sa.Column('private_key', sa.Text(), nullable=True))
op.add_column('oauthauthorizationcode',
sa.Column('code', sa.String(length=255), nullable=True))
op.create_index('oauthauthorizationcode_code',
'oauthauthorizationcode', ['code'],
unique=True)
op.add_column(
'oauthapplication',
sa.Column('client_secret', sa.String(length=255), nullable=True))
op.add_column(
'oauthaccesstoken',
sa.Column('access_token', sa.String(length=255), nullable=True))
op.create_index('oauthaccesstoken_access_token',
'oauthaccesstoken', ['access_token'],
unique=False)
op.add_column(
'appspecificauthtoken',
sa.Column('token_code', sa.String(length=255), nullable=True))
op.create_index('appspecificauthtoken_token_code',
'appspecificauthtoken', ['token_code'],
unique=True)
op.add_column('accesstoken',
sa.Column('code', sa.String(length=255), nullable=True))
op.create_index('accesstoken_code', 'accesstoken', ['code'], unique=True)
def downgrade(tables, tester, progress_reporter):
op = ProgressWrapper(original_op, progress_reporter)
# ### commands auto generated by Alembic - please adjust! ###
op.add_column(
u"oauthaccesstoken",
sa.Column("refresh_token", sa.String(length=255), nullable=True))
op.create_index("oauthaccesstoken_refresh_token",
"oauthaccesstoken", ["refresh_token"],
unique=False)
op.add_column(
"repositorybuildtrigger",
sa.Column("auth_token", sa.String(length=255), nullable=True))
op.add_column("repositorybuildtrigger",
sa.Column("private_key", sa.Text(), nullable=True))
op.add_column("oauthauthorizationcode",
sa.Column("code", sa.String(length=255), nullable=True))
op.create_index("oauthauthorizationcode_code",
"oauthauthorizationcode", ["code"],
unique=True)
op.add_column(
"oauthapplication",
sa.Column("client_secret", sa.String(length=255), nullable=True))
op.add_column(
"oauthaccesstoken",
sa.Column("access_token", sa.String(length=255), nullable=True))
op.create_index("oauthaccesstoken_access_token",
"oauthaccesstoken", ["access_token"],
unique=False)
op.add_column(
"appspecificauthtoken",
sa.Column("token_code", sa.String(length=255), nullable=True))
op.create_index("appspecificauthtoken_token_code",
"appspecificauthtoken", ["token_code"],
unique=True)
op.add_column("accesstoken",
sa.Column("code", sa.String(length=255), nullable=True))
op.create_index("accesstoken_code", "accesstoken", ["code"], unique=True)
def upgrade(tables, tester, progress_reporter):
op = ProgressWrapper(original_op, progress_reporter)
# ### commands auto generated by Alembic - please adjust! ###
op.create_index(
"repository_description__fulltext",
"repository",
["description"],
unique=False,
postgresql_using="gin",
postgresql_ops={"description": "gin_trgm_ops"},
mysql_prefix="FULLTEXT",
)
op.create_index(
"repository_name__fulltext",
"repository",
["name"],
unique=False,
postgresql_using="gin",
postgresql_ops={"name": "gin_trgm_ops"},
mysql_prefix="FULLTEXT",
)
def upgrade(tables, tester, progress_reporter):
op = ProgressWrapper(original_op, progress_reporter)
### commands auto generated by Alembic - please adjust! ###
op.create_table(
"teamsync",
sa.Column("id", sa.Integer(), nullable=False),
sa.Column("team_id", sa.Integer(), nullable=False),
sa.Column("transaction_id", sa.String(length=255), nullable=False),
sa.Column("last_updated", sa.DateTime(), nullable=True),
sa.Column("service_id", sa.Integer(), nullable=False),
sa.Column("config", UTF8LongText(), nullable=False),
sa.ForeignKeyConstraint(
["service_id"], ["loginservice.id"], name=op.f("fk_teamsync_service_id_loginservice")
),
sa.ForeignKeyConstraint(["team_id"], ["team.id"], name=op.f("fk_teamsync_team_id_team")),
sa.PrimaryKeyConstraint("id", name=op.f("pk_teamsync")),
)
op.create_index("teamsync_last_updated", "teamsync", ["last_updated"], unique=False)
op.create_index("teamsync_service_id", "teamsync", ["service_id"], unique=False)
op.create_index("teamsync_team_id", "teamsync", ["team_id"], unique=True)
### end Alembic commands ###
# ### population of test data ### #
tester.populate_table(
"teamsync",
[
("team_id", tester.TestDataType.Foreign("team")),
("transaction_id", tester.TestDataType.String),
("last_updated", tester.TestDataType.DateTime),
("service_id", tester.TestDataType.Foreign("loginservice")),
("config", tester.TestDataType.JSON),
],
)
def upgrade(tables, tester, progress_reporter):
op = ProgressWrapper(original_op, progress_reporter)
# ### commands auto generated by Alembic - please adjust! ###
op.create_table(
'tagtorepositorytag', sa.Column('id', sa.Integer(), nullable=False),
sa.Column('repository_id', sa.Integer(), nullable=False),
sa.Column('tag_id', sa.Integer(), nullable=False),
sa.Column('repository_tag_id', sa.Integer(), nullable=False),
sa.ForeignKeyConstraint(
['repository_id'], ['repository.id'],
name=op.f('fk_tagtorepositorytag_repository_id_repository')),
sa.ForeignKeyConstraint(
['repository_tag_id'], ['repositorytag.id'],
name=op.f(
'fk_tagtorepositorytag_repository_tag_id_repositorytag')),
sa.ForeignKeyConstraint(['tag_id'], ['tag.id'],
name=op.f('fk_tagtorepositorytag_tag_id_tag')),
sa.PrimaryKeyConstraint('id', name=op.f('pk_tagtorepositorytag')))
op.create_index('tagtorepositorytag_repository_id',
'tagtorepositorytag', ['repository_id'],
unique=False)
op.create_index('tagtorepositorytag_repository_tag_id',
'tagtorepositorytag', ['repository_tag_id'],
unique=True)
op.create_index('tagtorepositorytag_tag_id',
'tagtorepositorytag', ['tag_id'],
unique=True)
# ### end Alembic commands ###
tester.populate_table('tagtorepositorytag', [
('repository_id', tester.TestDataType.Foreign('repository')),
('tag_id', tester.TestDataType.Foreign('tag')),
('repository_tag_id', tester.TestDataType.Foreign('repositorytag')),
])
def upgrade(tables, tester, progress_reporter):
op = ProgressWrapper(original_op, progress_reporter)
# ### commands auto generated by Alembic - please adjust! ###
op.create_table(
"deletedrepository",
sa.Column("id", sa.Integer(), nullable=False),
sa.Column("repository_id", sa.Integer(), nullable=False),
sa.Column("marked", sa.DateTime(), nullable=False),
sa.Column("original_name", sa.String(length=255), nullable=False),
sa.Column("queue_id", sa.String(length=255), nullable=True),
sa.ForeignKeyConstraint(
["repository_id"],
["repository.id"],
name=op.f("fk_deletedrepository_repository_id_repository"),
),
sa.PrimaryKeyConstraint("id", name=op.f("pk_deletedrepository")),
)
op.create_index("deletedrepository_original_name",
"deletedrepository", ["original_name"],
unique=False)
op.create_index("deletedrepository_queue_id",
"deletedrepository", ["queue_id"],
unique=False)
op.create_index("deletedrepository_repository_id",
"deletedrepository", ["repository_id"],
unique=True)
def upgrade(tables, tester, progress_reporter):
op = ProgressWrapper(original_op, progress_reporter)
### commands auto generated by Alembic - please adjust! ###
op.create_table(
'teamsync', sa.Column('id', sa.Integer(), nullable=False),
sa.Column('team_id', sa.Integer(), nullable=False),
sa.Column('transaction_id', sa.String(length=255), nullable=False),
sa.Column('last_updated', sa.DateTime(), nullable=True),
sa.Column('service_id', sa.Integer(), nullable=False),
sa.Column('config', UTF8LongText(), nullable=False),
sa.ForeignKeyConstraint(
['service_id'], ['loginservice.id'],
name=op.f('fk_teamsync_service_id_loginservice')),
sa.ForeignKeyConstraint(['team_id'], ['team.id'],
name=op.f('fk_teamsync_team_id_team')),
sa.PrimaryKeyConstraint('id', name=op.f('pk_teamsync')))
op.create_index('teamsync_last_updated',
'teamsync', ['last_updated'],
unique=False)
op.create_index('teamsync_service_id',
'teamsync', ['service_id'],
unique=False)
op.create_index('teamsync_team_id', 'teamsync', ['team_id'], unique=True)
### end Alembic commands ###
# ### population of test data ### #
tester.populate_table('teamsync', [
('team_id', tester.TestDataType.Foreign('team')),
('transaction_id', tester.TestDataType.String),
('last_updated', tester.TestDataType.DateTime),
('service_id', tester.TestDataType.Foreign('loginservice')),
('config', tester.TestDataType.JSON),
])
def upgrade(tables, tester, progress_reporter):
op = ProgressWrapper(original_op, progress_reporter)
### commands auto generated by Alembic - please adjust! ###
op.create_table(
"userpromptkind",
sa.Column("id", sa.Integer(), nullable=False),
sa.Column("name", sa.String(length=255), nullable=False),
sa.PrimaryKeyConstraint("id", name=op.f("pk_userpromptkind")),
)
op.create_index("userpromptkind_name",
"userpromptkind", ["name"],
unique=False)
op.create_table(
"userprompt",
sa.Column("id", sa.Integer(), nullable=False),
sa.Column("user_id", sa.Integer(), nullable=False),
sa.Column("kind_id", sa.Integer(), nullable=False),
sa.ForeignKeyConstraint(
["kind_id"], ["userpromptkind.id"],
name=op.f("fk_userprompt_kind_id_userpromptkind")),
sa.ForeignKeyConstraint(["user_id"], ["user.id"],
name=op.f("fk_userprompt_user_id_user")),
sa.PrimaryKeyConstraint("id", name=op.f("pk_userprompt")),
)
op.create_index("userprompt_kind_id",
"userprompt", ["kind_id"],
unique=False)
op.create_index("userprompt_user_id",
"userprompt", ["user_id"],
unique=False)
op.create_index("userprompt_user_id_kind_id",
"userprompt", ["user_id", "kind_id"],
unique=True)
### end Alembic commands ###
op.bulk_insert(tables.userpromptkind, [
{
"name": "confirm_username"
},
])
# ### population of test data ### #
tester.populate_table(
"userprompt",
[
("user_id", tester.TestDataType.Foreign("user")),
("kind_id", tester.TestDataType.Foreign("userpromptkind")),
],
)
def upgrade(tables, tester, progress_reporter):
op = ProgressWrapper(original_op, progress_reporter)
# ### commands auto generated by Alembic - please adjust! ###
op.create_table(
'robotaccountmetadata', sa.Column('id', sa.Integer(), nullable=False),
sa.Column('robot_account_id', sa.Integer(), nullable=False),
sa.Column('description', UTF8CharField(length=255), nullable=False),
sa.Column('unstructured_json', sa.Text(), nullable=False),
sa.ForeignKeyConstraint(
['robot_account_id'], ['user.id'],
name=op.f('fk_robotaccountmetadata_robot_account_id_user')),
sa.PrimaryKeyConstraint('id', name=op.f('pk_robotaccountmetadata')))
op.create_index('robotaccountmetadata_robot_account_id',
'robotaccountmetadata', ['robot_account_id'],
unique=True)
# ### end Alembic commands ###
# ### population of test data ### #
tester.populate_table('robotaccountmetadata', [
('robot_account_id', tester.TestDataType.Foreign('user')),
('description', tester.TestDataType.UTF8Char),
('unstructured_json', tester.TestDataType.JSON),
])
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.create_index("permissionprototype_uuid",
"permissionprototype", ["uuid"],
unique=False)
op.create_index("repositorybuildtrigger_uuid",
"repositorybuildtrigger", ["uuid"],
unique=False)
op.create_index("user_uuid", "user", ["uuid"], unique=False)
def upgrade(tables, tester, progress_reporter):
op = ProgressWrapper(original_op, progress_reporter)
# ### commands auto generated by Alembic - please adjust! ###
op.create_table('logentry3',
sa.Column('id', sa.BigInteger(), nullable=False),
sa.Column('kind_id', sa.Integer(), nullable=False),
sa.Column('account_id', sa.Integer(), nullable=False),
sa.Column('performer_id', sa.Integer(), nullable=True),
sa.Column('repository_id', sa.Integer(), nullable=True),
sa.Column('datetime', sa.DateTime(), nullable=False),
sa.Column('ip', sa.String(length=255), nullable=True),
sa.Column('metadata_json', sa.Text(), nullable=False),
sa.PrimaryKeyConstraint('id', name=op.f('pk_logentry3'))
)
op.create_index('logentry3_account_id_datetime', 'logentry3', ['account_id', 'datetime'], unique=False)
op.create_index('logentry3_datetime', 'logentry3', ['datetime'], unique=False)
op.create_index('logentry3_performer_id_datetime', 'logentry3', ['performer_id', 'datetime'], unique=False)
op.create_index('logentry3_repository_id_datetime_kind_id', 'logentry3', ['repository_id', 'datetime', 'kind_id'], unique=False)