settlekit/apps/api/scripts/pg-escrow-smoke.mjs
caelum0x f7c9cd735d feat(escrow): Postgres persistence for the full escrow lifecycle
- add missing escrow_refunds + escrow_reviews tables (schema + migration 0001)
- seed a default customer (DEFAULT_CUSTOMER_ID) to satisfy buyer_customer_id FK
- PgEscrowStore: document-projection over all 7 escrow tables; deterministic
  per-task ids for idempotent sub-record upserts; listTasks filters docs by org
- wire escrow to Postgres in context (in-memory fallback retained)

Verified live: create->fund->assign->submit->approve->release persists rows in
escrow_tasks/fundings/submissions/reviews/releases; documents round-trip (real
buyerCustomerId in __doc, FK-safe default projected). 50 tables; 590 tests pass.

Remaining in-memory in Postgres mode (deep FK chains / no clean table fit):
saas seats (subscription FK), agent usage (agent_buyers FK), file-download
grants + agent reputation (no backing table).
2026-06-15 12:04:32 +03:00

38 lines
1.8 KiB
JavaScript

import { createApp } from "../dist/app.js";
import { createContext } from "../dist/context.js";
const KEY = process.env.API_BOOTSTRAP_KEY ?? "smoke-key";
async function main() {
const ctx = await createContext();
const app = createApp(ctx);
const call = async (method, path, body) => {
const res = await app.request(path, {
method,
headers: { authorization: `Bearer ${KEY}`, "content-type": "application/json" },
...(body !== undefined ? { body: JSON.stringify(body) } : {}),
});
return { status: res.status, json: await res.json() };
};
const log = (l, r) => { console.log(`${l}: ${r.status} ${r.json.error ? JSON.stringify(r.json.error) : r.json.data?.status ?? "ok"}`); if (r.status >= 400) throw new Error(`${l}: ${JSON.stringify(r.json)}`); };
const t = await call("POST", "/v1/escrow/tasks", {
organizationId: "org_1", buyerCustomerId: "cus_buyer", title: "Build a widget",
description: "Implement the widget", amount: "100.00",
});
log("create", t);
const id = t.json.data.id;
log("fund", await call("POST", `/v1/escrow/tasks/${id}/fund`, { fundingTxHash: "0xfund1" }));
log("assign", await call("POST", `/v1/escrow/tasks/${id}/assign`, { workerCustomerId: "cus_worker" }));
log("submit", await call("POST", `/v1/escrow/tasks/${id}/submit`, { content: "here is the work" }));
log("approve", await call("POST", `/v1/escrow/tasks/${id}/approve`));
log("release", await call("POST", `/v1/escrow/tasks/${id}/release`, { releaseTxHash: "0xrelease1" }));
const list = await call("GET", "/v1/escrow/tasks?organizationId=org_1");
console.log(`list count=${list.json.data.length}`);
console.log("ESCROW_ID", id);
console.log("ESCROW_SMOKE_OK");
}
main().catch((e) => { console.error("ESCROW_SMOKE_FAIL", e); process.exit(1); });