Skip to content

One Piece Sealed Catalogue ​

Backend: PR #480. Mobile: PR #673, issue #672.

Inventory And Mapping ​

The supplied one-piece-tcg-sealed inner directory contains 72 valid images. Two generic illustrations are excluded, leaving 70 catalogue candidates. One duplicate-image group is retained as distinct packaging identities rather than merging products by image hash. Mac resource forks are not catalogue assets.

The owner approved these mappings on 2026-10-15:

Folder suffixExisting type
blisterBlister
boosterBooster
boxesCoffrets
case-blisterBlister
case-displayDisplay
dbDuoPack
deckDeck
displayDisplay

LD-01 Apprenez Ensemble is an explicit Deck exception despite its display folder. Migration 0042 inserts only these mappings and preserves existing mappings on replay. No collection holdings, account data, category tables or pricing are changed.

Content Evidence ​

The research manifest accounts for all 72 source hashes. There are 27 verified numbered-booster compositions, five fixed-content products without numbered boosters, 38 records without verified edition/pack quantity and two exclusions. The latter 38 retain primary series only; this is not a claim of complete composition verification for every product.

Examples confirmed against official Bandai product pages:

  • French ST-15 through ST-20: one OP-09 booster, not the English PRB-01 content.
  • French ST-23 through ST-28: one OP-11 booster.
  • French ST-31 through ST-36: one OP-16 booster.
  • English SD-01: one OP-17 booster.
  • French DF-03: three OP-12 boosters.
  • The seven English Double Packs: two boosters of their documented series.
  • LD-01 and ST-21/22/29/30 do not acquire a numbered-booster membership from bonus packs.

Source URLs, exact edition notes and original hashes are versioned with the backend. Official content is used as evidence; supplied artwork provenance is Cardmarket, with publication rights confirmed by the owner. Provenance is not exposed in the app. Unknown language/release dates remain null rather than copying a sibling edition.

API And App ​

The existing server filters and pagination remain authoritative. One Piece decks appear in their primary ST series and evidenced included-booster series. Listing rows retain the primary identity; facets count distinct products. Backend family labels distinguish main series, starter decks and special series. Pokemon membership semantics remain unchanged.

The mobile screen resolves existing series artwork by canonical set ID instead of translated text. Deck/DuoPack facets and scoped cached pages are covered by tests. Existing light/dark tokens and guest image access remain in use; there are no runtime mock products. Prices and sealed scan recognition are outside scope.

Validation And Rollout ​

  • Backend unit/handler suite: 1,155 passed; ingest: 551 passed.
  • Backend build and JavaScript typecheck passed.
  • Mobile: 2,477 tests passed, 11 existing skipped; lint and typecheck passed.
  • Local real-Postgres E2E could not run because Docker is unavailable. All six backend CI gates passed, including real-Postgres E2E, ingest integration and the Docker API smoke test. Mobile CI also passed.
  • Native visual validation with the imported dataset has not been performed.

Completed Rollout ​

After green CI and the owner's separate fusion/deployment approval, backend PR #480 and mobile PR #673 were merged to staging. Backend staging commit fa46bc6 was deployed. Main was not changed; only the API service was restarted.

Before migration/import, a targeted custom-format backup of sealed products, image references, mapping rows and types was verified with the restore listing. All 72 original hashes matched after upload. Migration 0042 and both importer dry-runs succeeded before application. Database checks confirmed 70 products, 140 image references, 27 approved compositions and zero generic products. Fingerprints confirmed all pre-existing catalogue products, image references and mapping rows remained unchanged. Temporary database credentials were removed.

After deployment, the public API returned 70 distinct One Piece products and backend family facets. ST-15 appeared under both ST-15 and OP-09 while retaining its primary identity. Every thumbnail/detail image (140 requests) returned a valid JPEG without an account. Raw image access remained 401 and private media paths remained 404. API readiness passed. The previous image and a rollback override were retained; no unrelated service was restarted.

Original files remain outside the public image tree; only metadata-free content-addressed derivatives are served. The 38 unverified edition/pack-count records remain deliberately unresolved in the manifest. No new mobile native build was created or installed in this task.