gabriel / musehub public
muse_cli_models.py python
69 lines 2.5 KB
Raw
sha256:73f24973678ceefd56628ee17c6d0535d86e33533828af6c63348f50941515ad Merge branch 'fix/smoke-test-tag-label' into dev Human 16 days ago
1 """SQLAlchemy ORM models for the Muse CLI commit tables.
2
3 MuseHub reads from muse_commits / muse_snapshots to display repository history.
4 """
5
6 from datetime import datetime, timezone
7
8 from sqlalchemy import DateTime, ForeignKey, String, Text
9 from sqlalchemy.orm import Mapped, mapped_column
10 from sqlalchemy.dialects.postgresql import JSONB
11
12 from musehub.db.database import Base
13 from musehub.types.json_types import JSONObject, JSONValue # JSONValue needed for ForwardRef resolution in Mapped[]
14
15 def _utc_now() -> datetime:
16 return datetime.now(timezone.utc)
17
18 class MuseCliSnapshot(Base):
19 """An immutable snapshot manifest: sha256(sorted(path:object_id pairs))."""
20
21 __tablename__ = "muse_snapshots"
22
23 snapshot_id: Mapped[str] = mapped_column(String(128), primary_key=True)
24 manifest: Mapped[dict[str, str]] = mapped_column(JSONB, nullable=False)
25 created_at: Mapped[datetime] = mapped_column(
26 DateTime(timezone=True), nullable=False, default=_utc_now
27 )
28
29 def __repr__(self) -> str:
30 files = len(self.manifest) if self.manifest else 0
31 return f"<MuseCliSnapshot {self.snapshot_id} files={files}>"
32
33 class MuseCliCommit(Base):
34 """A versioned commit record pointing to a snapshot and its parent."""
35
36 __tablename__ = "muse_commits"
37
38 commit_id: Mapped[str] = mapped_column(String(128), primary_key=True)
39 repo_id: Mapped[str] = mapped_column(String(128), nullable=False, index=True)
40 branch: Mapped[str] = mapped_column(String(255), nullable=False)
41 parent_commit_id: Mapped[str | None] = mapped_column(
42 String(128), nullable=True, index=True
43 )
44 parent2_commit_id: Mapped[str | None] = mapped_column(
45 String(128), nullable=True, index=True
46 )
47 snapshot_id: Mapped[str] = mapped_column(
48 String(128),
49 ForeignKey("muse_snapshots.snapshot_id", ondelete="RESTRICT"),
50 nullable=False,
51 )
52 message: Mapped[str] = mapped_column(Text, nullable=False)
53 author: Mapped[str] = mapped_column(String(255), nullable=False, default="")
54 committed_at: Mapped[datetime] = mapped_column(
55 DateTime(timezone=True), nullable=False
56 )
57 created_at: Mapped[datetime] = mapped_column(
58 DateTime(timezone=True), nullable=False, default=_utc_now
59 )
60 commit_metadata: Mapped[JSONObject | None] = mapped_column(
61 JSONB, nullable=True, default=None
62 )
63
64 def __repr__(self) -> str:
65 return (
66 f"<MuseCliCommit {self.commit_id} branch={self.branch!r}"
67 f" msg={self.message[:30]!r}>"
68 )
69
File History 12 commits
sha256:cfefc25a166c3c3eed8ea3529aee19ea350bc05f2954d007420e924133b7d8ce chore: pivot to nightly channel — bump version to 0.2.0.dev… Sonnet 5 patch 13 days ago
sha256:d035733f21ccff27735fddebfbbe0ed24565a32a22db8de5885402262671ecd2 chore: bump version to 0.2.0rc15 for musehub#113 fix release Sonnet 4.6 patch 16 days ago
sha256:0032d6cfa33bc3c8367436ad768e7dd0e339b4332153160247da8266cb5fa352 Merge branch 'task/version-tags-phase3-server' into dev Human 18 days ago
sha256:4669620efda9ff41c55bdefd1f7bfe1c239d468428744c84ead9957e5a003a53 merge: rescue snapshot-recovery hardening (c00aa21d) into d… Opus 4.8 minor ⚠ 31 days ago
sha256:a59da49c4611b970fc4b6ae48678ce4943261c213a07ddbd73ce9201df869b4a fix: remove false-positive proposal_comments index drop fro… Sonnet 4.6 patch 35 days ago
sha256:0a240d6dbff234f07d98a28a4a9a68db702f3f9ff9260196f24219bdb1c0b6f3 feat: render markdown mists as HTML with heading anchor links Sonnet 4.6 patch 35 days ago
sha256:24a7d47486ebc4ebd1832830580e177ec6f877b48dced8c000e198cdec4ce9d6 Merge 'task/bump-version-rc12' into 'dev' — proposal: Bump … Human 36 days ago
sha256:b9ff931d147e0114a1f17060f415b89ed551c170a91ff226c70437aa5c85f9ee Merge 'task/bump-version-rc12' into 'dev' — proposal: Bump … Human 36 days ago
sha256:d1122d21e73471879b460037b22c0b50fded7c423444a176f248428f75dac39c Merge 'task/fix-issue-pagination-cursor' into 'dev' — propo… Human 37 days ago
sha256:01e18975e73d2b3cd5b6db7929c895bef9aa6e0d4391dc5b2adfc548b41318dd Merge 'feat/adding-debug-logs-to-staging' into 'dev' — prop… Human 37 days ago
sha256:6b1949fc2797ca4c1936a637a4cbfec828ef56cf52398a2e74ca3c4f494e728f fix: use wire_bytes not mpack_bytes_raw in compute_object_b… Sonnet 4.6 patch 49 days ago
sha256:b99f2455dc346966d040133f5203297e6e3ef5803a93728a2c30568d0a0f7583 rename: delta_add → delta_upsert across wire format, models… Sonnet 4.6 patch 51 days ago