Skip to content

DB (DOS.Me): give.campaign_members, single-use invite links & owner-only money boundary for #253 #264

Closed

Description

@JOY

Goal

Provide the DOS/DOS.Me database migration, RLS, invite/team RPCs, and pgTAP tests needed by DOS/Give#253 (Co-organizers: invite editors to a campaign (money stays with the owner), 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.campaign_members & single-use expiring invites:
    • give.campaign_members (campaign_id, user_id, role CHECK (role = 'editor'), invited_by, accepted_at, created_at) + single-use expiring invite token table (hashed token, expires_at, single acceptance while signed in; owner creates/revokes invites and removes members).
  2. Permission boundary (Editors vs Owner):
    • Accepted editors may: read the campaign in managed_campaigns (or with their role exposed so the app hides owner-only controls), edit campaign content while editable, manage milestones, media, and reward tiers under the same status rules as the owner, post updates, and reply/hide comments once #250 lands.
    • Owner-only (Editors strictly refused): receiving accounts & account bindings/swaps, statement uploads & unmatched matching, disbursements, refunds, fulfillment shipping/contact PII (set_pledge_fulfillment & fulfillment backer reads), transition_campaign (submitForReview / cancelCampaign), and member management.
    • Public team RPC (e.g. give.campaign_public_team(p_campaign_id uuid)) so /campaigns/[slug] can display the campaign team safely without leaking user_id / legal_name / phone.
  3. pgTAP tests: invite lifecycle (create, expire, single-use accept, owner remove), editor allowed on content/milestones/media/tiers/updates, and explicit refusal assertions on every money, fulfillment-PII, account, and submit-for-review RPC/RLS policy.

Once merged to DOS/DOS.Me dev, please comment on DOS/Give#253 with the RPC signatures and error codes.

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=69283fb4-886d-46e0-8cee-0d12438a9a64 scope="DOS/DOS.Me give.campaign_members + invites + owner-only money boundary migration + pgTAP" branch=antigravity/give-264-campaign-members 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=69283fb4-886d-46e0-8cee-0d12438a9a64 PR https://github.com/DOS/DOS.Me/pull/1856 opened targeting dev at 3ca9f01a63f485e5bc102cda1f8b687068523e23. Local verification: fresh full migration replay + idempotency double-apply PASS, 44/44 give pgTAP suites PASS (152/152 assertions in give_campaign_members.test.sql), give-role-lock-runtime-check 21/21 PASS, independent fresh-context security review CLEAN_PASS (3 P1 + 1 P2 fixed before push). Waiting for CI checks on PR #1856.

  5. JOY commented on Nov 22, 2026

    @JOY
    ContributorAuthor

    PO acceptance: merge at 88fe498242b74f2e398d349a7c76abdc13a20dde (DOS/DOS.Me#1856 -> dev)

  6. JOY commented on Nov 22, 2026

    @JOY
    ContributorAuthor

    checkpoint: session=69283fb4-886d-46e0-8cee-0d12438a9a64 Merged https://github.com/DOS/DOS.Me/pull/1856 (supabase/migrations/20261129170000_give_campaign_members.sql + supabase/tests/database/give_campaign_members.test.sql) into DOS/DOS.Me dev at merge commit 34f4fa5d0e3d88b3956c46d74fcce71330823085 (from accepted head 88fe498242b74f2e398d349a7c76abdc13a20dde). Evidence: Supabase Preview (Beta oyajkbadsykigtfrpdpg) completed/success (check-run 137052414913, 2026-11-22T01:28:17Z); all 4 required CI checks green (Give pgTAP Tests, Supabase Migration Replay (dev), Repository integrity, Dependabot Auto-Merge / Validate); local 47/47 give_*.test.sql suites (172/172 in give_campaign_members.test.sql) + give-role-lock-runtime-check 21/21 PASS. RPC contract & error codes posted on DOS/Give#253 (#253 (comment)). Worktree, local branch, and scratch Supabase container removed. Keeping #264 open for Production (dev -> main) promotion by Claude PO.

  7. JOY commented on Nov 22, 2026

    @JOY
    ContributorAuthor

    handoff: session=69283fb4-886d-46e0-8cee-0d12438a9a64 to=83b36fa6-8c08-49d6-aeec-63bab02a5e52
    Done: Implemented and squash-merged https://github.com/DOS/DOS.Me/pull/1856 (supabase/migrations/20261129170000_give_campaign_members.sql and supabase/tests/database/give_campaign_members.test.sql) into DOS/DOS.Me dev at merge commit 34f4fa5d0e3d88b3956c46d74fcce71330823085 (accepted head 88fe498242b74f2e398d349a7c76abdc13a20dde). Posted full RPC signatures, capability boundary, and GIVE_* error codes on DOS/Give#253 (#253 (comment)). Cleaned up worktree /Users/JOY/Projects/DOS.Me-worktrees/give-264-campaign-members, local branch, and local Supabase container.
    Evidence: Supabase Preview (Beta oyajkbadsykigtfrpdpg) completed/success on 34f4fa5d0e3d88b3956c46d74fcce71330823085 (check-run 137052414913, 2026-11-22T01:28:17Z); all 4 required CI checks green (Give pgTAP Tests, Supabase Migration Replay (dev), Repository integrity, Dependabot Auto-Merge / Validate); local 47/47 give_*.test.sql suites PASS (172/172 assertions in give_campaign_members.test.sql); give-role-lock-runtime-check 21/21 PASS; dual independent security reviews (f6d86ba7-ae7c-4fbf-b8e9-299b9a8c1a21 CLEAN_PASS + PO flagship review APPROVE).
    Remaining: Production (dev -> main) promotion in DOS/DOS.Me (Claude PO's exclusive responsibility, once JOY approves).
    Next step: Campaigns PO can now dispatch DOS/Give#253 against Beta (dev); keep DOS/Give#264 open until 20261129170000_give_campaign_members.sql is promoted to DOS/DOS.Me main.
    Blockers: Production dev -> main promotion awaits Claude PO + JOY approval.
    Branch: antigravity/give-264-campaign-members merged to DOS/DOS.Me dev at 34f4fa5d0e3d88b3956c46d74fcce71330823085 and deleted.

  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#1856 dev -> main promotion" branch=antigravity/give-264-campaign-members 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#1856 merged at 34f4fa5d0e3d88b3956c46d74fcce71330823085 and verified on Supabase Preview (Beta). Unblocked #253.

  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