gabriel / musehub public
musehub_collaborator_models.py python
54 lines 2.3 KB
Raw
sha256:0032d6cfa33bc3c8367436ad768e7dd0e339b4332153160247da8266cb5fa352 Merge branch 'task/version-tags-phase3-server' into dev Human 17 days ago
1 """SQLAlchemy ORM model for MuseHub collaborators.
2
3 Collaborators are users granted explicit push/admin access to a repo beyond
4 the owner. Permission levels: read | write | admin (default: write).
5 """
6
7 from datetime import datetime, timezone
8
9 from sqlalchemy import DateTime, ForeignKey, Index, String, UniqueConstraint
10 from sqlalchemy.orm import Mapped, MappedAsDataclass, mapped_column
11
12 from musehub.db.database import Base
13
14 def _utc_now() -> datetime:
15 return datetime.now(tz=timezone.utc)
16
17 class MusehubCollaborator(MappedAsDataclass, Base):
18 """A collaborator record granting a user explicit access to a repo.
19
20 ``permission`` is one of "read" | "write" | "admin"; defaults to "write".
21 ``invited_by_handle`` references the identity handle who extended the invitation (nullable
22 some collaborators may be added programmatically without an inviter).
23 ``accepted_at`` is null until the invited user explicitly accepts.
24
25 ``id`` is genesis-addressed: sha256(repo_id NUL identity_id NUL created_at_iso).
26 """
27
28 __tablename__ = "musehub_collaborators"
29 __table_args__ = (
30 UniqueConstraint("repo_id", "identity_handle", name="uq_musehub_collaborators_repo_identity"),
31 Index("ix_musehub_collaborators_repo_id", "repo_id"),
32 Index("ix_musehub_collaborators_identity_handle", "identity_handle"),
33 )
34
35 # --- Required fields ---
36 id: Mapped[str] = mapped_column(String(128), primary_key=True)
37 repo_id: Mapped[str] = mapped_column(
38 String(128),
39 ForeignKey("musehub_repos.repo_id", ondelete="CASCADE"),
40 nullable=False,
41 )
42 identity_handle: Mapped[str] = mapped_column(String(64), nullable=False)
43
44 # --- Optional fields with Python-side defaults ---
45 # Permission level: "read" | "write" | "admin"
46 permission: Mapped[str] = mapped_column(String(20), nullable=False, default="write", server_default="write")
47 invited_by_handle: Mapped[str | None] = mapped_column(String(64), nullable=True, default=None)
48 invited_at: Mapped[datetime] = mapped_column(
49 DateTime(timezone=True), nullable=False, default_factory=_utc_now
50 )
51 # Null until the invited user accepts the invitation
52 accepted_at: Mapped[datetime | None] = mapped_column(
53 DateTime(timezone=True), nullable=True, default=None
54 )
File History 10 commits
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 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 36 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 51 days ago