メニュー
E2E seed and fixture id_text values must fit nano_id_v2 (9–15 chars). Use when adding or renaming IDs in seed scripts, seedConstants, demo links, or E2E fixtures that insert into id_text columns.
Codex または Claude でインストール この Prompt をコピーして Codex、Claude、または他のアシスタントに貼り付けると、Skill ページを確認してインストールできます。
SOC 職業分類に基づく
| name | e2e-seed-nano-id-limits |
| description | E2E seed and fixture id_text values must fit nano_id_v2 (9–15 chars). Use when adding or renaming IDs in seed scripts, seedConstants, demo links, or E2E fixtures that insert into id_text columns. |
id_text limits (nano_id_v2)When adding deterministic E2E fixtures (seed SQL, tools/**/seed-e2e.mjs, demo URLs, or
apps/**/e2e/helpers/seedConstants.ts), every id_text must satisfy the Postgres
nano_id_v2 domain.
| Source | Rule |
|---|---|
| DB domain | VARCHAR(15) with char_length 9–15 (0000_init_helpers.sql) |
| TypeScript | NANO_ID_V2_MIN_LENGTH / NANO_ID_V2_MAX_LENGTH in packages/orm/src/lib/nanoid.ts |
Do not assume descriptive strings are valid just because they look like other E2E IDs.
Count characters before committing — a name one character too long fails at seed time with
value too long for type character varying(15).
nano_id_v2 for public IDsCommon E2E fixture targets (all share the same length rule):
item.id_text, channel.id_textplaylist.id_text, queue.id_text, clip.id_textaccount.id_text (and management admin id_text)Follow existing short prefixes (typically 12–14 chars), not long readable phrases:
e2ePodResume01 (13), e2eEmbVidItem01 (14), e2eEmbScrCh01 (13)e2eEmbedVideoItem01 (18), e2eEmbedScrollCh01 (16)Prefer abbreviated segments (Emb, Vid, Scr, Pl, Prv) and two-digit suffixes
(01, 02) so generated series (e2eEmbScrIt01–10) stay ≤ 15.
When introducing or renaming a fixture id_text, update all references together:
tools/web/seed-e2e.mjs (and tools/management-web/seed-e2e.mjs when applicable)apps/web/e2e/helpers/seedConstants.ts (and management-web counterpart)apps/web/src/lib/embed/embedDemoLinks.ts)seedConstants.ts over inline string literalsAfter changing seed IDs, run:
make e2e_seed_web
Seed failure on insert is almost always an id_text length or sync mismatch — fix length
first, then grep for stale string literals.
Just-in-time phase workflow for the Podverse mobile master plan. Use when the operator asks what to work on next in the mobile master plan, to plan or detail the next mobile phase, to create deferred detail docs and COPY-PASTA sets, or to implement a mobile master-plan phase.
Cross-platform theme AND visual parity for apps/mobile — same theme IDs and design tokens as web, RN ThemeProvider, uit pref, and web-referenced screen layouts. Use when adding mobile styling, ThemeProvider, theme selector, design token imports, or building any mobile screen that has a web counterpart.
FOSS vs playstore Android/iOS product flavors — FCM vs UnifiedPush, non-FOSS dependency register, defer full implementation to Track 20.
Expo SDK 52 as a standalone install under apps/mobile — own lockfile, file: shared packages, Metro. Use when mobile npm install, prebuild, pod install, mobile:dev fails, or when telling the operator how to run expo install (never bare root npx expo).
abcmemory checklist for mobile work — when to update .cursor/ rules/skills vs .llm/plans; abcremember vocabulary; links mobile-master-plan-phasing.
Offline-first mobile data layer — SQLite/Drizzle repositories, background sync, storage boundaries. Use when adding or changing apps/mobile data fetching, local persistence, queue/history/add-by-RSS storage, or sync.