gabriel / musehub public
0053_snapshot_manifest_blob_nullable.py python
40 lines 921 B
Raw
sha256:c2e5cf2d754ed2fe9a94e879d41ad12ff221d2ac4ac7b45247fcb981c76858bf docs: Section 8 database/migrations/backups — verified live… Sonnet 5 24 days ago
1 """Make musehub_snapshots.manifest_blob nullable.
2
3 snapshot_id = sha256(sorted manifest entries) — the ID is the proof.
4 Snapshots pushed via the delta-mpack path store manifest_blob=NULL;
5 the manifest can be reconstructed from the delta chain in MinIO.
6
7 Revision ID: 0053
8 Revises: 0052
9 """
10 from __future__ import annotations
11
12 import sqlalchemy as sa
13 from alembic import op
14
15
16 revision: str = "0053"
17 down_revision: str = "0052"
18 branch_labels = None
19 depends_on = None
20
21
22 def upgrade() -> None:
23 op.alter_column(
24 "musehub_snapshots",
25 "manifest_blob",
26 existing_type=sa.LargeBinary(),
27 nullable=True,
28 )
29
30
31 def downgrade() -> None:
32 op.execute(
33 "UPDATE musehub_snapshots SET manifest_blob = '\\x80' WHERE manifest_blob IS NULL"
34 )
35 op.alter_column(
36 "musehub_snapshots",
37 "manifest_blob",
38 existing_type=sa.LargeBinary(),
39 nullable=False,
40 )
File History 2 commits
sha256:c2e5cf2d754ed2fe9a94e879d41ad12ff221d2ac4ac7b45247fcb981c76858bf docs: Section 8 database/migrations/backups — verified live… Sonnet 5 24 days ago
sha256:80e1a60a39562f6e616aaafbb27487f03abbec7d8ffc6164302b7a0c0bfc63ee docs: check off Section 0 items verified in inventory doc, … Sonnet 5 24 days ago