You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
{{ message }}
Repository navigation
DB (DOS.Me): public organizer handle, bio & public profile/campaigns RPCs for #251 #261
Provide the DOS/DOS.Me database migration, RLS/column-grant rules, and pgTAP tests needed by DOS/Give#251 (Public organizer profile page, line:campaigns). Per docs/product-owner-config.md, DOS/DOS.Me migrations belong to line:platform (Give Product Owner).
Requirements (DOS/DOS.Me)
give.organizers public profile columns:
handle text UNIQUE (lowercase slug ^[a-z0-9](?:[a-z0-9-]{1,38}[a-z0-9])?$, reserved route words rejected; auto-seeded or settable by the organizer from /me).
bio text NULL CHECK (bio IS NULL OR char_length(bio) <= 500).
Important trigger invariant: updating onlyhandle and/or bio must not reset verification_status in give.organizers_reset_verification (only identity fields kind, legal_name, display_name reset verification).
Privacy & column grants:
legal_name, phone, user_id (on public campaign reads per 20261101090000_give_campaign_read_hardening.sql), and receiving accounts must never be exposed publicly.
Public RPCs (SECURITY DEFINER, anon, authenticated):
Extend give.campaign_public_organizer(uuid) and give.campaign_public_organizers(uuid[]) to also return handle text so campaign pages and cards can link to /u/<handle>.
give.public_organizer_profile(p_handle text): returns (handle, display_name, avatar_url, kind, verification_status, bio, created_at) (joining DOS ID public.profiles avatar if available without leaking private columns) when the organizer exists and has handle = lower(trim(p_handle)).
give.list_organizer_public_campaigns(p_handle text): returns the organizer's public campaigns (give.is_public_status(status)) with public card columns (id, slug, type, title, summary, goal_amount, ends_at, status, display_options, cover storage_path/alt, created_at), ordered newest-first, so apps/web computes money totals from give.campaign_money_totals (the ledger).
pgTAP tests: cover handle validation/uniqueness, bio cap, keeping verification_status = 'verified' across handle/bio edits, and proving anon cannot read legal_name, phone, user_id, draft/suspended campaigns, or receiving accounts.
Once merged to DOS/DOS.Medev, please drop a note on DOS/Give#251 with the RPC signatures and error codes so Campaigns PO can ship the apps/web UI.
checkpoint: session=9a973c81-7dae-482a-860d-38d69a844969 merged https://github.com/DOS/DOS.Me/pull/1851 into DOS/DOS.Medev at f2d8ee3766f060859e541ba141f6f2eaa5905bc2 (2026-11-22T01:08:02Z, migration supabase/migrations/20261129160000_give_organizer_public_profile.sql). Beta verification green: Supabase Preview on Beta (oyajkbadsykigtfrpdpg) SUCCESS (2026-11-22T01:08:50Z), Beta migration history preparation onlySUCCESS, Secret scan (gitleaks)SUCCESS. Posted full RPC/error contract on DOS/Give#251 (#251 (comment)) and cleaned up local worktree/branch.
handoff: session=9a973c81-7dae-482a-860d-38d69a844969 to=83b36fa6-8c08-49d6-aeec-63bab02a5e52
Done: Implemented, tested, reviewed, and squash-merged DOS/DOS.Me#1851 (https://github.com/DOS/DOS.Me/pull/1851) into DOS/DOS.Medev at f2d8ee3766f060859e541ba141f6f2eaa5905bc2 (supabase/migrations/20261129160000_give_organizer_public_profile.sql, supabase/tests/database/give_organizer_public_profile.test.sql, supabase/tests/database/give_public_campaign_organizers.test.sql). Posted RPC signatures, handle/bio rules, and GIVE_* error codes on DOS/Give#251 (#251 (comment)). Cleaned up local worktree /Users/JOY/Projects/DOS.Me-worktrees/give-261-organizer-profile, local branch, and temporary local Supabase DB container.
Evidence: On PR head 5634daa7095e16cdc213021b447eed7fc870fc41: Supabase migration replay (dev) SUCCESS (2m57s), Give pgTAP tests (dev) SUCCESS (4m10s, 57 new assertions + all give_*.test.sql suites), Repository integrity SUCCESS, Validate pnpm lockfile SUCCESS; fresh-context DB security review + PO flagship security review + Gemini Code Assist review clean (0 unresolved threads). On dev merge commit f2d8ee3766f060859e541ba141f6f2eaa5905bc2: Supabase Preview (Beta oyajkbadsykigtfrpdpg) SUCCESS (2026-11-22T01:08:50Z), Beta migration history preparation only SUCCESS, Secret scan (gitleaks) SUCCESS.
Remaining: Production promotion (DOS/DOS.Medev -> main) to apply 20261129160000_give_organizer_public_profile.sql to prod Supabase gulptwduchsjcsbndmua and close DOS/Give#261 once verified on Production (Platform/Claude PO exclusive step).
Next step: Campaigns PO can dispatch DOS/Give#251 against Beta immediately; Platform/Claude PO includes f2d8ee3766f060859e541ba141f6f2eaa5905bc2 in the next DOS/DOS.Medev -> main Production promotion.
Blockers: none for Beta / #251; Production promotion awaits Platform/Claude PO + JOY approval per docs/product-owner-config.md.
Branch: antigravity/give-261-organizer-profile merged and deleted (merge commit f2d8ee3766f060859e541ba141f6f2eaa5905bc2 on DOS/DOS.Medev).
claim: executor=Antigravity session=83b36fa6-8c08-49d6-aeec-63bab02a5e52 scope="Production steps, waiting for Claude PO (Give Product Owner) DOS/DOS.Me#1851 dev -> main promotion" branch=antigravity/give-261-organizer-profile target=2026-11-28
checkpoint: session=83b36fa6-8c08-49d6-aeec-63bab02a5e52 waiting for DOS/DOS.Me dev -> main Production promotion by Give Product Owner (Claude Code) after JOY approval; DOS/DOS.Me#1851 merged at f2d8ee3766f060859e541ba141f6f2eaa5905bc2 and verified on Supabase Preview (Beta). Unblocked #251.
done: session=83b36fa6-8c08-49d6-aeec-63bab02a5e52
Promoted to Production and verified live:
DOS/DOS.Me#1869 merged to main at 1de1b0b41a7a3759e41d10ef0024fd708a10d71c (Supabase Production gulptwduchsjcsbndmua: completed/success 2026-11-22T08:26:31Z)
Activity
JOY commentedon Nov 21, 2026
claim: executor=Antigravity session=9a973c81-7dae-482a-860d-38d69a844969 scope="DOS/DOS.Me give organizer public profile migration + pgTAP" branch=antigravity/give-261-organizer-profile target=2026-11-22
docs(po): bound #261-#264 exception strictly to DOS/DOS.Me dev migrat…
docs(po): update product-owner-config for CC-PO v2.18.0 parallel POs (#…
JOY commentedon Nov 21, 2026
checkpoint: session=9a973c81-7dae-482a-860d-38d69a844969 opened https://github.com/DOS/DOS.Me/pull/1851 (head 32ebf2f015c7097f20e83e3ad13cbff76c81dd6b) targeting
dev. Local isolatedsupabase db startreplay + 2x idempotency + 44/44give_*.test.sqlpgTAP suites (including 57/57 new assertions ingive_organizer_public_profile.test.sql) passed; fresh-context security review completed (1 P2 fixed). Waiting for DOS.Me CI checks and automated reviews.JOY commentedon Nov 22, 2026
PO acceptance: merge at 5634daa7095e16cdc213021b447eed7fc870fc41 (DOS/DOS.Me#1851 -> dev)
JOY commentedon Nov 22, 2026
checkpoint: session=9a973c81-7dae-482a-860d-38d69a844969 merged https://github.com/DOS/DOS.Me/pull/1851 into
DOS/DOS.Medevatf2d8ee3766f060859e541ba141f6f2eaa5905bc2(2026-11-22T01:08:02Z, migrationsupabase/migrations/20261129160000_give_organizer_public_profile.sql). Beta verification green:Supabase Previewon Beta (oyajkbadsykigtfrpdpg) SUCCESS (2026-11-22T01:08:50Z),Beta migration history preparation onlySUCCESS,Secret scan (gitleaks)SUCCESS. Posted full RPC/error contract onDOS/Give#251(#251 (comment)) and cleaned up local worktree/branch.JOY commentedon Nov 22, 2026
handoff: session=9a973c81-7dae-482a-860d-38d69a844969 to=83b36fa6-8c08-49d6-aeec-63bab02a5e52
Done: Implemented, tested, reviewed, and squash-merged
DOS/DOS.Me#1851(https://github.com/DOS/DOS.Me/pull/1851) intoDOS/DOS.Medevatf2d8ee3766f060859e541ba141f6f2eaa5905bc2(supabase/migrations/20261129160000_give_organizer_public_profile.sql,supabase/tests/database/give_organizer_public_profile.test.sql,supabase/tests/database/give_public_campaign_organizers.test.sql). Posted RPC signatures, handle/bio rules, andGIVE_*error codes onDOS/Give#251(#251 (comment)). Cleaned up local worktree/Users/JOY/Projects/DOS.Me-worktrees/give-261-organizer-profile, local branch, and temporary local Supabase DB container.Evidence: On PR head
5634daa7095e16cdc213021b447eed7fc870fc41:Supabase migration replay (dev)SUCCESS (2m57s),Give pgTAP tests (dev)SUCCESS (4m10s, 57 new assertions + allgive_*.test.sqlsuites),Repository integritySUCCESS,Validate pnpm lockfileSUCCESS; fresh-context DB security review + PO flagship security review + Gemini Code Assist review clean (0 unresolved threads). Ondevmerge commitf2d8ee3766f060859e541ba141f6f2eaa5905bc2:Supabase Preview(Betaoyajkbadsykigtfrpdpg) SUCCESS (2026-11-22T01:08:50Z),Beta migration history preparation onlySUCCESS,Secret scan (gitleaks)SUCCESS.Remaining: Production promotion (
DOS/DOS.Medev -> main) to apply20261129160000_give_organizer_public_profile.sqlto prod Supabasegulptwduchsjcsbndmuaand closeDOS/Give#261once verified on Production (Platform/Claude PO exclusive step).Next step: Campaigns PO can dispatch
DOS/Give#251against Beta immediately; Platform/Claude PO includesf2d8ee3766f060859e541ba141f6f2eaa5905bc2in the nextDOS/DOS.Medev -> mainProduction promotion.Blockers: none for Beta /
#251; Production promotion awaits Platform/Claude PO + JOY approval perdocs/product-owner-config.md.Branch:
antigravity/give-261-organizer-profilemerged and deleted (merge commitf2d8ee3766f060859e541ba141f6f2eaa5905bc2onDOS/DOS.Medev).JOY commentedon Nov 22, 2026
claim: executor=Antigravity session=83b36fa6-8c08-49d6-aeec-63bab02a5e52 scope="Production steps, waiting for Claude PO (Give Product Owner) DOS/DOS.Me#1851 dev -> main promotion" branch=antigravity/give-261-organizer-profile target=2026-11-28
JOY commentedon Nov 22, 2026
checkpoint: session=83b36fa6-8c08-49d6-aeec-63bab02a5e52 waiting for DOS/DOS.Me dev -> main Production promotion by Give Product Owner (Claude Code) after JOY approval; DOS/DOS.Me#1851 merged at f2d8ee3766f060859e541ba141f6f2eaa5905bc2 and verified on Supabase Preview (Beta). Unblocked #251.
JOY commentedon Nov 22, 2026
done: session=83b36fa6-8c08-49d6-aeec-63bab02a5e52
Promoted to Production and verified live: