upgrade-infrastructure.mjs 2.3 KB

123456789
  1. // Upgrade only derived helpers, after isolated rollback/concurrency verification.
  2. import fs from 'node:fs';import {createHash} from 'node:crypto';import {withGateway} from './server-util.mjs';
  3. const root='/Users/mac/.local/state/xiaoshu/cloud-releases/2026-11-10-admin-speed-round2';
  4. let sql=fs.readFileSync('scripts/sql/payroll-incremental-reads.sql','utf8').split('-- Installation locks source writers')[0];
  5. sql+=`UPDATE "PayrollReadDigestMeta" m SET signature=xs_payroll_digest_signature(v.tab) FROM (VALUES ('common','CommonModel'),('appointment','CourseAppointment'),('lesson','LessonRecord'),('review','MemoryPracticeRecord')) v(kind,tab) WHERE m.kind=v.kind;`;
  6. sql+=['payroll-source-fast.sql','payroll-cutoff-fast.sql','payroll-verified-preview.sql'].map(f=>fs.readFileSync('scripts/sql/'+f,'utf8')).join('\n');
  7. const expected=JSON.parse(fs.readFileSync(root+'/original-definitions.json')),defSql="SELECT proname,pg_get_functiondef(p.oid) AS definition FROM pg_proc p JOIN pg_namespace n ON n.oid=p.pronamespace WHERE n.nspname='public' AND proname IN ('xs_payroll_sources','xs_payroll_source_version','xs_payroll_cutoff_snapshot','xs_payroll_cutoff_conflicts') ORDER BY proname";
  8. async function run(){return Psql.tx(async tx=>{await tx.none("SET LOCAL lock_timeout='5s';SET LOCAL statement_timeout='60s';LOCK TABLE \"CommonModel\",\"CourseAppointment\",\"LessonRecord\",\"MemoryPracticeRecord\" IN SHARE ROW EXCLUSIVE MODE;");if(!(await tx.one('SELECT xs_payroll_digest_ready() ready')).ready)throw Error('Existing row digest must be healthy before metadata upgrade');if(JSON.stringify(await tx.query(defSql))!==JSON.stringify(expected))throw Error('Authoritative functions changed');await tx.none(sql);if(!(await tx.one('SELECT xs_payroll_digest_ready() ready')).ready)throw Error('Digest metadata upgrade failed');return{ready:true,originalFunctionsUnchanged:true};});}
  9. const receipt=await withGateway('const sql='+JSON.stringify(sql)+';const expected='+JSON.stringify(expected)+';const defSql='+JSON.stringify(defSql)+';'+run.toString(),call=>call({}));fs.writeFileSync(root+'/infrastructure-v2.sql',sql,{mode:0o600});fs.writeFileSync(root+'/infrastructure-v2-receipt.json',JSON.stringify({at:new Date().toISOString(),sha256:createHash('sha256').update(sql).digest('hex'),...receipt}),{mode:0o600});console.log(JSON.stringify(receipt));