import { makeExecutionReceipt } from './execution-receipt.mjs'; import { executeWorkflow } from './workflow-demo.mjs'; /** * Deterministic local demonstration. This is not a footspa software connector. * The demo's business rows and execution ledger share one SQLite transaction. * A real vendor must provide its own transaction/idempotency and reconciliation. */ import { DatabaseSync } from 'node:sqlite'; import { createHash } from 'node:crypto'; import { pathToFileURL } from 'node:url'; import { VendorClient, createLeaseToken } from './vendor-client.mjs'; const stable = value => Array.isArray(value) ? value.map(stable) : value && typeof value === 'object' ? Object.fromEntries(Object.keys(value).sort().map(k => [k, stable(value[k])])) : value; const fingerprint = command => createHash('sha256').update(JSON.stringify(stable({ command_id: command.command_id, action: command.action, target: command.target, params: command.params, operator: command.operator }))).digest('hex'); export class DemoAdapter { constructor(filename, { now = () => Date.now() } = {}) { this.now = now; this.db = new DatabaseSync(filename); this.db.exec(`PRAGMA journal_mode=WAL; PRAGMA synchronous=FULL; CREATE TABLE IF NOT EXISTS demo_execution_receipts(command_id TEXT PRIMARY KEY, receipt TEXT NOT NULL); CREATE TABLE IF NOT EXISTS demo_resources(kind TEXT NOT NULL, external_id TEXT NOT NULL, data TEXT NOT NULL, PRIMARY KEY(kind,external_id)); CREATE TABLE IF NOT EXISTS demo_claim_ledger(command_id TEXT PRIMARY KEY, fingerprint TEXT NOT NULL, command TEXT NOT NULL, worker_id TEXT NOT NULL, lease_token TEXT NOT NULL, reported INTEGER NOT NULL DEFAULT 0); CREATE TABLE IF NOT EXISTS demo_command_ledger(command_id TEXT PRIMARY KEY, fingerprint TEXT NOT NULL, command TEXT NOT NULL, lease_token TEXT NOT NULL, outcome TEXT NOT NULL, reported INTEGER NOT NULL DEFAULT 0);`); } close() { this.db.close(); } seed({ rooms = [], assignments = [], services = [], projects = [], people = [], visits = [], replacements = [], technician_queue = null }) { this.db.exec('BEGIN IMMEDIATE'); try { for (const [kind, rows] of [['room', rooms], ['assignment', assignments], ['service', services], ['project', projects], ['person', people], ['visit', visits], ['replacement', replacements], ['queue', technician_queue ? [{...technician_queue,external_id:'main'}] : []]]) for (const row of rows) { const previous = this.#get(kind, row.external_id); if (previous && previous.source_version >= row.source_version && JSON.stringify(stable(previous)) !== JSON.stringify(stable(row))) throw new Error('DEMO_SEED_VERSION_CONFLICT'); this.#put(kind, row); } this.db.exec('COMMIT'); } catch (error) { this.db.exec('ROLLBACK'); throw error; } } #get(kind, externalId) { const row = this.db.prepare('SELECT data FROM demo_resources WHERE kind=? AND external_id=?').get(kind, externalId); return row ? JSON.parse(row.data) : null; } #put(kind, row) { this.db.prepare('INSERT INTO demo_resources VALUES(?,?,?) ON CONFLICT(kind,external_id) DO UPDATE SET data=excluded.data').run(kind, row.external_id, JSON.stringify(row)); } lookup(command) { const row = this.db.prepare('SELECT * FROM demo_command_ledger WHERE command_id=?').get(command.command_id); if (!row) return null; if (row.fingerprint !== fingerprint(command)) throw new Error('DEMO_COMMAND_REUSED'); return { lease_token: row.lease_token, ...JSON.parse(row.outcome) }; } prepareClaim(command, workerId) { const row = this.db.prepare('SELECT * FROM demo_claim_ledger WHERE command_id=?').get(command.command_id); if (row) { if (row.fingerprint !== fingerprint(command)) throw new Error('DEMO_COMMAND_REUSED'); return { command: JSON.parse(row.command), worker_id: row.worker_id, lease_token: row.lease_token }; } const leaseToken = createLeaseToken(); // This committed insert precedes ANY network claim, including a lost claim response. this.db.prepare('INSERT INTO demo_claim_ledger(command_id,fingerprint,command,worker_id,lease_token) VALUES(?,?,?,?,?)').run(command.command_id, fingerprint(command), JSON.stringify(command), workerId, leaseToken); return { command, worker_id: workerId, lease_token: leaseToken }; } unreportedClaims() { return this.db.prepare('SELECT * FROM demo_claim_ledger WHERE reported=0 ORDER BY rowid LIMIT 50').all().map(row => ({ command: JSON.parse(row.command), worker_id: row.worker_id, lease_token: row.lease_token })); } markReported(commandId) { this.db.prepare('UPDATE demo_command_ledger SET reported=1 WHERE command_id=?').run(commandId); this.db.prepare('UPDATE demo_claim_ledger SET reported=1 WHERE command_id=?').run(commandId); } notExecuted(command, leaseToken) { const saved = this.lookup(command); if (saved) return saved; // In THIS demo only, no outcome proves no mutation: both are one SQLite transaction. // A vendor using a different business database MUST query that system before reporting. const outcome = { result_id: `demo-noexecute:${command.command_id}`, status: 'failed', error: { code: 'DEMO_NOT_EXECUTED', message: '本地演示数据库确认业务未执行。' } }; this.db.prepare('INSERT INTO demo_command_ledger(command_id,fingerprint,command,lease_token,outcome) VALUES(?,?,?,?,?)').run(command.command_id, fingerprint(command), JSON.stringify(command), leaseToken, JSON.stringify(outcome)); return { lease_token: leaseToken, ...outcome }; } executionReceipt(commandId) { const row=this.db.prepare('SELECT receipt FROM demo_execution_receipts WHERE command_id=?').get(commandId); return row?JSON.parse(row.receipt):null; } currentState() { return Object.fromEntries([['rooms','room'],['visits','visit'],['assignments','assignment'],['services','service'],['replacements','replacement']].map(([key,kind])=>[key,this.db.prepare('SELECT data FROM demo_resources WHERE kind=?').all(kind).map(row=>JSON.parse(row.data))])); } execute(command, leaseToken) { const startedAt=this.now(); this.db.exec('BEGIN IMMEDIATE'); try { const saved = this.lookup(command); if (saved) { this.db.exec('COMMIT'); return saved; } const target = this.#get(command.target.type, command.target.external_id); const source = target && command.target.type === 'replacement' ? this.#get(target.source_type,target.source_external_id) : target; const room = command.target.type === 'room' ? target : source && this.#get('room',source.room_external_id); const fail = code => ({ result_id: `demo-result:${command.command_id}`, status: 'failed', error: { code, message: '本地演示数据不满足操作条件。' } }); let outcome; if (!target || target.source_version !== command.target.source_version) outcome = fail('STALE_TARGET'); else if (!room) outcome = fail('DEMO_ROOM_MISSING'); else if (['assignment.create','replacement.request','replacement.approve','room.clean'].includes(command.action)) outcome = executeWorkflow(command,target,(kind,id)=>this.#get(kind,id),(kind,row)=>this.#put(kind,row),kind=>this.db.prepare('SELECT data FROM demo_resources WHERE kind=?').all(kind).map(row=>JSON.parse(row.data))); else if (command.action === 'service.start' && target.status === 'pending') { const project = this.#get('project', command.params.project_external_id || target.project_external_id); if (!project?.active || project.extension || command.params.project_external_id && project.source_version !== command.params.project_source_version) outcome = fail('PROJECT_UNAVAILABLE'); else { const assignment = { ...target, source_version: target.source_version + 1, status: 'started' }; const service = { external_id: `demo-service:${command.command_id}`, source_version: 1, assignment_external_id: target.external_id, room_external_id: target.room_external_id, person_external_id: target.person_external_id, project_external_id: project.external_id, visit_external_id: target.visit_external_id, status: 'running', started_at: command.created_at || 1, ended_at: null, minutes: project.minutes, items: [{ project_external_id: project.external_id, minutes: project.minutes, price_minor: project.price_minor, quantity: 1 }] }; this.#put('assignment', assignment); this.#put('service', service); outcome = { result_id: `demo-result:${command.command_id}`, status: 'succeeded', state: { assignments: [assignment], services: [service] } }; } } else if (command.action === 'service.stop' && target.status === 'running') { const service = { ...target, source_version: target.source_version + 1, status: 'ended', ended_at: Math.max(command.created_at || 1, target.started_at + 1) }; this.#put('service', service); outcome = { result_id: `demo-result:${command.command_id}`, status: 'succeeded', state: { services: [service] } }; } else if (command.action === 'service.extend' && target.status === 'running') { const project = this.#get('project', command.params.project_external_id); if (!project?.active || !project.extension || project.source_version !== command.params.project_source_version || target.minutes + project.minutes > 1440) outcome = fail('PROJECT_UNAVAILABLE'); else { const service = { ...target, source_version: target.source_version + 1, minutes: target.minutes + project.minutes, items: [...(target.items || []), { project_external_id: project.external_id, minutes: project.minutes, price_minor: project.price_minor, quantity: 1 }] }; this.#put('service', service); outcome = { result_id: `demo-result:${command.command_id}`, status: 'succeeded', state: { services: [service] } }; } } else if (command.action === 'assignment.reject' && target.status === 'pending') { const assignment = { ...target, source_version: target.source_version + 1, status: 'rejected' }; this.#put('assignment', assignment); outcome = { result_id: `demo-result:${command.command_id}`, status: 'succeeded', state: { assignments: [assignment] } }; } else outcome = fail('UNSUPPORTED_DEMO_OPERATION'); if (outcome.status === 'succeeded' && !outcome.state.rooms && command.action !== 'replacement.request') { // These are demo-system rules, not MoShi fees/room inference. A real adapter uploads its system's actual room state. const updatedRoom = { ...room, source_version: room.source_version + 1, status: ['assignment.create','replacement.approve'].includes(command.action) ? 'pending' : command.action === 'service.stop' ? 'unpaid' : command.action === 'assignment.reject' ? 'idle' : 'serving' }; this.#put('room', updatedRoom); outcome.state.rooms = [updatedRoom]; } if(outcome.status==='succeeded') { const receipt=makeExecutionReceipt(command,outcome.state,{transactionId:'demo-tx:'+command.command_id,startedAt,executedAt:this.now()}); this.db.prepare('INSERT INTO demo_execution_receipts VALUES(?,?)').run(command.command_id,JSON.stringify(receipt)); } this.db.prepare('INSERT INTO demo_command_ledger(command_id,fingerprint,command,lease_token,outcome) VALUES(?,?,?,?,?)').run(command.command_id, fingerprint(command), JSON.stringify(command), leaseToken, JSON.stringify(outcome)); this.db.exec('COMMIT'); return { lease_token: leaseToken, ...outcome }; } catch (error) { this.db.exec('ROLLBACK'); throw error; } } } /** One bounded poll. Every failed request stops; a caller chooses when to query again. */ export async function runVendorOnce(client, adapter, { workerId = 'local-demo-worker' } = {}) { const response = await client.commands({ limit: 50 }); const summary = []; const records = new Map(adapter.unreportedClaims().map(record => [record.command.command_id, record])); for (const pending of response.commands) if (!records.has(pending.command_id)) records.set(pending.command_id, adapter.prepareClaim(pending, workerId)); for (const record of records.values()) { const current = (await client.command(record.command.command_id)).command; let saved = adapter.lookup(current); if (['succeeded', 'failed'].includes(current.status)) { if (saved && current.status !== saved.status) throw new Error('DEMO_OUTCOME_CONFLICT'); adapter.markReported(current.command_id); summary.push({ command_id: current.command_id, status: current.status }); continue; } if (!saved && current.status === 'unknown') saved = adapter.notExecuted(current, record.lease_token); if (!saved) { if (!['queued', 'claimed'].includes(current.status)) throw new Error('DEMO_INCONSISTENT_SERVER_STATE'); const claim = await client.claim(current.command_id, record.worker_id, record.lease_token); saved = adapter.execute(claim.command, record.lease_token); } const receipt=current.status==='unknown'&&saved.status==='succeeded'?adapter.executionReceipt(current.command_id):null; // Current state and historical evidence are separate. Never replay old state. if(receipt) { const state=adapter.currentState(); const version=createHash('sha256').update(JSON.stringify(stable(state))).digest('hex'); await client.syncState({request_id:'demo-current:'+version,...state}); } const result = await client.report(current.command_id, { ...saved, ...(current.status === 'unknown' ? { reconciliation: true } : {}), ...(receipt?{state:{},execution_receipt:receipt}:{}) }); if (['succeeded', 'failed'].includes(result.status)) adapter.markReported(current.command_id); summary.push({ command_id: current.command_id, status: result.status }); } return summary; } if (process.argv[1] && import.meta.url === pathToFileURL(process.argv[1]).href) { if (!process.argv.includes('--once')) throw new Error('示例仅支持 --once;禁止使用无限自动执行循环。'); const adapter = new DemoAdapter(process.env.MOSHI_DEMO_LEDGER || './moshi-demo.sqlite'); try { const client = new VendorClient({ baseUrl: process.env.MOSHI_PARTNER_URL, apiKey: process.env.MOSHI_PARTNER_KEY }); console.log(JSON.stringify(await runVendorOnce(client, adapter), null, 2)); } finally { adapter.close(); } }