Skip to content

DB (DOS.Me): public organizer handle, bio & public profile/campaigns RPCs for #251 #261

Closed

Description

@JOY

Goal

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)

  1. 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 only handle and/or bio must not reset verification_status in give.organizers_reset_verification (only identity fields kind, legal_name, display_name reset verification).
  2. 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.
  3. 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).
  4. 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.Me dev, please drop a note on DOS/Give#251 with the RPC signatures and error codes so Campaigns PO can ship the apps/web UI.

Activity

  1. added
    po:agyOwned by Antigravity PO (mutual-exclusion parallel PO label)
    on Nov 18, 2026
  2. JOY commented on Nov 21, 2026

    @JOY
    ContributorAuthor

    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

  3. added 2 commits that reference this issue on Nov 21, 2026
  4. JOY commented on Nov 21, 2026

    @JOY
    ContributorAuthor

    checkpoint: session=9a973c81-7dae-482a-860d-38d69a844969 opened https://github.com/DOS/DOS.Me/pull/1851 (head 32ebf2f015c7097f20e83e3ad13cbff76c81dd6b) targeting dev. Local isolated supabase db start replay + 2x idempotency + 44/44 give_*.test.sql pgTAP suites (including 57/57 new assertions in give_organizer_public_profile.test.sql) passed; fresh-context security review completed (1 P2 fixed). Waiting for DOS.Me CI checks and automated reviews.

  5. JOY commented on Nov 22, 2026

    @JOY
    ContributorAuthor

    PO acceptance: merge at 5634daa7095e16cdc213021b447eed7fc870fc41 (DOS/DOS.Me#1851 -> dev)

  6. JOY commented on Nov 22, 2026

    @JOY
    ContributorAuthor

    checkpoint: session=9a973c81-7dae-482a-860d-38d69a844969 merged https://github.com/DOS/DOS.Me/pull/1851 into DOS/DOS.Me dev 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 only SUCCESS, Secret scan (gitleaks) SUCCESS. Posted full RPC/error contract on DOS/Give#251 (#251 (comment)) and cleaned up local worktree/branch.

  7. JOY commented on Nov 22, 2026

    @JOY
    ContributorAuthor

    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.Me dev 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.Me dev -> 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.Me dev -> 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.Me dev).

  8. JOY commented on Nov 22, 2026

    @JOY
    ContributorAuthor

    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

  9. JOY commented on Nov 22, 2026

    @JOY
    ContributorAuthor

    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.

  10. JOY commented on Nov 22, 2026

    @JOY
    ContributorAuthor

    done: session=83b36fa6-8c08-49d6-aeec-63bab02a5e52
    Promoted to Production and verified live:

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment

Metadata

Metadata

Assignees

No one assigned

    Labels

    line:platformProduct line: platformpo:agyOwned by Antigravity PO (mutual-exclusion parallel PO label)

    Type

    No type

    Projects

    No projects

      Milestone

      No milestone

      Relationships

      None yet

      Development

      No branches or pull requests

      Issue actions