commerce/migrations/ at main · lgtm.shop/commerce · Tangled

lgtm.shop / commerce

5

Pilot atproto-native commerce backend

5

commerce / migrations /

at main 6 files

Nate Moore fix(boot): resolve apalis/app sqlx migration-table collision so the binary boots + processes jobs 6w ago

M0 T3: advisory-locked migration runner + 0001_init (pgcrypto) Co-Authored-By: Claude Opus 4.8 (1M context) <noreply@anthropic.com>

1 month ago

0002_tenant.sql

db: tenant, store_signing_key, integration_config tables + sealed-column models Migration 0002 adds the three tables verbatim from SPEC §6. models.rs is wired into crates/db; Tenant, StoreSigningKey, and IntegrationConfig structs derive FromRow. StoreSigningKey::new_sealed/open_private and IntegrationConfig::new_sealed/open_config round-trip through lgtm_core::crypto::seal/open. Three #[sqlx::test] pass. Co-Authored-By: Claude Opus 4.8 (1M context) <noreply@anthropic.com>

1 month ago

0003_catalog_and_space.sql

db: space, space_member, product, variant tables + models Migration 0003 adds four tables verbatim from SPEC §6. Space enforces unique (owner_did, type_nsid, skey). Rust models Space, SpaceMember, ProductRow, VariantRow derive FromRow with correct nullable fields and jsonb columns as serde_json::Value. Three #[sqlx::test] pass. Co-Authored-By: Claude Opus 4.8 (1M context) <noreply@anthropic.com>

1 month ago

0004_orders.sql

db: customer, external_account_link, order_record, order_item tables + sealed-email model Migration 0004 adds four tables verbatim from SPEC §6. Customer exposes new_sealed_email/open_email helpers; ExternalAccountLink exposes open_token. OrderRecord maps the reserved-word `type` column via r#type. Four #[sqlx::test] pass including unique-constraint probes on (space_id,collection,rkey) and (customer_id,provider). Co-Authored-By: Claude Opus 4.8 (1M context) <noreply@anthropic.com>

1 month ago

0005_fulfillment_and_proof.sql

db: address, receipt, purchase_claim, benefit_grant, fulfillment, webhook_event tables + models Migration 0005 adds six tables verbatim from SPEC §6. AddressRecord exposes new_sealed/open_body for encrypted PII. purchase_claim enforces unique(claim_uri); webhook_event PK deduplication tested. Five #[sqlx::test] pass; full models::tests suite is 15/15 green. Co-Authored-By: Claude Opus 4.8 (1M context) <noreply@anthropic.com>

1 month ago

0006_apalis.sql

fix(boot): resolve apalis/app sqlx migration-table collision so the binary boots + processes jobs Vendor all 6 apalis-sql 0.6.4 postgres migrations into migrations/0006_apalis.sql so our app migrator (single lineage, versions 1-6) owns the apalis schema setup. Remove the worker::setup_storage() call from boot (no more apalis migrator collision). Add DevFulfillmentProvider to dev.rs and register it in fake-payments mode so the full worker pipeline (fulfillment -> receipt mint -> sign -> Fulfilled) completes without a real Printful API key. Co-Authored-By: Claude Opus 4.8 (1M context) <noreply@anthropic.com>

1 month ago