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(
"robotaccountmetadata",
sa.Column("id", sa.Integer(), nullable=False),
sa.Column("robot_account_id", sa.Integer(), nullable=False),
sa.Column("description", UTF8CharField(length=255), nullable=False),
sa.Column("unstructured_json", sa.Text(), nullable=False),
sa.ForeignKeyConstraint(
["robot_account_id"],
["user.id"],
name=op.f("fk_robotaccountmetadata_robot_account_id_user"),
),
sa.PrimaryKeyConstraint("id", name=op.f("pk_robotaccountmetadata")),
)
op.create_index(
"robotaccountmetadata_robot_account_id",
"robotaccountmetadata",
["robot_account_id"],
unique=True,
)
# ### end Alembic commands ###
# ### population of test data ### #
tester.populate_table(
"robotaccountmetadata",
[
("robot_account_id", tester.TestDataType.Foreign("user")),
("description", tester.TestDataType.UTF8Char),
("unstructured_json", tester.TestDataType.JSON),
],
)
def upgrade(tables, tester, progress_reporter):
op = ProgressWrapper(original_op, progress_reporter)
# ### commands auto generated by Alembic - please adjust! ###
op.create_table(
"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(op, tables, tester):
op.add_column(
"user", sa.Column("location", UTF8CharField(length=255),
nullable=True))
# ### population of test data ### #
tester.populate_column("user", "location", tester.TestDataType.UTF8Char)
def upgrade(tables, tester, progress_reporter):
op = ProgressWrapper(original_op, progress_reporter)
op.add_column(
"user", sa.Column("location", UTF8CharField(length=255),
nullable=True))
# ### population of test data ### #
tester.populate_column("user", "location", 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(
'robotaccountmetadata', sa.Column('id', sa.Integer(), nullable=False),
sa.Column('robot_account_id', sa.Integer(), nullable=False),
sa.Column('description', UTF8CharField(length=255), nullable=False),
sa.Column('unstructured_json', sa.Text(), nullable=False),
sa.ForeignKeyConstraint(
['robot_account_id'], ['user.id'],
name=op.f('fk_robotaccountmetadata_robot_account_id_user')),
sa.PrimaryKeyConstraint('id', name=op.f('pk_robotaccountmetadata')))
op.create_index('robotaccountmetadata_robot_account_id',
'robotaccountmetadata', ['robot_account_id'],
unique=True)
# ### end Alembic commands ###
# ### population of test data ### #
tester.populate_table('robotaccountmetadata', [
('robot_account_id', tester.TestDataType.Foreign('user')),
('description', tester.TestDataType.UTF8Char),
('unstructured_json', tester.TestDataType.JSON),
])
def upgrade(tables, tester, progress_reporter):
op = ProgressWrapper(original_op, progress_reporter)
# ### commands auto generated by Alembic - please adjust! ###
op.create_table('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(op, tables, tester):
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 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 downgrade(tables, tester, progress_reporter):
op = ProgressWrapper(original_op, progress_reporter)
# ### commands auto generated by Alembic - please adjust! ###
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_manifest_index",
"manifestlayer", ["manifest_index"],
unique=False)
op.create_index(
"manifestlayer_manifest_id_manifest_index",
"manifestlayer",
["manifest_id", "manifest_index"],
unique=True,
)
op.create_index("manifestlayer_manifest_id",
"manifestlayer", ["manifest_id"],
unique=False)
op.create_index("manifestlayer_blob_id",
"manifestlayer", ["blob_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)
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_piece_length",
"bittorrentpieces",
["blob_id", "piece_length"],
unique=True,
)
op.create_index("bittorrentpieces_blob_id",
"bittorrentpieces", ["blob_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_uuid",
"blobuploading", ["uuid"],
unique=True)
op.create_index("blobuploading_repository_id_uuid",
"blobuploading", ["repository_id", "uuid"],
unique=True)
op.create_index("blobuploading_repository_id",
"blobuploading", ["repository_id"],
unique=False)
op.create_index("blobuploading_location_id",
"blobuploading", ["location_id"],
unique=False)
op.create_index("blobuploading_created",
"blobuploading", ["created"],
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_manifest_layer_id",
"manifestlayerdockerv1",
["manifest_layer_id"],
unique=False,
)
op.create_index("manifestlayerdockerv1_image_id",
"manifestlayerdockerv1", ["image_id"],
unique=False)
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_repository_id_annotated_id_label_id",
"manifestlabel",
["repository_id", "annotated_id", "label_id"],
unique=True,
)
op.create_index("manifestlabel_repository_id",
"manifestlabel", ["repository_id"],
unique=False)
op.create_index("manifestlabel_label_id",
"manifestlabel", ["label_id"],
unique=False)
op.create_index("manifestlabel_annotated_id",
"manifestlabel", ["annotated_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_user_id",
"blobplacementlocationpreference",
["user_id"],
unique=False,
)
op.create_index(
"blobplacementlocationpreference_location_id",
"blobplacementlocationpreference",
["location_id"],
unique=False,
)
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_uuid", "derivedimage", ["uuid"], unique=True)
op.create_index("derivedimage_uniqueness_hash",
"derivedimage", ["uniqueness_hash"],
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_source_manifest_id_blob_id",
"derivedimage",
["source_manifest_id", "blob_id"],
unique=True,
)
op.create_index("derivedimage_source_manifest_id",
"derivedimage", ["source_manifest_id"],
unique=False)
op.create_index("derivedimage_signature_blob_id",
"derivedimage", ["signature_blob_id"],
unique=False)
op.create_index("derivedimage_media_type_id",
"derivedimage", ["media_type_id"],
unique=False)
op.create_index("derivedimage_blob_id",
"derivedimage", ["blob_id"],
unique=False)
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)
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'},
]
)
