ZZZ Digital Lab

Back to Google Sheets CRM repair

tests/run.cjs

'use strict';
const assert = require('node:assert/strict');
const fs = require('node:fs');
const path = require('node:path');
const {createHarness} = require('../lib/mock.cjs');
const cases = [];
function test(name, fn) { cases.push({name, fn}); }
function goodInbox(count = 5) {
  return [['submission_id','email','name','submitted_at','source'], ...Array.from({length:count},(_,i) => [`B${i}`, `user${i}@example.test`, `Synthetic ${i}`, '2026-11-18T00:00:00Z','fixture'])];
}
test('before: replay duplicates records and erases owner columns', () => {
  const h = createHarness({before: true, inbox: goodInbox(2)}); h.broken(); h.broken();
  assert.equal(h.sheets.Leads.data.length, 6); assert.equal(h.sheets.Leads.data[1][6], ''); assert.equal(h.logs.length, 0);
});
test('before: ambiguous calendar date is guessed from host parser', () => {
  const data = goodInbox(1); data[1][3] = '03/04/2026'; const h = createHarness({before:true, inbox:data}); h.broken();
  assert.equal(h.sheets.Leads.data[2][3], new Date('03/04/2026').toISOString());
});
test('before: one-row writes exceed a simulated service quota', () => {
  const h = createHarness({before:true, inbox:goodInbox(8), writeQuota:2}); assert.throws(() => h.broken(), /SERVICE_QUOTA/);
  assert.equal(h.sheets.Leads.data.length, 4);
});
test('after: CSV fixtures deduplicate, reject 3 bad rows, preserve notes/formula', () => {
  const h = createHarness(); const result = h.run({dryRun:false});
  assert.equal(result.inserted, 3); assert.equal(result.duplicates, 2); assert.equal(result.rejected, 3);
  assert.deepEqual(h.sheets.Leads.data[1].slice(6), ['Keep owner note','=40+2']);
  assert.equal(h.sheets.Leads.data.length, 5); assert.equal(h.metrics.writes,1);
});
test('after: offset and configured timezone produce exact UTC instants', () => {
  const h = createHarness(); h.run({dryRun:false});
  assert.equal(h.sheets.Leads.data[2][3], '2026-11-18T04:30:00Z');
  assert.equal(h.sheets.Leads.data[3][3], '2026-11-18T01:00:00Z');
});
test('after: default dry run changes neither sheets nor properties', () => {
  const h = createHarness(); const original = JSON.stringify(h.sheets.Leads.data); const r=h.run();
  assert.equal(r.dryRun,true); assert.equal(r.inserted,3); assert.equal(JSON.stringify(h.sheets.Leads.data),original);
  assert.equal(h.metrics.writes,0); assert.deepEqual(h.properties,{});
});
test('after: double-fired trigger and full cursor reset create no duplicates', () => {
  const h=createHarness(); h.run({dryRun:false}); h.run({dryRun:false});
  h.properties.synthetic_crm_cursor_v1='0'; const r=h.run({dryRun:false});
  assert.equal(r.inserted,0); assert.equal(h.sheets.Leads.data.length,5);
});
test('after: competing execution gets LOCK_BUSY without writes', () => {
  const h=createHarness({locked:true}); assert.equal(h.run({dryRun:false}).status,'locked'); assert.equal(h.metrics.writes,0);
});
test('after: lock stays held through writes and releases on completion', () => {
  let h, nested; h=createHarness({inbox:goodInbox(1), onWrite:() => { nested=h.run({dryRun:false}); }});
  h.run({dryRun:false}); assert.equal(nested.status,'locked'); assert.equal(h.metrics.releases,1);
});
test('after: quota failure leaves checkpoint unchanged and is safely replayable', () => {
  const h=createHarness({inbox:goodInbox(4),failWrites:1}); assert.throws(() => h.run({dryRun:false}),/SERVICE_QUOTA/);
  assert.deepEqual(h.properties,{}); assert.equal(h.metrics.releases,1);
  assert.equal(h.run({dryRun:false}).inserted,4); assert.equal(h.sheets.Leads.data.length,6);
});
test('after: crash after write but before checkpoint recovers by scanning output', () => {
  const h=createHarness({inbox:goodInbox(4),failProperties:1}); assert.throws(() => h.run({dryRun:false}),/PROPERTY_QUOTA/);
  assert.equal(h.sheets.Leads.data.length,6); assert.equal(h.run({dryRun:false}).inserted,0); assert.equal(h.metrics.writes,1);
});
test('after: bounded chunks use two writes for 80 rows and resume next 20', () => {
  const h=createHarness({inbox:goodInbox(100),writeQuota:3});
  const r=h.run({dryRun:false,batchSize:40,maxRowsPerRun:80}); assert.equal(r.status,'deferred'); assert.equal(r.inserted,80); assert.equal(h.metrics.writes,2);
  assert.equal(h.run({dryRun:false}).inserted,20); assert.equal(h.metrics.writes,3); assert.equal(h.sheets.Leads.data.length,102);
});
test('after: elapsed time budget defers with a valid checkpoint', () => {
  const h=createHarness({inbox:goodInbox(10),clockStepMs:1000}); const r=h.run({dryRun:false,maxRuntimeMs:1500,batchSize:2});
  assert.equal(r.status,'deferred'); assert.equal(r.scanned,2); assert.equal(h.properties.synthetic_crm_cursor_v1,'2');
});
test('after: header mismatch and oversized input fail closed', () => {
  const h=createHarness(); h.sheets.Inbox.data[0][1]='wrong'; assert.throws(() => h.run({dryRun:false}),/SCHEMA_MISMATCH/); assert.equal(h.metrics.writes,0);
  const large=createHarness({inbox:goodInbox(6)}); assert.throws(() => large.run({maxReadRows:5}),/SIZE_LIMIT/); assert.equal(large.metrics.writes,0);
});
test('after: conflicting submission IDs and preexisting duplicates are explicit', () => {
  const inbox=goodInbox(2); inbox[2][0]=inbox[1][0]; const h=createHarness({inbox}); const r=h.run({dryRun:false});
  assert.equal(r.inserted,1); assert.equal(r.rejected,1); assert.ok(h.logs.some(l=>l.code==='SUBMISSION_CONFLICT'));
  const bad=createHarness(); bad.sheets.Leads.data.push([...bad.sheets.Leads.data[1]]);
  assert.throws(() => bad.run({dryRun:false}),/EXISTING_DUPLICATE_OR_INVALID/); assert.equal(bad.metrics.writes,0);
});
test('after: formula injection is neutralized and structured logs omit contact data', () => {
  const h=createHarness(); h.run({dryRun:false}); assert.ok(h.sheets.Leads.data[4][2].startsWith("'="));
  assert.ok(h.logs.some(l=>l.event==='ROW_REJECTED')); assert.ok(h.logs.some(l=>l.event==='RUN_FINISHED'));
  const inbox=goodInbox(1); inbox[1][1]='=malicious@example.test'; const unsafe=createHarness({inbox}); assert.equal(unsafe.run({dryRun:false}).rejected,1); assert.equal(unsafe.metrics.writes,0);
  assert.ok(!JSON.stringify(h.logs).includes('@example.test')); assert.ok(!JSON.stringify(h.logs).includes('Ava Stone'));
});
test('after: invalid config and corrupt cursor cause no data writes', () => {
  const h=createHarness(); assert.throws(()=>h.run({batchSize:0}),/CONFIG_INVALID/);
  const bad=createHarness({properties:{synthetic_crm_cursor_v1:'NaN'}}); assert.throws(()=>bad.run({dryRun:false}),/CURSOR_INVALID/); assert.equal(bad.metrics.writes,0);
});
let failed=0; const results=[];
for (const {name,fn} of cases) {
  try { fn(); results.push({name,status:'PASS'}); console.log('PASS '+name); }
  catch(error) { failed++; results.push({name,status:'FAIL',message:error.message}); console.log('FAIL '+name+'\n'+error.stack); }
}
const report={synthetic:true,scope:'Node VM with minimal service mocks; not a live Google deployment',passed:cases.length-failed,failed,results};
fs.mkdirSync(path.join(__dirname,'../evidence'),{recursive:true});
fs.writeFileSync(path.join(__dirname,'../evidence/tests.json'),JSON.stringify(report,null,2)+'\n');
console.log(`RESULT ${report.passed}/${cases.length} passed; ${failed} failed`); process.exitCode=failed?1:0;