moderator-page-migration

Inventory every procedure and child-component mutation the page reaches, classify each mutation's side effects, then map tRPC queries to +page.server.ts loads and mutations to form actions backed by Kysely services. Finish by deleting the legacy page, adding a redirect, and trimming orphaned code.

Match the literal shape of the Prisma-generated WHERE clause, including casts, because partial indexes only match their exact predicate form. Check which index the original query hit before rewriting, and prefer Kysely's builder with raw SQL reserved for bitmask, jsonb, and LATERAL cases.

Child components like context menus and confirm dialogs import tRPC directly, so grepping the page file finds none of them. Grep the entire component tree referenced by the page to enumerate every mutation before porting.

Main-app moderation writes often fan out to notifications, email, Buzz, ClickHouse, Redis busts, search-index enqueues, and session invalidation. Classify each effect as port, delegate, defer, or equivalent and record deferred items in the side-effect parity checklist.

New pages have no AppPageAccess row, so only moderator:admin can open them until grants are assigned on /admin. The route must also be registered in NAVIGATION in $lib/server/access.ts, otherwise it is unreachable for everyone.

Delegate effects a moderator would notice, such as notifications, to an internal main-app endpoint the spoke calls. Defer only effects whose absence is recoverable, like analytics, and record them with a severity in the checklist.