gabriel / musehub public
0025_server_defaults_booleans_and_enums.py python
81 lines 2.9 KB
Raw
sha256:fc04e4cae9e1774d6a21b65c45daeed0e6787eb581d13aa1b03bfe9384a34226 Merge branch 'fix/two-column-scroll-layout' into dev Human 9 days ago
1 """Add server_default to boolean and string-enum columns.
2
3 Every non-nullable column with a Python-side default should also have a
4 server_default so that raw SQL inserts (migrations, scripts, bulk loads)
5 produce a valid row without having to specify the value explicitly.
6
7 This migration covers two categories:
8 - Booleans: SET DEFAULT false / true
9 - String enums / sentinel strings: SET DEFAULT 'value'
10
11 Revision ID: 0025
12 Revises: 0024
13 """
14 from __future__ import annotations
15
16 from alembic import op
17 import sqlalchemy as sa
18
19 revision = "0025"
20 down_revision = "0024"
21 branch_labels = None
22 depends_on = None
23
24 # (table, column, default_value)
25 _BOOL_FALSE: list[tuple[str, str]] = [
26 ("musehub_repos", "training_opt_out"),
27 ("musehub_identities", "is_verified"),
28 ("musehub_issue_comments", "is_deleted"),
29 ("musehub_releases", "is_draft"),
30 ("musehub_webhook_deliveries", "success"),
31 ("musehub_sessions", "is_active"),
32 ("musehub_intel_entangle", "structurally_linked"),
33 ("musehub_intel_stable", "since_start"),
34 ("musehub_intel_type", "return_is_any"),
35 ("musehub_bridge_mirrors", "auto_export"),
36 ("musehub_profile_snapshots", "is_stale"),
37 ("musehub_domains", "is_verified"),
38 ("musehub_domains", "is_deprecated"),
39 ]
40
41 _BOOL_TRUE: list[tuple[str, str]] = [
42 ("musehub_webhooks", "active"),
43 ]
44
45 _STR_DEFAULTS: list[tuple[str, str, str]] = [
46 ("musehub_repos", "visibility", "public"),
47 ("musehub_identities", "identity_type", "human"),
48 ("musehub_issues", "state", "open"),
49 ("musehub_proposals", "state", "open"),
50 ("musehub_proposal_reviews", "state", "pending"),
51 ("musehub_releases", "channel", "stable"),
52 ("musehub_sessions", "schema_version", "1"),
53 ("musehub_background_jobs", "status", "pending"),
54 ("musehub_intel_api_surface", "visibility", "public"),
55 ("musehub_mists", "visibility", "public"),
56 ("musehub_intel_breakage_issues", "severity", "warning"),
57 ("musehub_bridge_mirrors", "git_branch", "muse-mirror"),
58 ("musehub_collaborators", "permission", "write"),
59 ("musehub_coord_tasks", "queue", "default"),
60 ("musehub_coord_tasks", "status", "pending"),
61 ("musehub_domains", "version", "1.0.0"),
62 ("musehub_domains", "viewer_type", "generic"),
63 ]
64
65
66 def upgrade() -> None:
67 conn = op.get_bind()
68 for table, col in _BOOL_FALSE:
69 conn.execute(sa.text(f"ALTER TABLE {table} ALTER COLUMN {col} SET DEFAULT false"))
70 for table, col in _BOOL_TRUE:
71 conn.execute(sa.text(f"ALTER TABLE {table} ALTER COLUMN {col} SET DEFAULT true"))
72 for table, col, val in _STR_DEFAULTS:
73 conn.execute(sa.text(f"ALTER TABLE {table} ALTER COLUMN {col} SET DEFAULT '{val}'"))
74
75
76 def downgrade() -> None:
77 conn = op.get_bind()
78 for table, col in _BOOL_FALSE + _BOOL_TRUE:
79 conn.execute(sa.text(f"ALTER TABLE {table} ALTER COLUMN {col} DROP DEFAULT"))
80 for table, col, _ in _STR_DEFAULTS:
81 conn.execute(sa.text(f"ALTER TABLE {table} ALTER COLUMN {col} DROP DEFAULT"))
File History 13 commits
sha256:fc04e4cae9e1774d6a21b65c45daeed0e6787eb581d13aa1b03bfe9384a34226 Merge branch 'fix/two-column-scroll-layout' into dev Human 9 days ago
sha256:408916fc5973ba59c6e4eebaa80ebdcc801c0a63205651e25009d11548f79454 chore: bump version to 0.2.0.dev2 — nightly.2, matching muse Sonnet 4.6 patch 11 days ago
sha256:d035733f21ccff27735fddebfbbe0ed24565a32a22db8de5885402262671ecd2 chore: bump version to 0.2.0rc15 for musehub#113 fix release Sonnet 4.6 patch 15 days ago
sha256:0032d6cfa33bc3c8367436ad768e7dd0e339b4332153160247da8266cb5fa352 Merge branch 'task/version-tags-phase3-server' into dev Human 17 days ago
sha256:4669620efda9ff41c55bdefd1f7bfe1c239d468428744c84ead9957e5a003a53 merge: rescue snapshot-recovery hardening (c00aa21d) into d… Opus 4.8 minor ⚠ 30 days ago
sha256:a59da49c4611b970fc4b6ae48678ce4943261c213a07ddbd73ce9201df869b4a fix: remove false-positive proposal_comments index drop fro… Sonnet 4.6 patch 34 days ago
sha256:0a240d6dbff234f07d98a28a4a9a68db702f3f9ff9260196f24219bdb1c0b6f3 feat: render markdown mists as HTML with heading anchor links Sonnet 4.6 patch 34 days ago
sha256:24a7d47486ebc4ebd1832830580e177ec6f877b48dced8c000e198cdec4ce9d6 Merge 'task/bump-version-rc12' into 'dev' — proposal: Bump … Human 35 days ago
sha256:b9ff931d147e0114a1f17060f415b89ed551c170a91ff226c70437aa5c85f9ee Merge 'task/bump-version-rc12' into 'dev' — proposal: Bump … Human 35 days ago
sha256:d1122d21e73471879b460037b22c0b50fded7c423444a176f248428f75dac39c Merge 'task/fix-issue-pagination-cursor' into 'dev' — propo… Human 35 days ago
sha256:01e18975e73d2b3cd5b6db7929c895bef9aa6e0d4391dc5b2adfc548b41318dd Merge 'feat/adding-debug-logs-to-staging' into 'dev' — prop… Human 36 days ago
sha256:6b1949fc2797ca4c1936a637a4cbfec828ef56cf52398a2e74ca3c4f494e728f fix: use wire_bytes not mpack_bytes_raw in compute_object_b… Sonnet 4.6 patch 48 days ago
sha256:b99f2455dc346966d040133f5203297e6e3ef5803a93728a2c30568d0a0f7583 rename: delta_add → delta_upsert across wire format, models… Sonnet 4.6 patch 50 days ago