def upgrade(tables, tester, progress_reporter):
op = ProgressWrapper(original_op, progress_reporter)
op.bulk_insert(tables.logentrykind, [
{
"name": "change_tag_expiration"
},
])
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("successive_failure_count", sa.Integer(), server_default="0", nullable=False),
)
op.add_column(
"repositorybuildtrigger",
sa.Column(
"successive_internal_error_count", sa.Integer(), server_default="0", nullable=False
),
)
# ### end Alembic commands ###
op.bulk_insert(
tables.disablereason,
[
{"id": 2, "name": "successive_build_failures"},
{"id": 3, "name": "successive_build_internal_errors"},
],
)
# ### population of test data ### #
tester.populate_column(
"repositorybuildtrigger", "successive_failure_count", tester.TestDataType.Integer
)
tester.populate_column(
"repositorybuildtrigger", "successive_internal_error_count", tester.TestDataType.Integer
)
def upgrade(tables, tester, progress_reporter):
op = ProgressWrapper(original_op, progress_reporter)
for media_type in DOCKER_SCHEMA2_CONTENT_TYPES:
op.bulk_insert(tables.mediatype,
[
{'name': media_type},
])
def upgrade(tables, tester, progress_reporter):
op = ProgressWrapper(original_op, progress_reporter)
op.bulk_insert(tables.notificationkind, [
{
'name': 'repo_mirror_sync_started'
},
{
'name': 'repo_mirror_sync_success'
},
{
'name': 'repo_mirror_sync_failed'
},
])
op.bulk_insert(tables.externalnotificationevent, [
{
'name': 'repo_mirror_sync_started'
},
{
'name': 'repo_mirror_sync_success'
},
{
'name': 'repo_mirror_sync_failed'
},
])
def upgrade(tables, tester, progress_reporter):
op = ProgressWrapper(original_op, progress_reporter)
op.bulk_insert(tables.externalnotificationevent, [
{
"name": "build_cancelled"
},
])
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("company", UTF8CharField(length=255), nullable=True))
op.add_column(
"user",
sa.Column("family_name", UTF8CharField(length=255), nullable=True))
op.add_column(
"user",
sa.Column("given_name", UTF8CharField(length=255), nullable=True))
### end Alembic commands ###
op.bulk_insert(tables.userpromptkind, [
{
"name": "enter_name"
},
{
"name": "enter_company"
},
])
# ### population of test data ### #
tester.populate_column("user", "company", tester.TestDataType.UTF8Char)
tester.populate_column("user", "family_name", tester.TestDataType.UTF8Char)
tester.populate_column("user", "given_name", tester.TestDataType.UTF8Char)
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_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('repository', sa.Column('trust_enabled', sa.Boolean(), nullable=False, server_default=sa.sql.expression.false()))
### end Alembic commands ###
op.bulk_insert(tables.logentrykind, [
{'name': 'change_repo_trust'},
])
# ### population of test data ### #
tester.populate_column('repository', 'trust_enabled', tester.TestDataType.Boolean)
def upgrade(tables, tester, progress_reporter):
op = ProgressWrapper(original_op, progress_reporter)
op.add_column('repositorynotification', sa.Column('number_of_failures',
sa.Integer(),
nullable=False,
server_default='0'))
op.bulk_insert(tables.logentrykind, [
{'name': 'reset_repo_notification'},
])
# ### population of test data ### #
tester.populate_column('repositorynotification', 'number_of_failures', tester.TestDataType.Integer)
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)
### 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)
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_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.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.add_column(
'repositorybuildtrigger',
sa.Column('successive_failure_count',
sa.Integer(),
server_default='0',
nullable=False))
op.add_column(
'repositorybuildtrigger',
sa.Column('successive_internal_error_count',
sa.Integer(),
server_default='0',
nullable=False))
# ### end Alembic commands ###
op.bulk_insert(
tables.disablereason,
[
{
'id': 2,
'name': 'successive_build_failures'
},
{
'id': 3,
'name': 'successive_build_internal_errors'
},
],
)
# ### population of test data ### #
tester.populate_column('repositorybuildtrigger',
'successive_failure_count',
tester.TestDataType.Integer)
tester.populate_column('repositorybuildtrigger',
'successive_internal_error_count',
tester.TestDataType.Integer)
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_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)
op.create_table(
'tagkind',
sa.Column('id', sa.Integer(), nullable=False),
sa.Column('name', sa.String(length=255), nullable=False),
sa.PrimaryKeyConstraint('id', name=op.f('pk_tagkind'))
)
op.create_index('tagkind_name', 'tagkind', ['name'], unique=True)
op.create_table(
'blobplacementlocation',
sa.Column('id', sa.Integer(), nullable=False),
sa.Column('name', sa.String(length=255), nullable=False),
sa.PrimaryKeyConstraint('id', name=op.f('pk_blobplacementlocation'))
)
op.create_index('blobplacementlocation_name', 'blobplacementlocation', ['name'], unique=True)
op.create_table(
'blob',
sa.Column('id', sa.Integer(), nullable=False),
sa.Column('digest', sa.String(length=255), nullable=False),
sa.Column('media_type_id', sa.Integer(), nullable=False),
sa.Column('size', sa.BigInteger(), nullable=False),
sa.Column('uncompressed_size', sa.BigInteger(), nullable=True),
sa.ForeignKeyConstraint(['media_type_id'], ['mediatype.id'], name=op.f('fk_blob_media_type_id_mediatype')),
sa.PrimaryKeyConstraint('id', name=op.f('pk_blob'))
)
op.create_index('blob_digest', 'blob', ['digest'], unique=True)
op.create_index('blob_media_type_id', 'blob', ['media_type_id'], unique=False)
op.create_table(
'blobplacementlocationpreference',
sa.Column('id', sa.Integer(), nullable=False),
sa.Column('user_id', sa.Integer(), nullable=False),
sa.Column('location_id', sa.Integer(), nullable=False),
sa.ForeignKeyConstraint(['location_id'], ['blobplacementlocation.id'], name=op.f('fk_blobplacementlocpref_locid_blobplacementlocation')),
sa.ForeignKeyConstraint(['user_id'], ['user.id'], name=op.f('fk_blobplacementlocationpreference_user_id_user')),
sa.PrimaryKeyConstraint('id', name=op.f('pk_blobplacementlocationpreference'))
)
op.create_index('blobplacementlocationpreference_location_id', 'blobplacementlocationpreference', ['location_id'], unique=False)
op.create_index('blobplacementlocationpreference_user_id', 'blobplacementlocationpreference', ['user_id'], unique=False)
op.create_table(
'manifest',
sa.Column('id', sa.Integer(), nullable=False),
sa.Column('digest', sa.String(length=255), nullable=False),
sa.Column('media_type_id', sa.Integer(), nullable=False),
sa.Column('manifest_json', UTF8LongText, nullable=False),
sa.ForeignKeyConstraint(['media_type_id'], ['mediatype.id'], name=op.f('fk_manifest_media_type_id_mediatype')),
sa.PrimaryKeyConstraint('id', name=op.f('pk_manifest'))
)
op.create_index('manifest_digest', 'manifest', ['digest'], unique=True)
op.create_index('manifest_media_type_id', 'manifest', ['media_type_id'], unique=False)
op.create_table(
'manifestlist',
sa.Column('id', sa.Integer(), nullable=False),
sa.Column('digest', sa.String(length=255), nullable=False),
sa.Column('manifest_list_json', UTF8LongText, nullable=False),
sa.Column('schema_version', UTF8CharField(length=255), nullable=False),
sa.Column('media_type_id', sa.Integer(), nullable=False),
sa.ForeignKeyConstraint(['media_type_id'], ['mediatype.id'], name=op.f('fk_manifestlist_media_type_id_mediatype')),
sa.PrimaryKeyConstraint('id', name=op.f('pk_manifestlist'))
)
op.create_index('manifestlist_digest', 'manifestlist', ['digest'], unique=True)
op.create_index('manifestlist_media_type_id', 'manifestlist', ['media_type_id'], unique=False)
op.create_table(
'bittorrentpieces',
sa.Column('id', sa.Integer(), nullable=False),
sa.Column('blob_id', sa.Integer(), nullable=False),
sa.Column('pieces', UTF8LongText, nullable=False),
sa.Column('piece_length', sa.BigInteger(), nullable=False),
sa.ForeignKeyConstraint(['blob_id'], ['blob.id'], name=op.f('fk_bittorrentpieces_blob_id_blob')),
sa.PrimaryKeyConstraint('id', name=op.f('pk_bittorrentpieces'))
)
op.create_index('bittorrentpieces_blob_id', 'bittorrentpieces', ['blob_id'], unique=False)
op.create_index('bittorrentpieces_blob_id_piece_length', 'bittorrentpieces', ['blob_id', 'piece_length'], unique=True)
op.create_table(
'blobplacement',
sa.Column('id', sa.Integer(), nullable=False),
sa.Column('blob_id', sa.Integer(), nullable=False),
sa.Column('location_id', sa.Integer(), nullable=False),
sa.ForeignKeyConstraint(['blob_id'], ['blob.id'], name=op.f('fk_blobplacement_blob_id_blob')),
sa.ForeignKeyConstraint(['location_id'], ['blobplacementlocation.id'], name=op.f('fk_blobplacement_location_id_blobplacementlocation')),
sa.PrimaryKeyConstraint('id', name=op.f('pk_blobplacement'))
)
op.create_index('blobplacement_blob_id', 'blobplacement', ['blob_id'], unique=False)
op.create_index('blobplacement_blob_id_location_id', 'blobplacement', ['blob_id', 'location_id'], unique=True)
op.create_index('blobplacement_location_id', 'blobplacement', ['location_id'], unique=False)
op.create_table(
'blobuploading',
sa.Column('id', sa.Integer(), nullable=False),
sa.Column('uuid', sa.String(length=255), nullable=False),
sa.Column('created', sa.DateTime(), nullable=False),
sa.Column('repository_id', sa.Integer(), nullable=False),
sa.Column('location_id', sa.Integer(), nullable=False),
sa.Column('byte_count', sa.BigInteger(), nullable=False),
sa.Column('uncompressed_byte_count', sa.BigInteger(), nullable=True),
sa.Column('chunk_count', sa.BigInteger(), nullable=False),
sa.Column('storage_metadata', UTF8LongText, nullable=True),
sa.Column('sha_state', UTF8LongText, nullable=True),
sa.Column('piece_sha_state', UTF8LongText, nullable=True),
sa.Column('piece_hashes', UTF8LongText, nullable=True),
sa.ForeignKeyConstraint(['location_id'], ['blobplacementlocation.id'], name=op.f('fk_blobuploading_location_id_blobplacementlocation')),
sa.ForeignKeyConstraint(['repository_id'], ['repository.id'], name=op.f('fk_blobuploading_repository_id_repository')),
sa.PrimaryKeyConstraint('id', name=op.f('pk_blobuploading'))
)
op.create_index('blobuploading_created', 'blobuploading', ['created'], unique=False)
op.create_index('blobuploading_location_id', 'blobuploading', ['location_id'], unique=False)
op.create_index('blobuploading_repository_id', 'blobuploading', ['repository_id'], unique=False)
op.create_index('blobuploading_repository_id_uuid', 'blobuploading', ['repository_id', 'uuid'], unique=True)
op.create_index('blobuploading_uuid', 'blobuploading', ['uuid'], unique=True)
op.create_table(
'derivedimage',
sa.Column('id', sa.Integer(), nullable=False),
sa.Column('uuid', sa.String(length=255), nullable=False),
sa.Column('source_manifest_id', sa.Integer(), nullable=False),
sa.Column('derived_manifest_json', UTF8LongText, nullable=False),
sa.Column('media_type_id', sa.Integer(), nullable=False),
sa.Column('blob_id', sa.Integer(), nullable=False),
sa.Column('uniqueness_hash', sa.String(length=255), nullable=False),
sa.Column('signature_blob_id', sa.Integer(), nullable=True),
sa.ForeignKeyConstraint(['blob_id'], ['blob.id'], name=op.f('fk_derivedimage_blob_id_blob')),
sa.ForeignKeyConstraint(['media_type_id'], ['mediatype.id'], name=op.f('fk_derivedimage_media_type_id_mediatype')),
sa.ForeignKeyConstraint(['signature_blob_id'], ['blob.id'], name=op.f('fk_derivedimage_signature_blob_id_blob')),
sa.ForeignKeyConstraint(['source_manifest_id'], ['manifest.id'], name=op.f('fk_derivedimage_source_manifest_id_manifest')),
sa.PrimaryKeyConstraint('id', name=op.f('pk_derivedimage'))
)
op.create_index('derivedimage_blob_id', 'derivedimage', ['blob_id'], unique=False)
op.create_index('derivedimage_media_type_id', 'derivedimage', ['media_type_id'], unique=False)
op.create_index('derivedimage_signature_blob_id', 'derivedimage', ['signature_blob_id'], unique=False)
op.create_index('derivedimage_source_manifest_id', 'derivedimage', ['source_manifest_id'], unique=False)
op.create_index('derivedimage_source_manifest_id_blob_id', 'derivedimage', ['source_manifest_id', 'blob_id'], unique=True)
op.create_index('derivedimage_source_manifest_id_media_type_id_uniqueness_hash', 'derivedimage', ['source_manifest_id', 'media_type_id', 'uniqueness_hash'], unique=True)
op.create_index('derivedimage_uniqueness_hash', 'derivedimage', ['uniqueness_hash'], unique=True)
op.create_index('derivedimage_uuid', 'derivedimage', ['uuid'], unique=True)
op.create_table(
'manifestblob',
sa.Column('id', sa.Integer(), nullable=False),
sa.Column('manifest_id', sa.Integer(), nullable=False),
sa.Column('blob_id', sa.Integer(), nullable=False),
sa.ForeignKeyConstraint(['blob_id'], ['blob.id'], name=op.f('fk_manifestblob_blob_id_blob')),
sa.ForeignKeyConstraint(['manifest_id'], ['manifest.id'], name=op.f('fk_manifestblob_manifest_id_manifest')),
sa.PrimaryKeyConstraint('id', name=op.f('pk_manifestblob'))
)
op.create_index('manifestblob_blob_id', 'manifestblob', ['blob_id'], unique=False)
op.create_index('manifestblob_manifest_id', 'manifestblob', ['manifest_id'], unique=False)
op.create_index('manifestblob_manifest_id_blob_id', 'manifestblob', ['manifest_id', 'blob_id'], unique=True)
op.create_table(
'manifestlabel',
sa.Column('id', sa.Integer(), nullable=False),
sa.Column('repository_id', sa.Integer(), nullable=False),
sa.Column('annotated_id', sa.Integer(), nullable=False),
sa.Column('label_id', sa.Integer(), nullable=False),
sa.ForeignKeyConstraint(['annotated_id'], ['manifest.id'], name=op.f('fk_manifestlabel_annotated_id_manifest')),
sa.ForeignKeyConstraint(['label_id'], ['label.id'], name=op.f('fk_manifestlabel_label_id_label')),
sa.ForeignKeyConstraint(['repository_id'], ['repository.id'], name=op.f('fk_manifestlabel_repository_id_repository')),
sa.PrimaryKeyConstraint('id', name=op.f('pk_manifestlabel'))
)
op.create_index('manifestlabel_annotated_id', 'manifestlabel', ['annotated_id'], unique=False)
op.create_index('manifestlabel_label_id', 'manifestlabel', ['label_id'], unique=False)
op.create_index('manifestlabel_repository_id', 'manifestlabel', ['repository_id'], unique=False)
op.create_index('manifestlabel_repository_id_annotated_id_label_id', 'manifestlabel', ['repository_id', 'annotated_id', 'label_id'], unique=True)
op.create_table(
'manifestlayer',
sa.Column('id', sa.Integer(), nullable=False),
sa.Column('blob_id', sa.Integer(), nullable=False),
sa.Column('manifest_id', sa.Integer(), nullable=False),
sa.Column('manifest_index', sa.BigInteger(), nullable=False),
sa.Column('metadata_json', UTF8LongText, nullable=False),
sa.ForeignKeyConstraint(['blob_id'], ['blob.id'], name=op.f('fk_manifestlayer_blob_id_blob')),
sa.ForeignKeyConstraint(['manifest_id'], ['manifest.id'], name=op.f('fk_manifestlayer_manifest_id_manifest')),
sa.PrimaryKeyConstraint('id', name=op.f('pk_manifestlayer'))
)
op.create_index('manifestlayer_blob_id', 'manifestlayer', ['blob_id'], unique=False)
op.create_index('manifestlayer_manifest_id', 'manifestlayer', ['manifest_id'], unique=False)
op.create_index('manifestlayer_manifest_id_manifest_index', 'manifestlayer', ['manifest_id', 'manifest_index'], unique=True)
op.create_index('manifestlayer_manifest_index', 'manifestlayer', ['manifest_index'], unique=False)
op.create_table(
'manifestlistmanifest',
sa.Column('id', sa.Integer(), nullable=False),
sa.Column('manifest_list_id', sa.Integer(), nullable=False),
sa.Column('manifest_id', sa.Integer(), nullable=False),
sa.Column('operating_system', UTF8CharField(length=255), nullable=True),
sa.Column('architecture', UTF8CharField(length=255), nullable=True),
sa.Column('platform_json', UTF8LongText, nullable=True),
sa.Column('media_type_id', sa.Integer(), nullable=False),
sa.ForeignKeyConstraint(['manifest_id'], ['manifest.id'], name=op.f('fk_manifestlistmanifest_manifest_id_manifest')),
sa.ForeignKeyConstraint(['manifest_list_id'], ['manifestlist.id'], name=op.f('fk_manifestlistmanifest_manifest_list_id_manifestlist')),
sa.ForeignKeyConstraint(['media_type_id'], ['mediatype.id'], name=op.f('fk_manifestlistmanifest_media_type_id_mediatype')),
sa.PrimaryKeyConstraint('id', name=op.f('pk_manifestlistmanifest'))
)
op.create_index('manifestlistmanifest_manifest_id', 'manifestlistmanifest', ['manifest_id'], unique=False)
op.create_index('manifestlistmanifest_manifest_list_id', 'manifestlistmanifest', ['manifest_list_id'], unique=False)
op.create_index('manifestlistmanifest_manifest_listid_os_arch_mtid', 'manifestlistmanifest', ['manifest_list_id', 'operating_system', 'architecture', 'media_type_id'], unique=False)
op.create_index('manifestlistmanifest_manifest_listid_mtid', 'manifestlistmanifest', ['manifest_list_id', 'media_type_id'], unique=False)
op.create_index('manifestlistmanifest_media_type_id', 'manifestlistmanifest', ['media_type_id'], unique=False)
op.create_table(
'tag',
sa.Column('id', sa.Integer(), nullable=False),
sa.Column('name', UTF8CharField(length=190), nullable=False),
sa.Column('repository_id', sa.Integer(), nullable=False),
sa.Column('manifest_list_id', sa.Integer(), nullable=True),
sa.Column('lifetime_start', sa.BigInteger(), nullable=False),
sa.Column('lifetime_end', sa.BigInteger(), nullable=True),
sa.Column('hidden', sa.Boolean(), nullable=False),
sa.Column('reverted', sa.Boolean(), nullable=False),
sa.Column('protected', sa.Boolean(), nullable=False),
sa.Column('tag_kind_id', sa.Integer(), nullable=False),
sa.Column('linked_tag_id', sa.Integer(), nullable=True),
sa.ForeignKeyConstraint(['linked_tag_id'], ['tag.id'], name=op.f('fk_tag_linked_tag_id_tag')),
sa.ForeignKeyConstraint(['manifest_list_id'], ['manifestlist.id'], name=op.f('fk_tag_manifest_list_id_manifestlist')),
sa.ForeignKeyConstraint(['repository_id'], ['repository.id'], name=op.f('fk_tag_repository_id_repository')),
sa.ForeignKeyConstraint(['tag_kind_id'], ['tagkind.id'], name=op.f('fk_tag_tag_kind_id_tagkind')),
sa.PrimaryKeyConstraint('id', name=op.f('pk_tag'))
)
op.create_index('tag_lifetime_end', 'tag', ['lifetime_end'], unique=False)
op.create_index('tag_linked_tag_id', 'tag', ['linked_tag_id'], unique=False)
op.create_index('tag_manifest_list_id', 'tag', ['manifest_list_id'], unique=False)
op.create_index('tag_repository_id', 'tag', ['repository_id'], unique=False)
op.create_index('tag_repository_id_name_hidden', 'tag', ['repository_id', 'name', 'hidden'], unique=False)
op.create_index('tag_repository_id_name_lifetime_end', 'tag', ['repository_id', 'name', 'lifetime_end'], unique=True)
op.create_index('tag_repository_id_name', 'tag', ['repository_id', 'name'], unique=False)
op.create_index('tag_tag_kind_id', 'tag', ['tag_kind_id'], unique=False)
op.create_table(
'manifestlayerdockerv1',
sa.Column('id', sa.Integer(), nullable=False),
sa.Column('manifest_layer_id', sa.Integer(), nullable=False),
sa.Column('image_id', UTF8CharField(length=255), nullable=False),
sa.Column('checksum', UTF8CharField(length=255), nullable=False),
sa.Column('compat_json', UTF8LongText, nullable=False),
sa.ForeignKeyConstraint(['manifest_layer_id'], ['manifestlayer.id'], name=op.f('fk_manifestlayerdockerv1_manifest_layer_id_manifestlayer')),
sa.PrimaryKeyConstraint('id', name=op.f('pk_manifestlayerdockerv1'))
)
op.create_index('manifestlayerdockerv1_image_id', 'manifestlayerdockerv1', ['image_id'], unique=False)
op.create_index('manifestlayerdockerv1_manifest_layer_id', 'manifestlayerdockerv1', ['manifest_layer_id'], unique=False)
op.create_table(
'manifestlayerscan',
sa.Column('id', sa.Integer(), nullable=False),
sa.Column('layer_id', sa.Integer(), nullable=False),
sa.Column('scannable', sa.Boolean(), nullable=False),
sa.Column('scanned_by', UTF8CharField(length=255), nullable=False),
sa.ForeignKeyConstraint(['layer_id'], ['manifestlayer.id'], name=op.f('fk_manifestlayerscan_layer_id_manifestlayer')),
sa.PrimaryKeyConstraint('id', name=op.f('pk_manifestlayerscan'))
)
op.create_index('manifestlayerscan_layer_id', 'manifestlayerscan', ['layer_id'], unique=True)
blobplacementlocation_table = table('blobplacementlocation',
column('id', sa.Integer()),
column('name', sa.String()),
)
op.bulk_insert(
blobplacementlocation_table,
[
{'name': 'local_eu'},
{'name': 'local_us'},
],
)
op.bulk_insert(
tables.mediatype,
[
{'name': 'application/vnd.cnr.blob.v0.tar+gzip'},
{'name': 'application/vnd.cnr.package-manifest.helm.v0.json'},
{'name': 'application/vnd.cnr.package-manifest.kpm.v0.json'},
{'name': 'application/vnd.cnr.package-manifest.docker-compose.v0.json'},
{'name': 'application/vnd.cnr.package.kpm.v0.tar+gzip'},
{'name': 'application/vnd.cnr.package.helm.v0.tar+gzip'},
{'name': 'application/vnd.cnr.package.docker-compose.v0.tar+gzip'},
{'name': 'application/vnd.cnr.manifests.v0.json'},
{'name': 'application/vnd.cnr.manifest.list.v0.json'},
],
)
tagkind_table = table('tagkind',
column('id', sa.Integer()),
column('name', sa.String()),
)
op.bulk_insert(
tagkind_table,
[
{'id': 1, 'name': 'tag'},
{'id': 2, 'name': 'release'},
{'id': 3, 'name': 'channel'},
]
)
def upgrade(tables, tester, progress_reporter):
op = ProgressWrapper(original_op, progress_reporter)
op.bulk_insert(tables.notificationkind,
[
{'name': 'build_cancelled'},
])
def upgrade(tables, tester, progress_reporter):
op = ProgressWrapper(original_op, progress_reporter)
# ### commands auto generated by Alembic - please adjust! ###
op.create_table(
"tagkind",
sa.Column("id", sa.Integer(), nullable=False),
sa.Column("name", sa.String(length=255), nullable=False),
sa.PrimaryKeyConstraint("id", name=op.f("pk_tagkind")),
)
op.create_index("tagkind_name", "tagkind", ["name"], unique=True)
op.create_table(
"manifestchild",
sa.Column("id", sa.Integer(), nullable=False),
sa.Column("repository_id", sa.Integer(), nullable=False),
sa.Column("manifest_id", sa.Integer(), nullable=False),
sa.Column("child_manifest_id", sa.Integer(), nullable=False),
sa.ForeignKeyConstraint(
["child_manifest_id"],
["manifest.id"],
name=op.f("fk_manifestchild_child_manifest_id_manifest"),
),
sa.ForeignKeyConstraint(
["manifest_id"], ["manifest.id"],
name=op.f("fk_manifestchild_manifest_id_manifest")),
sa.ForeignKeyConstraint(
["repository_id"],
["repository.id"],
name=op.f("fk_manifestchild_repository_id_repository"),
),
sa.PrimaryKeyConstraint("id", name=op.f("pk_manifestchild")),
)
op.create_index("manifestchild_child_manifest_id",
"manifestchild", ["child_manifest_id"],
unique=False)
op.create_index("manifestchild_manifest_id",
"manifestchild", ["manifest_id"],
unique=False)
op.create_index(
"manifestchild_manifest_id_child_manifest_id",
"manifestchild",
["manifest_id", "child_manifest_id"],
unique=True,
)
op.create_index("manifestchild_repository_id",
"manifestchild", ["repository_id"],
unique=False)
op.create_index(
"manifestchild_repository_id_child_manifest_id",
"manifestchild",
["repository_id", "child_manifest_id"],
unique=False,
)
op.create_index(
"manifestchild_repository_id_manifest_id",
"manifestchild",
["repository_id", "manifest_id"],
unique=False,
)
op.create_index(
"manifestchild_repository_id_manifest_id_child_manifest_id",
"manifestchild",
["repository_id", "manifest_id", "child_manifest_id"],
unique=False,
)
op.create_table(
"tag",
sa.Column("id", sa.Integer(), nullable=False),
sa.Column("name", sa.String(length=255), nullable=False),
sa.Column("repository_id", sa.Integer(), nullable=False),
sa.Column("manifest_id", sa.Integer(), nullable=True),
sa.Column("lifetime_start_ms", sa.BigInteger(), nullable=False),
sa.Column("lifetime_end_ms", sa.BigInteger(), nullable=True),
sa.Column("hidden",
sa.Boolean(),
nullable=False,
server_default=sa.sql.expression.false()),
sa.Column("reversion",
sa.Boolean(),
nullable=False,
server_default=sa.sql.expression.false()),
sa.Column("tag_kind_id", sa.Integer(), nullable=False),
sa.Column("linked_tag_id", sa.Integer(), nullable=True),
sa.ForeignKeyConstraint(["linked_tag_id"], ["tag.id"],
name=op.f("fk_tag_linked_tag_id_tag")),
sa.ForeignKeyConstraint(["manifest_id"], ["manifest.id"],
name=op.f("fk_tag_manifest_id_manifest")),
sa.ForeignKeyConstraint(["repository_id"], ["repository.id"],
name=op.f("fk_tag_repository_id_repository")),
sa.ForeignKeyConstraint(["tag_kind_id"], ["tagkind.id"],
name=op.f("fk_tag_tag_kind_id_tagkind")),
sa.PrimaryKeyConstraint("id", name=op.f("pk_tag")),
)
op.create_index("tag_lifetime_end_ms",
"tag", ["lifetime_end_ms"],
unique=False)
op.create_index("tag_linked_tag_id",
"tag", ["linked_tag_id"],
unique=False)
op.create_index("tag_manifest_id", "tag", ["manifest_id"], unique=False)
op.create_index("tag_repository_id",
"tag", ["repository_id"],
unique=False)
op.create_index("tag_repository_id_name",
"tag", ["repository_id", "name"],
unique=False)
op.create_index("tag_repository_id_name_hidden",
"tag", ["repository_id", "name", "hidden"],
unique=False)
op.create_index(
"tag_repository_id_name_lifetime_end_ms",
"tag",
["repository_id", "name", "lifetime_end_ms"],
unique=True,
)
op.create_index(
"tag_repository_id_name_tag_kind_id",
"tag",
["repository_id", "name", "tag_kind_id"],
unique=False,
)
op.create_index("tag_tag_kind_id", "tag", ["tag_kind_id"], unique=False)
# ### end Alembic commands ###
op.bulk_insert(tables.tagkind, [
{
"name": "tag"
},
])
# ### population of test data ### #
tester.populate_table(
"tag",
[
("repository_id", tester.TestDataType.Foreign("repository")),
("tag_kind_id", tester.TestDataType.Foreign("tagkind")),
("name", tester.TestDataType.String),
("manifest_id", tester.TestDataType.Foreign("manifest")),
("lifetime_start_ms", tester.TestDataType.BigInteger),
],
)
tester.populate_table(
"manifestchild",
[
("repository_id", tester.TestDataType.Foreign("repository")),
("manifest_id", tester.TestDataType.Foreign("manifest")),
("child_manifest_id", tester.TestDataType.Foreign("manifest")),
],
)
def downgrade(tables, tester, progress_reporter):
op = ProgressWrapper(original_op, progress_reporter)
# ### commands auto generated by Alembic - please adjust! ###
op.create_table('tagkind', sa.Column('id', sa.Integer(), nullable=False),
sa.Column('name', sa.String(length=255), nullable=False),
sa.PrimaryKeyConstraint('id', name=op.f('pk_tagkind')))
op.create_index('tagkind_name', 'tagkind', ['name'], unique=True)
op.create_table(
'blobplacementlocation', sa.Column('id', sa.Integer(), nullable=False),
sa.Column('name', sa.String(length=255), nullable=False),
sa.PrimaryKeyConstraint('id', name=op.f('pk_blobplacementlocation')))
op.create_index('blobplacementlocation_name',
'blobplacementlocation', ['name'],
unique=True)
op.create_table(
'blob', sa.Column('id', sa.Integer(), nullable=False),
sa.Column('digest', sa.String(length=255), nullable=False),
sa.Column('media_type_id', sa.Integer(), nullable=False),
sa.Column('size', sa.BigInteger(), nullable=False),
sa.Column('uncompressed_size', sa.BigInteger(), nullable=True),
sa.ForeignKeyConstraint(['media_type_id'], ['mediatype.id'],
name=op.f('fk_blob_media_type_id_mediatype')),
sa.PrimaryKeyConstraint('id', name=op.f('pk_blob')))
op.create_index('blob_digest', 'blob', ['digest'], unique=True)
op.create_index('blob_media_type_id',
'blob', ['media_type_id'],
unique=False)
op.create_table(
'manifest', sa.Column('id', sa.Integer(), nullable=False),
sa.Column('digest', sa.String(length=255), nullable=False),
sa.Column('media_type_id', sa.Integer(), nullable=False),
sa.Column('manifest_json', UTF8LongText, nullable=False),
sa.ForeignKeyConstraint(
['media_type_id'], ['mediatype.id'],
name=op.f('fk_manifest_media_type_id_mediatype')),
sa.PrimaryKeyConstraint('id', name=op.f('pk_manifest')))
op.create_index('manifest_digest', 'manifest', ['digest'], unique=True)
op.create_index('manifest_media_type_id',
'manifest', ['media_type_id'],
unique=False)
op.create_table(
'manifestlist', sa.Column('id', sa.Integer(), nullable=False),
sa.Column('digest', sa.String(length=255), nullable=False),
sa.Column('manifest_list_json', UTF8LongText, nullable=False),
sa.Column('schema_version', UTF8CharField(length=255), nullable=False),
sa.Column('media_type_id', sa.Integer(), nullable=False),
sa.ForeignKeyConstraint(
['media_type_id'], ['mediatype.id'],
name=op.f('fk_manifestlist_media_type_id_mediatype')),
sa.PrimaryKeyConstraint('id', name=op.f('pk_manifestlist')))
op.create_index('manifestlist_digest',
'manifestlist', ['digest'],
unique=True)
op.create_index('manifestlist_media_type_id',
'manifestlist', ['media_type_id'],
unique=False)
op.create_table(
'blobplacement', sa.Column('id', sa.Integer(), nullable=False),
sa.Column('blob_id', sa.Integer(), nullable=False),
sa.Column('location_id', sa.Integer(), nullable=False),
sa.ForeignKeyConstraint(['blob_id'], ['blob.id'],
name=op.f('fk_blobplacement_blob_id_blob')),
sa.ForeignKeyConstraint(
['location_id'], ['blobplacementlocation.id'],
name=op.f('fk_blobplacement_location_id_blobplacementlocation')),
sa.PrimaryKeyConstraint('id', name=op.f('pk_blobplacement')))
op.create_index('blobplacement_blob_id',
'blobplacement', ['blob_id'],
unique=False)
op.create_index('blobplacement_blob_id_location_id',
'blobplacement', ['blob_id', 'location_id'],
unique=True)
op.create_index('blobplacement_location_id',
'blobplacement', ['location_id'],
unique=False)
op.create_table(
'manifestblob', sa.Column('id', sa.Integer(), nullable=False),
sa.Column('manifest_id', sa.Integer(), nullable=False),
sa.Column('blob_id', sa.Integer(), nullable=False),
sa.ForeignKeyConstraint(['blob_id'], ['blob.id'],
name=op.f('fk_manifestblob_blob_id_blob')),
sa.ForeignKeyConstraint(
['manifest_id'], ['manifest.id'],
name=op.f('fk_manifestblob_manifest_id_manifest')),
sa.PrimaryKeyConstraint('id', name=op.f('pk_manifestblob')))
op.create_index('manifestblob_blob_id',
'manifestblob', ['blob_id'],
unique=False)
op.create_index('manifestblob_manifest_id',
'manifestblob', ['manifest_id'],
unique=False)
op.create_index('manifestblob_manifest_id_blob_id',
'manifestblob', ['manifest_id', 'blob_id'],
unique=True)
op.create_table(
'manifestlistmanifest', sa.Column('id', sa.Integer(), nullable=False),
sa.Column('manifest_list_id', sa.Integer(), nullable=False),
sa.Column('manifest_id', sa.Integer(), nullable=False),
sa.Column('operating_system', UTF8CharField(length=255),
nullable=True),
sa.Column('architecture', UTF8CharField(length=255), nullable=True),
sa.Column('platform_json', UTF8LongText, nullable=True),
sa.Column('media_type_id', sa.Integer(), nullable=False),
sa.ForeignKeyConstraint(
['manifest_id'], ['manifest.id'],
name=op.f('fk_manifestlistmanifest_manifest_id_manifest')),
sa.ForeignKeyConstraint(
['manifest_list_id'], ['manifestlist.id'],
name=op.f(
'fk_manifestlistmanifest_manifest_list_id_manifestlist')),
sa.ForeignKeyConstraint(
['media_type_id'], ['mediatype.id'],
name=op.f('fk_manifestlistmanifest_media_type_id_mediatype')),
sa.PrimaryKeyConstraint('id', name=op.f('pk_manifestlistmanifest')))
op.create_index('manifestlistmanifest_manifest_id',
'manifestlistmanifest', ['manifest_id'],
unique=False)
op.create_index('manifestlistmanifest_manifest_list_id',
'manifestlistmanifest', ['manifest_list_id'],
unique=False)
op.create_index('manifestlistmanifest_manifest_listid_os_arch_mtid',
'manifestlistmanifest', [
'manifest_list_id', 'operating_system', 'architecture',
'media_type_id'
],
unique=False)
op.create_index('manifestlistmanifest_manifest_listid_mtid',
'manifestlistmanifest',
['manifest_list_id', 'media_type_id'],
unique=False)
op.create_index('manifestlistmanifest_media_type_id',
'manifestlistmanifest', ['media_type_id'],
unique=False)
op.create_table(
'tag', sa.Column('id', sa.Integer(), nullable=False),
sa.Column('name', UTF8CharField(length=190), nullable=False),
sa.Column('repository_id', sa.Integer(), nullable=False),
sa.Column('manifest_list_id', sa.Integer(), nullable=True),
sa.Column('lifetime_start', sa.BigInteger(), nullable=False),
sa.Column('lifetime_end', sa.BigInteger(), nullable=True),
sa.Column('hidden', sa.Boolean(), nullable=False),
sa.Column('reverted', sa.Boolean(), nullable=False),
sa.Column('protected', sa.Boolean(), nullable=False),
sa.Column('tag_kind_id', sa.Integer(), nullable=False),
sa.Column('linked_tag_id', sa.Integer(), nullable=True),
sa.ForeignKeyConstraint(['linked_tag_id'], ['tag.id'],
name=op.f('fk_tag_linked_tag_id_tag')),
sa.ForeignKeyConstraint(
['manifest_list_id'], ['manifestlist.id'],
name=op.f('fk_tag_manifest_list_id_manifestlist')),
sa.ForeignKeyConstraint(['repository_id'], ['repository.id'],
name=op.f('fk_tag_repository_id_repository')),
sa.ForeignKeyConstraint(['tag_kind_id'], ['tagkind.id'],
name=op.f('fk_tag_tag_kind_id_tagkind')),
sa.PrimaryKeyConstraint('id', name=op.f('pk_tag')))
op.create_index('tag_lifetime_end', 'tag', ['lifetime_end'], unique=False)
op.create_index('tag_linked_tag_id',
'tag', ['linked_tag_id'],
unique=False)
op.create_index('tag_manifest_list_id',
'tag', ['manifest_list_id'],
unique=False)
op.create_index('tag_repository_id',
'tag', ['repository_id'],
unique=False)
op.create_index('tag_repository_id_name_hidden',
'tag', ['repository_id', 'name', 'hidden'],
unique=False)
op.create_index('tag_repository_id_name_lifetime_end',
'tag', ['repository_id', 'name', 'lifetime_end'],
unique=True)
op.create_index('tag_repository_id_name',
'tag', ['repository_id', 'name'],
unique=False)
op.create_index('tag_tag_kind_id', 'tag', ['tag_kind_id'], unique=False)
# ### end Alembic commands ###
blobplacementlocation_table = table(
'blobplacementlocation',
column('id', sa.Integer()),
column('name', sa.String()),
)
op.bulk_insert(
blobplacementlocation_table,
[
{
'name': 'local_eu'
},
{
'name': 'local_us'
},
],
)
tagkind_table = table(
'tagkind',
column('id', sa.Integer()),
column('name', sa.String()),
)
op.bulk_insert(tagkind_table, [
{
'id': 1,
'name': 'tag'
},
{
'id': 2,
'name': 'release'
},
{
'id': 3,
'name': 'channel'
},
])
def upgrade(tables, tester, progress_reporter):
op = ProgressWrapper(original_op, progress_reporter)
# ### commands auto generated by Alembic - please adjust! ###
op.create_table(
"manifest",
sa.Column("id", sa.Integer(), nullable=False),
sa.Column("repository_id", sa.Integer(), nullable=False),
sa.Column("digest", sa.String(length=255), nullable=False),
sa.Column("media_type_id", sa.Integer(), nullable=False),
sa.Column("manifest_bytes", sa.Text(), nullable=False),
sa.ForeignKeyConstraint(
["media_type_id"], ["mediatype.id"],
name=op.f("fk_manifest_media_type_id_mediatype")),
sa.ForeignKeyConstraint(
["repository_id"], ["repository.id"],
name=op.f("fk_manifest_repository_id_repository")),
sa.PrimaryKeyConstraint("id", name=op.f("pk_manifest")),
)
op.create_index("manifest_digest", "manifest", ["digest"], unique=False)
op.create_index("manifest_media_type_id",
"manifest", ["media_type_id"],
unique=False)
op.create_index("manifest_repository_id",
"manifest", ["repository_id"],
unique=False)
op.create_index("manifest_repository_id_digest",
"manifest", ["repository_id", "digest"],
unique=True)
op.create_index(
"manifest_repository_id_media_type_id",
"manifest",
["repository_id", "media_type_id"],
unique=False,
)
op.create_table(
"manifestblob",
sa.Column("id", sa.Integer(), nullable=False),
sa.Column("repository_id", sa.Integer(), nullable=False),
sa.Column("manifest_id", sa.Integer(), nullable=False),
sa.Column("blob_id", sa.Integer(), nullable=False),
sa.Column("blob_index", sa.Integer(), nullable=False),
sa.ForeignKeyConstraint(
["blob_id"], ["imagestorage.id"],
name=op.f("fk_manifestblob_blob_id_imagestorage")),
sa.ForeignKeyConstraint(
["manifest_id"], ["manifest.id"],
name=op.f("fk_manifestblob_manifest_id_manifest")),
sa.ForeignKeyConstraint(
["repository_id"],
["repository.id"],
name=op.f("fk_manifestblob_repository_id_repository"),
),
sa.PrimaryKeyConstraint("id", name=op.f("pk_manifestblob")),
)
op.create_index("manifestblob_blob_id",
"manifestblob", ["blob_id"],
unique=False)
op.create_index("manifestblob_manifest_id",
"manifestblob", ["manifest_id"],
unique=False)
op.create_index("manifestblob_manifest_id_blob_id",
"manifestblob", ["manifest_id", "blob_id"],
unique=True)
op.create_index(
"manifestblob_manifest_id_blob_index",
"manifestblob",
["manifest_id", "blob_index"],
unique=True,
)
op.create_index("manifestblob_repository_id",
"manifestblob", ["repository_id"],
unique=False)
op.create_table(
"manifestlabel",
sa.Column("id", sa.Integer(), nullable=False),
sa.Column("repository_id", sa.Integer(), nullable=False),
sa.Column("manifest_id", sa.Integer(), nullable=False),
sa.Column("label_id", sa.Integer(), nullable=False),
sa.ForeignKeyConstraint(["label_id"], ["label.id"],
name=op.f("fk_manifestlabel_label_id_label")),
sa.ForeignKeyConstraint(
["manifest_id"], ["manifest.id"],
name=op.f("fk_manifestlabel_manifest_id_manifest")),
sa.ForeignKeyConstraint(
["repository_id"],
["repository.id"],
name=op.f("fk_manifestlabel_repository_id_repository"),
),
sa.PrimaryKeyConstraint("id", name=op.f("pk_manifestlabel")),
)
op.create_index("manifestlabel_label_id",
"manifestlabel", ["label_id"],
unique=False)
op.create_index("manifestlabel_manifest_id",
"manifestlabel", ["manifest_id"],
unique=False)
op.create_index(
"manifestlabel_manifest_id_label_id",
"manifestlabel",
["manifest_id", "label_id"],
unique=True,
)
op.create_index("manifestlabel_repository_id",
"manifestlabel", ["repository_id"],
unique=False)
op.create_table(
"manifestlegacyimage",
sa.Column("id", sa.Integer(), nullable=False),
sa.Column("repository_id", sa.Integer(), nullable=False),
sa.Column("manifest_id", sa.Integer(), nullable=False),
sa.Column("image_id", sa.Integer(), nullable=False),
sa.ForeignKeyConstraint(
["image_id"], ["image.id"],
name=op.f("fk_manifestlegacyimage_image_id_image")),
sa.ForeignKeyConstraint(
["manifest_id"],
["manifest.id"],
name=op.f("fk_manifestlegacyimage_manifest_id_manifest"),
),
sa.ForeignKeyConstraint(
["repository_id"],
["repository.id"],
name=op.f("fk_manifestlegacyimage_repository_id_repository"),
),
sa.PrimaryKeyConstraint("id", name=op.f("pk_manifestlegacyimage")),
)
op.create_index("manifestlegacyimage_image_id",
"manifestlegacyimage", ["image_id"],
unique=False)
op.create_index("manifestlegacyimage_manifest_id",
"manifestlegacyimage", ["manifest_id"],
unique=True)
op.create_index("manifestlegacyimage_repository_id",
"manifestlegacyimage", ["repository_id"],
unique=False)
op.create_table(
"tagmanifesttomanifest",
sa.Column("id", sa.Integer(), nullable=False),
sa.Column("tag_manifest_id", sa.Integer(), nullable=False),
sa.Column("manifest_id", sa.Integer(), nullable=False),
sa.Column("broken",
sa.Boolean(),
nullable=False,
server_default=sa.sql.expression.false()),
sa.ForeignKeyConstraint(
["manifest_id"],
["manifest.id"],
name=op.f("fk_tagmanifesttomanifest_manifest_id_manifest"),
),
sa.ForeignKeyConstraint(
["tag_manifest_id"],
["tagmanifest.id"],
name=op.f("fk_tagmanifesttomanifest_tag_manifest_id_tagmanifest"),
),
sa.PrimaryKeyConstraint("id", name=op.f("pk_tagmanifesttomanifest")),
)
op.create_index("tagmanifesttomanifest_broken",
"tagmanifesttomanifest", ["broken"],
unique=False)
op.create_index("tagmanifesttomanifest_manifest_id",
"tagmanifesttomanifest", ["manifest_id"],
unique=True)
op.create_index(
"tagmanifesttomanifest_tag_manifest_id",
"tagmanifesttomanifest",
["tag_manifest_id"],
unique=True,
)
op.create_table(
"tagmanifestlabelmap",
sa.Column("id", sa.Integer(), nullable=False),
sa.Column("tag_manifest_id", sa.Integer(), nullable=False),
sa.Column("manifest_id", sa.Integer(), nullable=True),
sa.Column("label_id", sa.Integer(), nullable=False),
sa.Column("tag_manifest_label_id", sa.Integer(), nullable=False),
sa.Column("manifest_label_id", sa.Integer(), nullable=True),
sa.Column(
"broken_manifest",
sa.Boolean(),
nullable=False,
server_default=sa.sql.expression.false(),
),
sa.ForeignKeyConstraint(
["label_id"], ["label.id"],
name=op.f("fk_tagmanifestlabelmap_label_id_label")),
sa.ForeignKeyConstraint(
["manifest_id"],
["manifest.id"],
name=op.f("fk_tagmanifestlabelmap_manifest_id_manifest"),
),
sa.ForeignKeyConstraint(
["manifest_label_id"],
["manifestlabel.id"],
name=op.f(
"fk_tagmanifestlabelmap_manifest_label_id_manifestlabel"),
),
sa.ForeignKeyConstraint(
["tag_manifest_id"],
["tagmanifest.id"],
name=op.f("fk_tagmanifestlabelmap_tag_manifest_id_tagmanifest"),
),
sa.ForeignKeyConstraint(
["tag_manifest_label_id"],
["tagmanifestlabel.id"],
name=op.
f("fk_tagmanifestlabelmap_tag_manifest_label_id_tagmanifestlabel"),
),
sa.PrimaryKeyConstraint("id", name=op.f("pk_tagmanifestlabelmap")),
)
op.create_index(
"tagmanifestlabelmap_broken_manifest",
"tagmanifestlabelmap",
["broken_manifest"],
unique=False,
)
op.create_index("tagmanifestlabelmap_label_id",
"tagmanifestlabelmap", ["label_id"],
unique=False)
op.create_index("tagmanifestlabelmap_manifest_id",
"tagmanifestlabelmap", ["manifest_id"],
unique=False)
op.create_index(
"tagmanifestlabelmap_manifest_label_id",
"tagmanifestlabelmap",
["manifest_label_id"],
unique=False,
)
op.create_index(
"tagmanifestlabelmap_tag_manifest_id",
"tagmanifestlabelmap",
["tag_manifest_id"],
unique=False,
)
op.create_index(
"tagmanifestlabelmap_tag_manifest_label_id",
"tagmanifestlabelmap",
["tag_manifest_label_id"],
unique=False,
)
# ### end Alembic commands ###
for media_type in DOCKER_SCHEMA1_CONTENT_TYPES:
op.bulk_insert(tables.mediatype, [
{
"name": media_type
},
])
# ### population of test data ### #
tester.populate_table(
"manifest",
[
("digest", tester.TestDataType.String),
("manifest_bytes", tester.TestDataType.JSON),
("media_type_id", tester.TestDataType.Foreign("mediatype")),
("repository_id", tester.TestDataType.Foreign("repository")),
],
)
tester.populate_table(
"manifestblob",
[
("manifest_id", tester.TestDataType.Foreign("manifest")),
("repository_id", tester.TestDataType.Foreign("repository")),
("blob_id", tester.TestDataType.Foreign("imagestorage")),
("blob_index", tester.TestDataType.Integer),
],
)
tester.populate_table(
"manifestlabel",
[
("manifest_id", tester.TestDataType.Foreign("manifest")),
("label_id", tester.TestDataType.Foreign("label")),
("repository_id", tester.TestDataType.Foreign("repository")),
],
)
tester.populate_table(
"manifestlegacyimage",
[
("manifest_id", tester.TestDataType.Foreign("manifest")),
("image_id", tester.TestDataType.Foreign("image")),
("repository_id", tester.TestDataType.Foreign("repository")),
],
)
tester.populate_table(
"tagmanifesttomanifest",
[
("manifest_id", tester.TestDataType.Foreign("manifest")),
("tag_manifest_id", tester.TestDataType.Foreign("tagmanifest")),
],
)
tester.populate_table(
"tagmanifestlabelmap",
[
("manifest_id", tester.TestDataType.Foreign("manifest")),
("tag_manifest_id", tester.TestDataType.Foreign("tagmanifest")),
("tag_manifest_label_id",
tester.TestDataType.Foreign("tagmanifestlabel")),
("manifest_label_id",
tester.TestDataType.Foreign("manifestlabel")),
("label_id", tester.TestDataType.Foreign("label")),
],
)
def upgrade(tables, tester, progress_reporter):
op = ProgressWrapper(original_op, progress_reporter)
op.create_table('repomirrorrule',
sa.Column('id', sa.Integer(), nullable=False),
sa.Column('uuid', sa.String(length=36), nullable=False),
sa.Column('repository_id', sa.Integer(), nullable=False),
sa.Column('creation_date', sa.DateTime(), nullable=False),
sa.Column('rule_type', sa.Integer(), nullable=False),
sa.Column('rule_value', sa.Text(), nullable=False),
sa.Column('left_child_id', sa.Integer(), nullable=True),
sa.Column('right_child_id', sa.Integer(), nullable=True),
sa.ForeignKeyConstraint(['left_child_id'], ['repomirrorrule.id'], name=op.f('fk_repomirrorrule_left_child_id_repomirrorrule')),
sa.ForeignKeyConstraint(['repository_id'], ['repository.id'], name=op.f('fk_repomirrorrule_repository_id_repository')),
sa.ForeignKeyConstraint(['right_child_id'], ['repomirrorrule.id'], name=op.f('fk_repomirrorrule_right_child_id_repomirrorrule')),
sa.PrimaryKeyConstraint('id', name=op.f('pk_repomirrorrule')))
op.create_index('repomirrorrule_left_child_id', 'repomirrorrule', ['left_child_id'], unique=False)
op.create_index('repomirrorrule_repository_id', 'repomirrorrule', ['repository_id'], unique=False)
op.create_index('repomirrorrule_right_child_id', 'repomirrorrule', ['right_child_id'], unique=False)
op.create_index('repomirrorrule_rule_type', 'repomirrorrule', ['rule_type'], unique=False)
op.create_index('repomirrorrule_uuid', 'repomirrorrule', ['uuid'], unique=True)
op.create_table('repomirrorconfig',
sa.Column('id', sa.Integer(), nullable=False),
sa.Column('repository_id', sa.Integer(), nullable=False),
sa.Column('creation_date', sa.DateTime(), nullable=False),
sa.Column('is_enabled', sa.Boolean(), nullable=False),
sa.Column('mirror_type', sa.Integer(), nullable=False),
sa.Column('internal_robot_id', sa.Integer(), nullable=False),
sa.Column('external_registry', sa.String(length=255), nullable=False),
sa.Column('external_namespace', sa.String(length=255), nullable=False),
sa.Column('external_repository', sa.String(length=255), nullable=False),
sa.Column('external_registry_username', sa.String(length=2048), nullable=True),
sa.Column('external_registry_password', sa.String(length=2048), nullable=True),
sa.Column('external_registry_config', sa.Text(), nullable=False),
sa.Column('sync_interval', sa.Integer(), nullable=False, server_default='60'),
sa.Column('sync_start_date', sa.DateTime(), nullable=True),
sa.Column('sync_expiration_date', sa.DateTime(), nullable=True),
sa.Column('sync_retries_remaining', sa.Integer(), nullable=False, server_default='3'),
sa.Column('sync_status', sa.Integer(), nullable=False),
sa.Column('sync_transaction_id', sa.String(length=36), nullable=True),
sa.Column('root_rule_id', sa.Integer(), nullable=False),
sa.ForeignKeyConstraint(['repository_id'], ['repository.id'], name=op.f('fk_repomirrorconfig_repository_id_repository')),
sa.ForeignKeyConstraint(['root_rule_id'], ['repomirrorrule.id'], name=op.f('fk_repomirrorconfig_root_rule_id_repomirrorrule')),
sa.ForeignKeyConstraint(['internal_robot_id'], ['user.id'], name=op.f('fk_repomirrorconfig_internal_robot_id_user')),
sa.PrimaryKeyConstraint('id', name=op.f('pk_repomirrorconfig'))
)
op.create_index('repomirrorconfig_mirror_type', 'repomirrorconfig', ['mirror_type'], unique=False)
op.create_index('repomirrorconfig_repository_id', 'repomirrorconfig', ['repository_id'], unique=True)
op.create_index('repomirrorconfig_root_rule_id', 'repomirrorconfig', ['root_rule_id'], unique=False)
op.create_index('repomirrorconfig_sync_status', 'repomirrorconfig', ['sync_status'], unique=False)
op.create_index('repomirrorconfig_sync_transaction_id', 'repomirrorconfig', ['sync_transaction_id'], unique=False)
op.create_index('repomirrorconfig_internal_robot_id', 'repomirrorconfig', ['internal_robot_id'], unique=False)
op.add_column(u'repository', sa.Column('state', sa.Integer(), nullable=False, server_default='0'))
op.create_index('repository_state', 'repository', ['state'], unique=False)
op.bulk_insert(tables.logentrykind,
[
{'name': 'repo_mirror_enabled'},
{'name': 'repo_mirror_disabled'},
{'name': 'repo_mirror_config_changed'},
{'name': 'repo_mirror_sync_started'},
{'name': 'repo_mirror_sync_failed'},
{'name': 'repo_mirror_sync_success'},
{'name': 'repo_mirror_sync_now_requested'},
{'name': 'repo_mirror_sync_tag_success'},
{'name': 'repo_mirror_sync_tag_failed'},
{'name': 'repo_mirror_sync_test_success'},
{'name': 'repo_mirror_sync_test_failed'},
{'name': 'repo_mirror_sync_test_started'},
{'name': 'change_repo_state'}
])
tester.populate_table('repomirrorrule', [
('uuid', tester.TestDataType.String),
('repository_id', tester.TestDataType.Foreign('repository')),
('creation_date', tester.TestDataType.DateTime),
('rule_type', tester.TestDataType.Integer),
('rule_value', tester.TestDataType.String),
])
tester.populate_table('repomirrorconfig', [
('repository_id', tester.TestDataType.Foreign('repository')),
('creation_date', tester.TestDataType.DateTime),
('is_enabled', tester.TestDataType.Boolean),
('mirror_type', tester.TestDataType.Constant(1)),
('internal_robot_id', tester.TestDataType.Foreign('user')),
('external_registry', tester.TestDataType.String),
('external_namespace', tester.TestDataType.String),
('external_repository', tester.TestDataType.String),
('external_registry_username', tester.TestDataType.String),
('external_registry_password', tester.TestDataType.String),
('external_registry_config', tester.TestDataType.JSON),
('sync_start_date', tester.TestDataType.DateTime),
('sync_expiration_date', tester.TestDataType.DateTime),
('sync_retries_remaining', tester.TestDataType.Integer),
('sync_status', tester.TestDataType.Constant(0)),
('sync_transaction_id', tester.TestDataType.String),
('root_rule_id', tester.TestDataType.Foreign('repomirrorrule')),
])
def upgrade(tables, tester, progress_reporter):
op = ProgressWrapper(original_op, progress_reporter)
# ### commands auto generated by Alembic - please adjust! ###
op.create_table('tagkind', sa.Column('id', sa.Integer(), nullable=False),
sa.Column('name', sa.String(length=255), nullable=False),
sa.PrimaryKeyConstraint('id', name=op.f('pk_tagkind')))
op.create_index('tagkind_name', 'tagkind', ['name'], unique=True)
op.create_table(
'manifestchild', sa.Column('id', sa.Integer(), nullable=False),
sa.Column('repository_id', sa.Integer(), nullable=False),
sa.Column('manifest_id', sa.Integer(), nullable=False),
sa.Column('child_manifest_id', sa.Integer(), nullable=False),
sa.ForeignKeyConstraint(
['child_manifest_id'], ['manifest.id'],
name=op.f('fk_manifestchild_child_manifest_id_manifest')),
sa.ForeignKeyConstraint(
['manifest_id'], ['manifest.id'],
name=op.f('fk_manifestchild_manifest_id_manifest')),
sa.ForeignKeyConstraint(
['repository_id'], ['repository.id'],
name=op.f('fk_manifestchild_repository_id_repository')),
sa.PrimaryKeyConstraint('id', name=op.f('pk_manifestchild')))
op.create_index('manifestchild_child_manifest_id',
'manifestchild', ['child_manifest_id'],
unique=False)
op.create_index('manifestchild_manifest_id',
'manifestchild', ['manifest_id'],
unique=False)
op.create_index('manifestchild_manifest_id_child_manifest_id',
'manifestchild', ['manifest_id', 'child_manifest_id'],
unique=True)
op.create_index('manifestchild_repository_id',
'manifestchild', ['repository_id'],
unique=False)
op.create_index('manifestchild_repository_id_child_manifest_id',
'manifestchild', ['repository_id', 'child_manifest_id'],
unique=False)
op.create_index('manifestchild_repository_id_manifest_id',
'manifestchild', ['repository_id', 'manifest_id'],
unique=False)
op.create_index(
'manifestchild_repository_id_manifest_id_child_manifest_id',
'manifestchild', ['repository_id', 'manifest_id', 'child_manifest_id'],
unique=False)
op.create_table(
'tag', sa.Column('id', sa.Integer(), nullable=False),
sa.Column('name', sa.String(length=255), nullable=False),
sa.Column('repository_id', sa.Integer(), nullable=False),
sa.Column('manifest_id', sa.Integer(), nullable=True),
sa.Column('lifetime_start_ms', sa.BigInteger(), nullable=False),
sa.Column('lifetime_end_ms', sa.BigInteger(), nullable=True),
sa.Column('hidden',
sa.Boolean(),
nullable=False,
server_default=sa.sql.expression.false()),
sa.Column('reversion',
sa.Boolean(),
nullable=False,
server_default=sa.sql.expression.false()),
sa.Column('tag_kind_id', sa.Integer(), nullable=False),
sa.Column('linked_tag_id', sa.Integer(), nullable=True),
sa.ForeignKeyConstraint(['linked_tag_id'], ['tag.id'],
name=op.f('fk_tag_linked_tag_id_tag')),
sa.ForeignKeyConstraint(['manifest_id'], ['manifest.id'],
name=op.f('fk_tag_manifest_id_manifest')),
sa.ForeignKeyConstraint(['repository_id'], ['repository.id'],
name=op.f('fk_tag_repository_id_repository')),
sa.ForeignKeyConstraint(['tag_kind_id'], ['tagkind.id'],
name=op.f('fk_tag_tag_kind_id_tagkind')),
sa.PrimaryKeyConstraint('id', name=op.f('pk_tag')))
op.create_index('tag_lifetime_end_ms',
'tag', ['lifetime_end_ms'],
unique=False)
op.create_index('tag_linked_tag_id',
'tag', ['linked_tag_id'],
unique=False)
op.create_index('tag_manifest_id', 'tag', ['manifest_id'], unique=False)
op.create_index('tag_repository_id',
'tag', ['repository_id'],
unique=False)
op.create_index('tag_repository_id_name',
'tag', ['repository_id', 'name'],
unique=False)
op.create_index('tag_repository_id_name_hidden',
'tag', ['repository_id', 'name', 'hidden'],
unique=False)
op.create_index('tag_repository_id_name_lifetime_end_ms',
'tag', ['repository_id', 'name', 'lifetime_end_ms'],
unique=True)
op.create_index('tag_repository_id_name_tag_kind_id',
'tag', ['repository_id', 'name', 'tag_kind_id'],
unique=False)
op.create_index('tag_tag_kind_id', 'tag', ['tag_kind_id'], unique=False)
# ### end Alembic commands ###
op.bulk_insert(tables.tagkind, [
{
'name': 'tag'
},
])
# ### population of test data ### #
tester.populate_table('tag', [
('repository_id', tester.TestDataType.Foreign('repository')),
('tag_kind_id', tester.TestDataType.Foreign('tagkind')),
('name', tester.TestDataType.String),
('manifest_id', tester.TestDataType.Foreign('manifest')),
('lifetime_start_ms', tester.TestDataType.BigInteger),
])
tester.populate_table('manifestchild', [
('repository_id', tester.TestDataType.Foreign('repository')),
('manifest_id', tester.TestDataType.Foreign('manifest')),
('child_manifest_id', tester.TestDataType.Foreign('manifest')),
])
def upgrade(tables, tester, progress_reporter):
op = ProgressWrapper(original_op, progress_reporter)
op.create_table(
"tagkind",
sa.Column("id", sa.Integer(), nullable=False),
sa.Column("name", sa.String(length=255), nullable=False),
sa.PrimaryKeyConstraint("id", name=op.f("pk_tagkind")),
)
op.create_index("tagkind_name", "tagkind", ["name"], unique=True)
op.create_table(
"blobplacementlocation",
sa.Column("id", sa.Integer(), nullable=False),
sa.Column("name", sa.String(length=255), nullable=False),
sa.PrimaryKeyConstraint("id", name=op.f("pk_blobplacementlocation")),
)
op.create_index("blobplacementlocation_name",
"blobplacementlocation", ["name"],
unique=True)
op.create_table(
"blob",
sa.Column("id", sa.Integer(), nullable=False),
sa.Column("digest", sa.String(length=255), nullable=False),
sa.Column("media_type_id", sa.Integer(), nullable=False),
sa.Column("size", sa.BigInteger(), nullable=False),
sa.Column("uncompressed_size", sa.BigInteger(), nullable=True),
sa.ForeignKeyConstraint(["media_type_id"], ["mediatype.id"],
name=op.f("fk_blob_media_type_id_mediatype")),
sa.PrimaryKeyConstraint("id", name=op.f("pk_blob")),
)
op.create_index("blob_digest", "blob", ["digest"], unique=True)
op.create_index("blob_media_type_id",
"blob", ["media_type_id"],
unique=False)
op.create_table(
"blobplacementlocationpreference",
sa.Column("id", sa.Integer(), nullable=False),
sa.Column("user_id", sa.Integer(), nullable=False),
sa.Column("location_id", sa.Integer(), nullable=False),
sa.ForeignKeyConstraint(
["location_id"],
["blobplacementlocation.id"],
name=op.f("fk_blobplacementlocpref_locid_blobplacementlocation"),
),
sa.ForeignKeyConstraint(
["user_id"], ["user.id"],
name=op.f("fk_blobplacementlocationpreference_user_id_user")),
sa.PrimaryKeyConstraint(
"id", name=op.f("pk_blobplacementlocationpreference")),
)
op.create_index(
"blobplacementlocationpreference_location_id",
"blobplacementlocationpreference",
["location_id"],
unique=False,
)
op.create_index(
"blobplacementlocationpreference_user_id",
"blobplacementlocationpreference",
["user_id"],
unique=False,
)
op.create_table(
"manifest",
sa.Column("id", sa.Integer(), nullable=False),
sa.Column("digest", sa.String(length=255), nullable=False),
sa.Column("media_type_id", sa.Integer(), nullable=False),
sa.Column("manifest_json", UTF8LongText, nullable=False),
sa.ForeignKeyConstraint(
["media_type_id"], ["mediatype.id"],
name=op.f("fk_manifest_media_type_id_mediatype")),
sa.PrimaryKeyConstraint("id", name=op.f("pk_manifest")),
)
op.create_index("manifest_digest", "manifest", ["digest"], unique=True)
op.create_index("manifest_media_type_id",
"manifest", ["media_type_id"],
unique=False)
op.create_table(
"manifestlist",
sa.Column("id", sa.Integer(), nullable=False),
sa.Column("digest", sa.String(length=255), nullable=False),
sa.Column("manifest_list_json", UTF8LongText, nullable=False),
sa.Column("schema_version", UTF8CharField(length=255), nullable=False),
sa.Column("media_type_id", sa.Integer(), nullable=False),
sa.ForeignKeyConstraint(
["media_type_id"],
["mediatype.id"],
name=op.f("fk_manifestlist_media_type_id_mediatype"),
),
sa.PrimaryKeyConstraint("id", name=op.f("pk_manifestlist")),
)
op.create_index("manifestlist_digest",
"manifestlist", ["digest"],
unique=True)
op.create_index("manifestlist_media_type_id",
"manifestlist", ["media_type_id"],
unique=False)
op.create_table(
"bittorrentpieces",
sa.Column("id", sa.Integer(), nullable=False),
sa.Column("blob_id", sa.Integer(), nullable=False),
sa.Column("pieces", UTF8LongText, nullable=False),
sa.Column("piece_length", sa.BigInteger(), nullable=False),
sa.ForeignKeyConstraint(["blob_id"], ["blob.id"],
name=op.f("fk_bittorrentpieces_blob_id_blob")),
sa.PrimaryKeyConstraint("id", name=op.f("pk_bittorrentpieces")),
)
op.create_index("bittorrentpieces_blob_id",
"bittorrentpieces", ["blob_id"],
unique=False)
op.create_index(
"bittorrentpieces_blob_id_piece_length",
"bittorrentpieces",
["blob_id", "piece_length"],
unique=True,
)
op.create_table(
"blobplacement",
sa.Column("id", sa.Integer(), nullable=False),
sa.Column("blob_id", sa.Integer(), nullable=False),
sa.Column("location_id", sa.Integer(), nullable=False),
sa.ForeignKeyConstraint(["blob_id"], ["blob.id"],
name=op.f("fk_blobplacement_blob_id_blob")),
sa.ForeignKeyConstraint(
["location_id"],
["blobplacementlocation.id"],
name=op.f("fk_blobplacement_location_id_blobplacementlocation"),
),
sa.PrimaryKeyConstraint("id", name=op.f("pk_blobplacement")),
)
op.create_index("blobplacement_blob_id",
"blobplacement", ["blob_id"],
unique=False)
op.create_index(
"blobplacement_blob_id_location_id",
"blobplacement",
["blob_id", "location_id"],
unique=True,
)
op.create_index("blobplacement_location_id",
"blobplacement", ["location_id"],
unique=False)
op.create_table(
"blobuploading",
sa.Column("id", sa.Integer(), nullable=False),
sa.Column("uuid", sa.String(length=255), nullable=False),
sa.Column("created", sa.DateTime(), nullable=False),
sa.Column("repository_id", sa.Integer(), nullable=False),
sa.Column("location_id", sa.Integer(), nullable=False),
sa.Column("byte_count", sa.BigInteger(), nullable=False),
sa.Column("uncompressed_byte_count", sa.BigInteger(), nullable=True),
sa.Column("chunk_count", sa.BigInteger(), nullable=False),
sa.Column("storage_metadata", UTF8LongText, nullable=True),
sa.Column("sha_state", UTF8LongText, nullable=True),
sa.Column("piece_sha_state", UTF8LongText, nullable=True),
sa.Column("piece_hashes", UTF8LongText, nullable=True),
sa.ForeignKeyConstraint(
["location_id"],
["blobplacementlocation.id"],
name=op.f("fk_blobuploading_location_id_blobplacementlocation"),
),
sa.ForeignKeyConstraint(
["repository_id"],
["repository.id"],
name=op.f("fk_blobuploading_repository_id_repository"),
),
sa.PrimaryKeyConstraint("id", name=op.f("pk_blobuploading")),
)
op.create_index("blobuploading_created",
"blobuploading", ["created"],
unique=False)
op.create_index("blobuploading_location_id",
"blobuploading", ["location_id"],
unique=False)
op.create_index("blobuploading_repository_id",
"blobuploading", ["repository_id"],
unique=False)
op.create_index("blobuploading_repository_id_uuid",
"blobuploading", ["repository_id", "uuid"],
unique=True)
op.create_index("blobuploading_uuid",
"blobuploading", ["uuid"],
unique=True)
op.create_table(
"derivedimage",
sa.Column("id", sa.Integer(), nullable=False),
sa.Column("uuid", sa.String(length=255), nullable=False),
sa.Column("source_manifest_id", sa.Integer(), nullable=False),
sa.Column("derived_manifest_json", UTF8LongText, nullable=False),
sa.Column("media_type_id", sa.Integer(), nullable=False),
sa.Column("blob_id", sa.Integer(), nullable=False),
sa.Column("uniqueness_hash", sa.String(length=255), nullable=False),
sa.Column("signature_blob_id", sa.Integer(), nullable=True),
sa.ForeignKeyConstraint(["blob_id"], ["blob.id"],
name=op.f("fk_derivedimage_blob_id_blob")),
sa.ForeignKeyConstraint(
["media_type_id"],
["mediatype.id"],
name=op.f("fk_derivedimage_media_type_id_mediatype"),
),
sa.ForeignKeyConstraint(
["signature_blob_id"], ["blob.id"],
name=op.f("fk_derivedimage_signature_blob_id_blob")),
sa.ForeignKeyConstraint(
["source_manifest_id"],
["manifest.id"],
name=op.f("fk_derivedimage_source_manifest_id_manifest"),
),
sa.PrimaryKeyConstraint("id", name=op.f("pk_derivedimage")),
)
op.create_index("derivedimage_blob_id",
"derivedimage", ["blob_id"],
unique=False)
op.create_index("derivedimage_media_type_id",
"derivedimage", ["media_type_id"],
unique=False)
op.create_index("derivedimage_signature_blob_id",
"derivedimage", ["signature_blob_id"],
unique=False)
op.create_index("derivedimage_source_manifest_id",
"derivedimage", ["source_manifest_id"],
unique=False)
op.create_index(
"derivedimage_source_manifest_id_blob_id",
"derivedimage",
["source_manifest_id", "blob_id"],
unique=True,
)
op.create_index(
"derivedimage_source_manifest_id_media_type_id_uniqueness_hash",
"derivedimage",
["source_manifest_id", "media_type_id", "uniqueness_hash"],
unique=True,
)
op.create_index("derivedimage_uniqueness_hash",
"derivedimage", ["uniqueness_hash"],
unique=True)
op.create_index("derivedimage_uuid", "derivedimage", ["uuid"], unique=True)
op.create_table(
"manifestblob",
sa.Column("id", sa.Integer(), nullable=False),
sa.Column("manifest_id", sa.Integer(), nullable=False),
sa.Column("blob_id", sa.Integer(), nullable=False),
sa.ForeignKeyConstraint(["blob_id"], ["blob.id"],
name=op.f("fk_manifestblob_blob_id_blob")),
sa.ForeignKeyConstraint(
["manifest_id"], ["manifest.id"],
name=op.f("fk_manifestblob_manifest_id_manifest")),
sa.PrimaryKeyConstraint("id", name=op.f("pk_manifestblob")),
)
op.create_index("manifestblob_blob_id",
"manifestblob", ["blob_id"],
unique=False)
op.create_index("manifestblob_manifest_id",
"manifestblob", ["manifest_id"],
unique=False)
op.create_index("manifestblob_manifest_id_blob_id",
"manifestblob", ["manifest_id", "blob_id"],
unique=True)
op.create_table(
"manifestlabel",
sa.Column("id", sa.Integer(), nullable=False),
sa.Column("repository_id", sa.Integer(), nullable=False),
sa.Column("annotated_id", sa.Integer(), nullable=False),
sa.Column("label_id", sa.Integer(), nullable=False),
sa.ForeignKeyConstraint(
["annotated_id"], ["manifest.id"],
name=op.f("fk_manifestlabel_annotated_id_manifest")),
sa.ForeignKeyConstraint(["label_id"], ["label.id"],
name=op.f("fk_manifestlabel_label_id_label")),
sa.ForeignKeyConstraint(
["repository_id"],
["repository.id"],
name=op.f("fk_manifestlabel_repository_id_repository"),
),
sa.PrimaryKeyConstraint("id", name=op.f("pk_manifestlabel")),
)
op.create_index("manifestlabel_annotated_id",
"manifestlabel", ["annotated_id"],
unique=False)
op.create_index("manifestlabel_label_id",
"manifestlabel", ["label_id"],
unique=False)
op.create_index("manifestlabel_repository_id",
"manifestlabel", ["repository_id"],
unique=False)
op.create_index(
"manifestlabel_repository_id_annotated_id_label_id",
"manifestlabel",
["repository_id", "annotated_id", "label_id"],
unique=True,
)
op.create_table(
"manifestlayer",
sa.Column("id", sa.Integer(), nullable=False),
sa.Column("blob_id", sa.Integer(), nullable=False),
sa.Column("manifest_id", sa.Integer(), nullable=False),
sa.Column("manifest_index", sa.BigInteger(), nullable=False),
sa.Column("metadata_json", UTF8LongText, nullable=False),
sa.ForeignKeyConstraint(["blob_id"], ["blob.id"],
name=op.f("fk_manifestlayer_blob_id_blob")),
sa.ForeignKeyConstraint(
["manifest_id"], ["manifest.id"],
name=op.f("fk_manifestlayer_manifest_id_manifest")),
sa.PrimaryKeyConstraint("id", name=op.f("pk_manifestlayer")),
)
op.create_index("manifestlayer_blob_id",
"manifestlayer", ["blob_id"],
unique=False)
op.create_index("manifestlayer_manifest_id",
"manifestlayer", ["manifest_id"],
unique=False)
op.create_index(
"manifestlayer_manifest_id_manifest_index",
"manifestlayer",
["manifest_id", "manifest_index"],
unique=True,
)
op.create_index("manifestlayer_manifest_index",
"manifestlayer", ["manifest_index"],
unique=False)
op.create_table(
"manifestlistmanifest",
sa.Column("id", sa.Integer(), nullable=False),
sa.Column("manifest_list_id", sa.Integer(), nullable=False),
sa.Column("manifest_id", sa.Integer(), nullable=False),
sa.Column("operating_system", UTF8CharField(length=255),
nullable=True),
sa.Column("architecture", UTF8CharField(length=255), nullable=True),
sa.Column("platform_json", UTF8LongText, nullable=True),
sa.Column("media_type_id", sa.Integer(), nullable=False),
sa.ForeignKeyConstraint(
["manifest_id"],
["manifest.id"],
name=op.f("fk_manifestlistmanifest_manifest_id_manifest"),
),
sa.ForeignKeyConstraint(
["manifest_list_id"],
["manifestlist.id"],
name=op.f("fk_manifestlistmanifest_manifest_list_id_manifestlist"),
),
sa.ForeignKeyConstraint(
["media_type_id"],
["mediatype.id"],
name=op.f("fk_manifestlistmanifest_media_type_id_mediatype"),
),
sa.PrimaryKeyConstraint("id", name=op.f("pk_manifestlistmanifest")),
)
op.create_index("manifestlistmanifest_manifest_id",
"manifestlistmanifest", ["manifest_id"],
unique=False)
op.create_index(
"manifestlistmanifest_manifest_list_id",
"manifestlistmanifest",
["manifest_list_id"],
unique=False,
)
op.create_index(
"manifestlistmanifest_manifest_listid_os_arch_mtid",
"manifestlistmanifest",
[
"manifest_list_id", "operating_system", "architecture",
"media_type_id"
],
unique=False,
)
op.create_index(
"manifestlistmanifest_manifest_listid_mtid",
"manifestlistmanifest",
["manifest_list_id", "media_type_id"],
unique=False,
)
op.create_index(
"manifestlistmanifest_media_type_id",
"manifestlistmanifest",
["media_type_id"],
unique=False,
)
op.create_table(
"tag",
sa.Column("id", sa.Integer(), nullable=False),
sa.Column("name", UTF8CharField(length=190), nullable=False),
sa.Column("repository_id", sa.Integer(), nullable=False),
sa.Column("manifest_list_id", sa.Integer(), nullable=True),
sa.Column("lifetime_start", sa.BigInteger(), nullable=False),
sa.Column("lifetime_end", sa.BigInteger(), nullable=True),
sa.Column("hidden", sa.Boolean(), nullable=False),
sa.Column("reverted", sa.Boolean(), nullable=False),
sa.Column("protected", sa.Boolean(), nullable=False),
sa.Column("tag_kind_id", sa.Integer(), nullable=False),
sa.Column("linked_tag_id", sa.Integer(), nullable=True),
sa.ForeignKeyConstraint(["linked_tag_id"], ["tag.id"],
name=op.f("fk_tag_linked_tag_id_tag")),
sa.ForeignKeyConstraint(
["manifest_list_id"],
["manifestlist.id"],
name=op.f("fk_tag_manifest_list_id_manifestlist"),
),
sa.ForeignKeyConstraint(["repository_id"], ["repository.id"],
name=op.f("fk_tag_repository_id_repository")),
sa.ForeignKeyConstraint(["tag_kind_id"], ["tagkind.id"],
name=op.f("fk_tag_tag_kind_id_tagkind")),
sa.PrimaryKeyConstraint("id", name=op.f("pk_tag")),
)
op.create_index("tag_lifetime_end", "tag", ["lifetime_end"], unique=False)
op.create_index("tag_linked_tag_id",
"tag", ["linked_tag_id"],
unique=False)
op.create_index("tag_manifest_list_id",
"tag", ["manifest_list_id"],
unique=False)
op.create_index("tag_repository_id",
"tag", ["repository_id"],
unique=False)
op.create_index("tag_repository_id_name_hidden",
"tag", ["repository_id", "name", "hidden"],
unique=False)
op.create_index(
"tag_repository_id_name_lifetime_end",
"tag",
["repository_id", "name", "lifetime_end"],
unique=True,
)
op.create_index("tag_repository_id_name",
"tag", ["repository_id", "name"],
unique=False)
op.create_index("tag_tag_kind_id", "tag", ["tag_kind_id"], unique=False)
op.create_table(
"manifestlayerdockerv1",
sa.Column("id", sa.Integer(), nullable=False),
sa.Column("manifest_layer_id", sa.Integer(), nullable=False),
sa.Column("image_id", UTF8CharField(length=255), nullable=False),
sa.Column("checksum", UTF8CharField(length=255), nullable=False),
sa.Column("compat_json", UTF8LongText, nullable=False),
sa.ForeignKeyConstraint(
["manifest_layer_id"],
["manifestlayer.id"],
name=op.f(
"fk_manifestlayerdockerv1_manifest_layer_id_manifestlayer"),
),
sa.PrimaryKeyConstraint("id", name=op.f("pk_manifestlayerdockerv1")),
)
op.create_index("manifestlayerdockerv1_image_id",
"manifestlayerdockerv1", ["image_id"],
unique=False)
op.create_index(
"manifestlayerdockerv1_manifest_layer_id",
"manifestlayerdockerv1",
["manifest_layer_id"],
unique=False,
)
op.create_table(
"manifestlayerscan",
sa.Column("id", sa.Integer(), nullable=False),
sa.Column("layer_id", sa.Integer(), nullable=False),
sa.Column("scannable", sa.Boolean(), nullable=False),
sa.Column("scanned_by", UTF8CharField(length=255), nullable=False),
sa.ForeignKeyConstraint(
["layer_id"],
["manifestlayer.id"],
name=op.f("fk_manifestlayerscan_layer_id_manifestlayer"),
),
sa.PrimaryKeyConstraint("id", name=op.f("pk_manifestlayerscan")),
)
op.create_index("manifestlayerscan_layer_id",
"manifestlayerscan", ["layer_id"],
unique=True)
blobplacementlocation_table = table(
"blobplacementlocation",
column("id", sa.Integer()),
column("name", sa.String()),
)
op.bulk_insert(
blobplacementlocation_table,
[
{
"name": "local_eu"
},
{
"name": "local_us"
},
],
)
op.bulk_insert(
tables.mediatype,
[
{
"name": "application/vnd.cnr.blob.v0.tar+gzip"
},
{
"name": "application/vnd.cnr.package-manifest.helm.v0.json"
},
{
"name": "application/vnd.cnr.package-manifest.kpm.v0.json"
},
{
"name":
"application/vnd.cnr.package-manifest.docker-compose.v0.json"
},
{
"name": "application/vnd.cnr.package.kpm.v0.tar+gzip"
},
{
"name": "application/vnd.cnr.package.helm.v0.tar+gzip"
},
{
"name":
"application/vnd.cnr.package.docker-compose.v0.tar+gzip"
},
{
"name": "application/vnd.cnr.manifests.v0.json"
},
{
"name": "application/vnd.cnr.manifest.list.v0.json"
},
],
)
tagkind_table = table(
"tagkind",
column("id", sa.Integer()),
column("name", sa.String()),
)
op.bulk_insert(
tagkind_table,
[
{
"id": 1,
"name": "tag"
},
{
"id": 2,
"name": "release"
},
{
"id": 3,
"name": "channel"
},
],
)
def upgrade(tables, tester, progress_reporter):
op = ProgressWrapper(original_op, progress_reporter)
op.create_table(
"repomirrorrule",
sa.Column("id", sa.Integer(), nullable=False),
sa.Column("uuid", sa.String(length=36), nullable=False),
sa.Column("repository_id", sa.Integer(), nullable=False),
sa.Column("creation_date", sa.DateTime(), nullable=False),
sa.Column("rule_type", sa.Integer(), nullable=False),
sa.Column("rule_value", sa.Text(), nullable=False),
sa.Column("left_child_id", sa.Integer(), nullable=True),
sa.Column("right_child_id", sa.Integer(), nullable=True),
sa.ForeignKeyConstraint(
["left_child_id"],
["repomirrorrule.id"],
name=op.f("fk_repomirrorrule_left_child_id_repomirrorrule"),
),
sa.ForeignKeyConstraint(
["repository_id"],
["repository.id"],
name=op.f("fk_repomirrorrule_repository_id_repository"),
),
sa.ForeignKeyConstraint(
["right_child_id"],
["repomirrorrule.id"],
name=op.f("fk_repomirrorrule_right_child_id_repomirrorrule"),
),
sa.PrimaryKeyConstraint("id", name=op.f("pk_repomirrorrule")),
)
op.create_index("repomirrorrule_left_child_id",
"repomirrorrule", ["left_child_id"],
unique=False)
op.create_index("repomirrorrule_repository_id",
"repomirrorrule", ["repository_id"],
unique=False)
op.create_index("repomirrorrule_right_child_id",
"repomirrorrule", ["right_child_id"],
unique=False)
op.create_index("repomirrorrule_rule_type",
"repomirrorrule", ["rule_type"],
unique=False)
op.create_index("repomirrorrule_uuid",
"repomirrorrule", ["uuid"],
unique=True)
op.create_table(
"repomirrorconfig",
sa.Column("id", sa.Integer(), nullable=False),
sa.Column("repository_id", sa.Integer(), nullable=False),
sa.Column("creation_date", sa.DateTime(), nullable=False),
sa.Column("is_enabled", sa.Boolean(), nullable=False),
sa.Column("mirror_type", sa.Integer(), nullable=False),
sa.Column("internal_robot_id", sa.Integer(), nullable=False),
sa.Column("external_registry", sa.String(length=255), nullable=False),
sa.Column("external_namespace", sa.String(length=255), nullable=False),
sa.Column("external_repository", sa.String(length=255),
nullable=False),
sa.Column("external_registry_username",
sa.String(length=2048),
nullable=True),
sa.Column("external_registry_password",
sa.String(length=2048),
nullable=True),
sa.Column("external_registry_config", sa.Text(), nullable=False),
sa.Column("sync_interval",
sa.Integer(),
nullable=False,
server_default="60"),
sa.Column("sync_start_date", sa.DateTime(), nullable=True),
sa.Column("sync_expiration_date", sa.DateTime(), nullable=True),
sa.Column("sync_retries_remaining",
sa.Integer(),
nullable=False,
server_default="3"),
sa.Column("sync_status", sa.Integer(), nullable=False),
sa.Column("sync_transaction_id", sa.String(length=36), nullable=True),
sa.Column("root_rule_id", sa.Integer(), nullable=False),
sa.ForeignKeyConstraint(
["repository_id"],
["repository.id"],
name=op.f("fk_repomirrorconfig_repository_id_repository"),
),
sa.ForeignKeyConstraint(
["root_rule_id"],
["repomirrorrule.id"],
name=op.f("fk_repomirrorconfig_root_rule_id_repomirrorrule"),
),
sa.ForeignKeyConstraint(
["internal_robot_id"],
["user.id"],
name=op.f("fk_repomirrorconfig_internal_robot_id_user"),
),
sa.PrimaryKeyConstraint("id", name=op.f("pk_repomirrorconfig")),
)
op.create_index("repomirrorconfig_mirror_type",
"repomirrorconfig", ["mirror_type"],
unique=False)
op.create_index("repomirrorconfig_repository_id",
"repomirrorconfig", ["repository_id"],
unique=True)
op.create_index("repomirrorconfig_root_rule_id",
"repomirrorconfig", ["root_rule_id"],
unique=False)
op.create_index("repomirrorconfig_sync_status",
"repomirrorconfig", ["sync_status"],
unique=False)
op.create_index(
"repomirrorconfig_sync_transaction_id",
"repomirrorconfig",
["sync_transaction_id"],
unique=False,
)
op.create_index(
"repomirrorconfig_internal_robot_id",
"repomirrorconfig",
["internal_robot_id"],
unique=False,
)
op.add_column(
u"repository",
sa.Column("state", sa.Integer(), nullable=False, server_default="0"))
op.create_index("repository_state", "repository", ["state"], unique=False)
op.bulk_insert(
tables.logentrykind,
[
{
"name": "repo_mirror_enabled"
},
{
"name": "repo_mirror_disabled"
},
{
"name": "repo_mirror_config_changed"
},
{
"name": "repo_mirror_sync_started"
},
{
"name": "repo_mirror_sync_failed"
},
{
"name": "repo_mirror_sync_success"
},
{
"name": "repo_mirror_sync_now_requested"
},
{
"name": "repo_mirror_sync_tag_success"
},
{
"name": "repo_mirror_sync_tag_failed"
},
{
"name": "repo_mirror_sync_test_success"
},
{
"name": "repo_mirror_sync_test_failed"
},
{
"name": "repo_mirror_sync_test_started"
},
{
"name": "change_repo_state"
},
],
)
tester.populate_table(
"repomirrorrule",
[
("uuid", tester.TestDataType.String),
("repository_id", tester.TestDataType.Foreign("repository")),
("creation_date", tester.TestDataType.DateTime),
("rule_type", tester.TestDataType.Integer),
("rule_value", tester.TestDataType.String),
],
)
tester.populate_table(
"repomirrorconfig",
[
("repository_id", tester.TestDataType.Foreign("repository")),
("creation_date", tester.TestDataType.DateTime),
("is_enabled", tester.TestDataType.Boolean),
("mirror_type", tester.TestDataType.Constant(1)),
("internal_robot_id", tester.TestDataType.Foreign("user")),
("external_registry", tester.TestDataType.String),
("external_namespace", tester.TestDataType.String),
("external_repository", tester.TestDataType.String),
("external_registry_username", tester.TestDataType.String),
("external_registry_password", tester.TestDataType.String),
("external_registry_config", tester.TestDataType.JSON),
("sync_start_date", tester.TestDataType.DateTime),
("sync_expiration_date", tester.TestDataType.DateTime),
("sync_retries_remaining", tester.TestDataType.Integer),
("sync_status", tester.TestDataType.Constant(0)),
("sync_transaction_id", tester.TestDataType.String),
("root_rule_id", tester.TestDataType.Foreign("repomirrorrule")),
],
)
def downgrade(tables, tester, progress_reporter):
op = ProgressWrapper(original_op, progress_reporter)
# ### commands auto generated by Alembic - please adjust! ###
op.create_table(
"tagkind",
sa.Column("id", sa.Integer(), nullable=False),
sa.Column("name", sa.String(length=255), nullable=False),
sa.PrimaryKeyConstraint("id", name=op.f("pk_tagkind")),
)
op.create_index("tagkind_name", "tagkind", ["name"], unique=True)
op.create_table(
"blobplacementlocation",
sa.Column("id", sa.Integer(), nullable=False),
sa.Column("name", sa.String(length=255), nullable=False),
sa.PrimaryKeyConstraint("id", name=op.f("pk_blobplacementlocation")),
)
op.create_index("blobplacementlocation_name",
"blobplacementlocation", ["name"],
unique=True)
op.create_table(
"blob",
sa.Column("id", sa.Integer(), nullable=False),
sa.Column("digest", sa.String(length=255), nullable=False),
sa.Column("media_type_id", sa.Integer(), nullable=False),
sa.Column("size", sa.BigInteger(), nullable=False),
sa.Column("uncompressed_size", sa.BigInteger(), nullable=True),
sa.ForeignKeyConstraint(["media_type_id"], ["mediatype.id"],
name=op.f("fk_blob_media_type_id_mediatype")),
sa.PrimaryKeyConstraint("id", name=op.f("pk_blob")),
)
op.create_index("blob_digest", "blob", ["digest"], unique=True)
op.create_index("blob_media_type_id",
"blob", ["media_type_id"],
unique=False)
op.create_table(
"manifest",
sa.Column("id", sa.Integer(), nullable=False),
sa.Column("digest", sa.String(length=255), nullable=False),
sa.Column("media_type_id", sa.Integer(), nullable=False),
sa.Column("manifest_json", UTF8LongText, nullable=False),
sa.ForeignKeyConstraint(
["media_type_id"], ["mediatype.id"],
name=op.f("fk_manifest_media_type_id_mediatype")),
sa.PrimaryKeyConstraint("id", name=op.f("pk_manifest")),
)
op.create_index("manifest_digest", "manifest", ["digest"], unique=True)
op.create_index("manifest_media_type_id",
"manifest", ["media_type_id"],
unique=False)
op.create_table(
"manifestlist",
sa.Column("id", sa.Integer(), nullable=False),
sa.Column("digest", sa.String(length=255), nullable=False),
sa.Column("manifest_list_json", UTF8LongText, nullable=False),
sa.Column("schema_version", UTF8CharField(length=255), nullable=False),
sa.Column("media_type_id", sa.Integer(), nullable=False),
sa.ForeignKeyConstraint(
["media_type_id"],
["mediatype.id"],
name=op.f("fk_manifestlist_media_type_id_mediatype"),
),
sa.PrimaryKeyConstraint("id", name=op.f("pk_manifestlist")),
)
op.create_index("manifestlist_digest",
"manifestlist", ["digest"],
unique=True)
op.create_index("manifestlist_media_type_id",
"manifestlist", ["media_type_id"],
unique=False)
op.create_table(
"blobplacement",
sa.Column("id", sa.Integer(), nullable=False),
sa.Column("blob_id", sa.Integer(), nullable=False),
sa.Column("location_id", sa.Integer(), nullable=False),
sa.ForeignKeyConstraint(["blob_id"], ["blob.id"],
name=op.f("fk_blobplacement_blob_id_blob")),
sa.ForeignKeyConstraint(
["location_id"],
["blobplacementlocation.id"],
name=op.f("fk_blobplacement_location_id_blobplacementlocation"),
),
sa.PrimaryKeyConstraint("id", name=op.f("pk_blobplacement")),
)
op.create_index("blobplacement_blob_id",
"blobplacement", ["blob_id"],
unique=False)
op.create_index(
"blobplacement_blob_id_location_id",
"blobplacement",
["blob_id", "location_id"],
unique=True,
)
op.create_index("blobplacement_location_id",
"blobplacement", ["location_id"],
unique=False)
op.create_table(
"manifestblob",
sa.Column("id", sa.Integer(), nullable=False),
sa.Column("manifest_id", sa.Integer(), nullable=False),
sa.Column("blob_id", sa.Integer(), nullable=False),
sa.ForeignKeyConstraint(["blob_id"], ["blob.id"],
name=op.f("fk_manifestblob_blob_id_blob")),
sa.ForeignKeyConstraint(
["manifest_id"], ["manifest.id"],
name=op.f("fk_manifestblob_manifest_id_manifest")),
sa.PrimaryKeyConstraint("id", name=op.f("pk_manifestblob")),
)
op.create_index("manifestblob_blob_id",
"manifestblob", ["blob_id"],
unique=False)
op.create_index("manifestblob_manifest_id",
"manifestblob", ["manifest_id"],
unique=False)
op.create_index("manifestblob_manifest_id_blob_id",
"manifestblob", ["manifest_id", "blob_id"],
unique=True)
op.create_table(
"manifestlistmanifest",
sa.Column("id", sa.Integer(), nullable=False),
sa.Column("manifest_list_id", sa.Integer(), nullable=False),
sa.Column("manifest_id", sa.Integer(), nullable=False),
sa.Column("operating_system", UTF8CharField(length=255),
nullable=True),
sa.Column("architecture", UTF8CharField(length=255), nullable=True),
sa.Column("platform_json", UTF8LongText, nullable=True),
sa.Column("media_type_id", sa.Integer(), nullable=False),
sa.ForeignKeyConstraint(
["manifest_id"],
["manifest.id"],
name=op.f("fk_manifestlistmanifest_manifest_id_manifest"),
),
sa.ForeignKeyConstraint(
["manifest_list_id"],
["manifestlist.id"],
name=op.f("fk_manifestlistmanifest_manifest_list_id_manifestlist"),
),
sa.ForeignKeyConstraint(
["media_type_id"],
["mediatype.id"],
name=op.f("fk_manifestlistmanifest_media_type_id_mediatype"),
),
sa.PrimaryKeyConstraint("id", name=op.f("pk_manifestlistmanifest")),
)
op.create_index("manifestlistmanifest_manifest_id",
"manifestlistmanifest", ["manifest_id"],
unique=False)
op.create_index(
"manifestlistmanifest_manifest_list_id",
"manifestlistmanifest",
["manifest_list_id"],
unique=False,
)
op.create_index(
"manifestlistmanifest_manifest_listid_os_arch_mtid",
"manifestlistmanifest",
[
"manifest_list_id", "operating_system", "architecture",
"media_type_id"
],
unique=False,
)
op.create_index(
"manifestlistmanifest_manifest_listid_mtid",
"manifestlistmanifest",
["manifest_list_id", "media_type_id"],
unique=False,
)
op.create_index(
"manifestlistmanifest_media_type_id",
"manifestlistmanifest",
["media_type_id"],
unique=False,
)
op.create_table(
"tag",
sa.Column("id", sa.Integer(), nullable=False),
sa.Column("name", UTF8CharField(length=190), nullable=False),
sa.Column("repository_id", sa.Integer(), nullable=False),
sa.Column("manifest_list_id", sa.Integer(), nullable=True),
sa.Column("lifetime_start", sa.BigInteger(), nullable=False),
sa.Column("lifetime_end", sa.BigInteger(), nullable=True),
sa.Column("hidden", sa.Boolean(), nullable=False),
sa.Column("reverted", sa.Boolean(), nullable=False),
sa.Column("protected", sa.Boolean(), nullable=False),
sa.Column("tag_kind_id", sa.Integer(), nullable=False),
sa.Column("linked_tag_id", sa.Integer(), nullable=True),
sa.ForeignKeyConstraint(["linked_tag_id"], ["tag.id"],
name=op.f("fk_tag_linked_tag_id_tag")),
sa.ForeignKeyConstraint(
["manifest_list_id"],
["manifestlist.id"],
name=op.f("fk_tag_manifest_list_id_manifestlist"),
),
sa.ForeignKeyConstraint(["repository_id"], ["repository.id"],
name=op.f("fk_tag_repository_id_repository")),
sa.ForeignKeyConstraint(["tag_kind_id"], ["tagkind.id"],
name=op.f("fk_tag_tag_kind_id_tagkind")),
sa.PrimaryKeyConstraint("id", name=op.f("pk_tag")),
)
op.create_index("tag_lifetime_end", "tag", ["lifetime_end"], unique=False)
op.create_index("tag_linked_tag_id",
"tag", ["linked_tag_id"],
unique=False)
op.create_index("tag_manifest_list_id",
"tag", ["manifest_list_id"],
unique=False)
op.create_index("tag_repository_id",
"tag", ["repository_id"],
unique=False)
op.create_index("tag_repository_id_name_hidden",
"tag", ["repository_id", "name", "hidden"],
unique=False)
op.create_index(
"tag_repository_id_name_lifetime_end",
"tag",
["repository_id", "name", "lifetime_end"],
unique=True,
)
op.create_index("tag_repository_id_name",
"tag", ["repository_id", "name"],
unique=False)
op.create_index("tag_tag_kind_id", "tag", ["tag_kind_id"], unique=False)
# ### end Alembic commands ###
blobplacementlocation_table = table(
"blobplacementlocation",
column("id", sa.Integer()),
column("name", sa.String()),
)
op.bulk_insert(
blobplacementlocation_table,
[
{
"name": "local_eu"
},
{
"name": "local_us"
},
],
)
tagkind_table = table(
"tagkind",
column("id", sa.Integer()),
column("name", sa.String()),
)
op.bulk_insert(
tagkind_table,
[
{
"id": 1,
"name": "tag"
},
{
"id": 2,
"name": "release"
},
{
"id": 3,
"name": "channel"
},
],
)
def upgrade(tables, tester, progress_reporter):
op = ProgressWrapper(original_op, progress_reporter)
# ### commands auto generated by Alembic - please adjust! ###
op.create_table(
'manifest', sa.Column('id', sa.Integer(), nullable=False),
sa.Column('repository_id', sa.Integer(), nullable=False),
sa.Column('digest', sa.String(length=255), nullable=False),
sa.Column('media_type_id', sa.Integer(), nullable=False),
sa.Column('manifest_bytes', sa.Text(), nullable=False),
sa.ForeignKeyConstraint(
['media_type_id'], ['mediatype.id'],
name=op.f('fk_manifest_media_type_id_mediatype')),
sa.ForeignKeyConstraint(
['repository_id'], ['repository.id'],
name=op.f('fk_manifest_repository_id_repository')),
sa.PrimaryKeyConstraint('id', name=op.f('pk_manifest')))
op.create_index('manifest_digest', 'manifest', ['digest'], unique=False)
op.create_index('manifest_media_type_id',
'manifest', ['media_type_id'],
unique=False)
op.create_index('manifest_repository_id',
'manifest', ['repository_id'],
unique=False)
op.create_index('manifest_repository_id_digest',
'manifest', ['repository_id', 'digest'],
unique=True)
op.create_index('manifest_repository_id_media_type_id',
'manifest', ['repository_id', 'media_type_id'],
unique=False)
op.create_table(
'manifestblob', sa.Column('id', sa.Integer(), nullable=False),
sa.Column('repository_id', sa.Integer(), nullable=False),
sa.Column('manifest_id', sa.Integer(), nullable=False),
sa.Column('blob_id', sa.Integer(), nullable=False),
sa.Column('blob_index', sa.Integer(), nullable=False),
sa.ForeignKeyConstraint(
['blob_id'], ['imagestorage.id'],
name=op.f('fk_manifestblob_blob_id_imagestorage')),
sa.ForeignKeyConstraint(
['manifest_id'], ['manifest.id'],
name=op.f('fk_manifestblob_manifest_id_manifest')),
sa.ForeignKeyConstraint(
['repository_id'], ['repository.id'],
name=op.f('fk_manifestblob_repository_id_repository')),
sa.PrimaryKeyConstraint('id', name=op.f('pk_manifestblob')))
op.create_index('manifestblob_blob_id',
'manifestblob', ['blob_id'],
unique=False)
op.create_index('manifestblob_manifest_id',
'manifestblob', ['manifest_id'],
unique=False)
op.create_index('manifestblob_manifest_id_blob_id',
'manifestblob', ['manifest_id', 'blob_id'],
unique=True)
op.create_index('manifestblob_manifest_id_blob_index',
'manifestblob', ['manifest_id', 'blob_index'],
unique=True)
op.create_index('manifestblob_repository_id',
'manifestblob', ['repository_id'],
unique=False)
op.create_table(
'manifestlabel', sa.Column('id', sa.Integer(), nullable=False),
sa.Column('repository_id', sa.Integer(), nullable=False),
sa.Column('manifest_id', sa.Integer(), nullable=False),
sa.Column('label_id', sa.Integer(), nullable=False),
sa.ForeignKeyConstraint(['label_id'], ['label.id'],
name=op.f('fk_manifestlabel_label_id_label')),
sa.ForeignKeyConstraint(
['manifest_id'], ['manifest.id'],
name=op.f('fk_manifestlabel_manifest_id_manifest')),
sa.ForeignKeyConstraint(
['repository_id'], ['repository.id'],
name=op.f('fk_manifestlabel_repository_id_repository')),
sa.PrimaryKeyConstraint('id', name=op.f('pk_manifestlabel')))
op.create_index('manifestlabel_label_id',
'manifestlabel', ['label_id'],
unique=False)
op.create_index('manifestlabel_manifest_id',
'manifestlabel', ['manifest_id'],
unique=False)
op.create_index('manifestlabel_manifest_id_label_id',
'manifestlabel', ['manifest_id', 'label_id'],
unique=True)
op.create_index('manifestlabel_repository_id',
'manifestlabel', ['repository_id'],
unique=False)
op.create_table(
'manifestlegacyimage', sa.Column('id', sa.Integer(), nullable=False),
sa.Column('repository_id', sa.Integer(), nullable=False),
sa.Column('manifest_id', sa.Integer(), nullable=False),
sa.Column('image_id', sa.Integer(), nullable=False),
sa.ForeignKeyConstraint(
['image_id'], ['image.id'],
name=op.f('fk_manifestlegacyimage_image_id_image')),
sa.ForeignKeyConstraint(
['manifest_id'], ['manifest.id'],
name=op.f('fk_manifestlegacyimage_manifest_id_manifest')),
sa.ForeignKeyConstraint(
['repository_id'], ['repository.id'],
name=op.f('fk_manifestlegacyimage_repository_id_repository')),
sa.PrimaryKeyConstraint('id', name=op.f('pk_manifestlegacyimage')))
op.create_index('manifestlegacyimage_image_id',
'manifestlegacyimage', ['image_id'],
unique=False)
op.create_index('manifestlegacyimage_manifest_id',
'manifestlegacyimage', ['manifest_id'],
unique=True)
op.create_index('manifestlegacyimage_repository_id',
'manifestlegacyimage', ['repository_id'],
unique=False)
op.create_table(
'tagmanifesttomanifest', sa.Column('id', sa.Integer(), nullable=False),
sa.Column('tag_manifest_id', sa.Integer(), nullable=False),
sa.Column('manifest_id', sa.Integer(), nullable=False),
sa.Column('broken',
sa.Boolean(),
nullable=False,
server_default=sa.sql.expression.false()),
sa.ForeignKeyConstraint(
['manifest_id'], ['manifest.id'],
name=op.f('fk_tagmanifesttomanifest_manifest_id_manifest')),
sa.ForeignKeyConstraint(
['tag_manifest_id'], ['tagmanifest.id'],
name=op.f('fk_tagmanifesttomanifest_tag_manifest_id_tagmanifest')),
sa.PrimaryKeyConstraint('id', name=op.f('pk_tagmanifesttomanifest')))
op.create_index('tagmanifesttomanifest_broken',
'tagmanifesttomanifest', ['broken'],
unique=False)
op.create_index('tagmanifesttomanifest_manifest_id',
'tagmanifesttomanifest', ['manifest_id'],
unique=True)
op.create_index('tagmanifesttomanifest_tag_manifest_id',
'tagmanifesttomanifest', ['tag_manifest_id'],
unique=True)
op.create_table(
'tagmanifestlabelmap', sa.Column('id', sa.Integer(), nullable=False),
sa.Column('tag_manifest_id', sa.Integer(), nullable=False),
sa.Column('manifest_id', sa.Integer(), nullable=True),
sa.Column('label_id', sa.Integer(), nullable=False),
sa.Column('tag_manifest_label_id', sa.Integer(), nullable=False),
sa.Column('manifest_label_id', sa.Integer(), nullable=True),
sa.Column('broken_manifest',
sa.Boolean(),
nullable=False,
server_default=sa.sql.expression.false()),
sa.ForeignKeyConstraint(
['label_id'], ['label.id'],
name=op.f('fk_tagmanifestlabelmap_label_id_label')),
sa.ForeignKeyConstraint(
['manifest_id'], ['manifest.id'],
name=op.f('fk_tagmanifestlabelmap_manifest_id_manifest')),
sa.ForeignKeyConstraint(
['manifest_label_id'], ['manifestlabel.id'],
name=op.f(
'fk_tagmanifestlabelmap_manifest_label_id_manifestlabel')),
sa.ForeignKeyConstraint(
['tag_manifest_id'], ['tagmanifest.id'],
name=op.f('fk_tagmanifestlabelmap_tag_manifest_id_tagmanifest')),
sa.ForeignKeyConstraint(
['tag_manifest_label_id'], ['tagmanifestlabel.id'],
name=op.f(
'fk_tagmanifestlabelmap_tag_manifest_label_id_tagmanifestlabel'
)),
sa.PrimaryKeyConstraint('id', name=op.f('pk_tagmanifestlabelmap')))
op.create_index('tagmanifestlabelmap_broken_manifest',
'tagmanifestlabelmap', ['broken_manifest'],
unique=False)
op.create_index('tagmanifestlabelmap_label_id',
'tagmanifestlabelmap', ['label_id'],
unique=False)
op.create_index('tagmanifestlabelmap_manifest_id',
'tagmanifestlabelmap', ['manifest_id'],
unique=False)
op.create_index('tagmanifestlabelmap_manifest_label_id',
'tagmanifestlabelmap', ['manifest_label_id'],
unique=False)
op.create_index('tagmanifestlabelmap_tag_manifest_id',
'tagmanifestlabelmap', ['tag_manifest_id'],
unique=False)
op.create_index('tagmanifestlabelmap_tag_manifest_label_id',
'tagmanifestlabelmap', ['tag_manifest_label_id'],
unique=False)
# ### end Alembic commands ###
for media_type in DOCKER_SCHEMA1_CONTENT_TYPES:
op.bulk_insert(tables.mediatype, [
{
'name': media_type
},
])
# ### population of test data ### #
tester.populate_table('manifest', [
('digest', tester.TestDataType.String),
('manifest_bytes', tester.TestDataType.JSON),
('media_type_id', tester.TestDataType.Foreign('mediatype')),
('repository_id', tester.TestDataType.Foreign('repository')),
])
tester.populate_table('manifestblob', [
('manifest_id', tester.TestDataType.Foreign('manifest')),
('repository_id', tester.TestDataType.Foreign('repository')),
('blob_id', tester.TestDataType.Foreign('imagestorage')),
('blob_index', tester.TestDataType.Integer),
])
tester.populate_table('manifestlabel', [
('manifest_id', tester.TestDataType.Foreign('manifest')),
('label_id', tester.TestDataType.Foreign('label')),
('repository_id', tester.TestDataType.Foreign('repository')),
])
tester.populate_table('manifestlegacyimage', [
('manifest_id', tester.TestDataType.Foreign('manifest')),
('image_id', tester.TestDataType.Foreign('image')),
('repository_id', tester.TestDataType.Foreign('repository')),
])
tester.populate_table('tagmanifesttomanifest', [
('manifest_id', tester.TestDataType.Foreign('manifest')),
('tag_manifest_id', tester.TestDataType.Foreign('tagmanifest')),
])
tester.populate_table('tagmanifestlabelmap', [
('manifest_id', tester.TestDataType.Foreign('manifest')),
('tag_manifest_id', tester.TestDataType.Foreign('tagmanifest')),
('tag_manifest_label_id',
tester.TestDataType.Foreign('tagmanifestlabel')),
('manifest_label_id', tester.TestDataType.Foreign('manifestlabel')),
('label_id', tester.TestDataType.Foreign('label')),
])
