← back to Tk11438 Postgres Migration
ken-proof.cjs
16 lines
// Only installed driver SELECT probes; never import/start Ken or its jobs.
const fs=require('fs'),path=require('path');
const {Client}=require('/Users/macstudio3/Projects/Ken/kalshi-dash/node_modules/pg');
const checks=[];
(async()=>{
for(const database of ['ken','bertha_betting']){
const c=new Client({host:'/tmp',database,user:'macstudio3',application_name:'TK-11438-ken-preflight',connectionTimeoutMillis:3000,options:'-c default_transaction_read_only=on -c statement_timeout=3000'});
try{await c.connect();const identity=(await c.query("SELECT current_database() database,current_user role,inet_client_addr() IS NULL socket,current_setting('transaction_read_only') readonly")).rows[0];checks.push({database,test:'installed-driver-socket',verdict:identity.database===database&&identity.socket&&identity.readonly==='on'?'PASS':'FAIL',identity});}
catch(e){checks.push({database,verdict:'FAIL',code:e.code});}finally{await c.end().catch(()=>{});}
const bad=new Client({host:'/tmp/TK-11438-missing-socket',database,user:'macstudio3',connectionTimeoutMillis:1000});
try{await bad.connect();checks.push({database,test:'no-fallback',verdict:'FAIL'});}catch(e){checks.push({database,test:'no-fallback',verdict:e.code==='ENOENT'?'PASS':'FAIL',code:e.code});}finally{await bad.end().catch(()=>{});}
}
fs.writeFileSync(path.join(__dirname,'verification/ken-driver-proof.json'),JSON.stringify({timestamp:new Date().toISOString(),checks,limits:'Driver preflight only; app and scheduled operational journeys have not been migrated or executed.'},null,2)+'\n');
console.log(JSON.stringify(checks));if(checks.some(x=>x.verdict!=='PASS'))process.exitCode=1;
})().catch(e=>{console.error(e.code||e.name);process.exitCode=1;});