Garry's Opinionated OpenClaw/Hermes Agent Brain
TypeScript
import postgres from '#postgres'
import { randomUUID } from 'node:crypto';
import { PostgresEngine } from '../../src/core/postgres-engine.ts';
import { assertSafeE2eDatabaseUrl } from './db-guard.ts';
/** Permanent receipt IDs deliberately survive source deletion; use a fresh test brain. */
export async function isolatedPersistencePostgres(databaseUrl:string, connectionStyle:'instance'|'module'='instance', poolSize=4):Promise<{engine:PostgresEngine;databaseUrl:string;close:()=>Promise<void>}> {
assertSafeE2eDatabaseUrl(databaseUrl);
const database=`gbrain_test_persistence_${randomUUID().replace(/-/g,'')}`;
const admin=postgres(databaseUrl,{max:1,prepare:false});
await admin.unsafe(`CREATE DATABASE ${database}`);
const url=new URL(databaseUrl);url.pathname=`/${database}`;
const engine=new PostgresEngine();
const close=async()=>{await engine.disconnect();await admin.unsafe(`DROP DATABASE ${database} WITH (FORCE)`);await admin.end();};
try {await engine.connect({database_url:url.toString(),poolSize:connectionStyle==='module'?undefined:poolSize});await engine.initSchema();return{engine,databaseUrl:url.toString(),close};}
catch(error){await close();throw error;}
}
/** A fresh database in `encoding` with the C locale, no schema applied; `close` drops it. */
export async function encodedPostgres(databaseUrl:string, encoding:'UTF8'|'SQL_ASCII'|'LATIN1'):Promise<{engine:PostgresEngine;close:()=>Promise<void>}> {
assertSafeE2eDatabaseUrl(databaseUrl);
const database=`gbrain_test_encoding_${encoding.toLowerCase()}_${randomUUID().replace(/-/g,'')}`;
const admin=postgres(databaseUrl,{max:1,prepare:false});
await admin.unsafe(`CREATE DATABASE ${database} TEMPLATE template0 ENCODING '${encoding}' LC_COLLATE 'C' LC_CTYPE 'C'`);
const url=new URL(databaseUrl);url.pathname=`/${database}`;
const engine=new PostgresEngine();
const close=async()=>{await engine.disconnect();await admin.unsafe(`DROP DATABASE ${database} WITH (FORCE)`);await admin.end();};
try {await engine.connect({database_url:url.toString(),poolSize:4});return{engine,close};}
catch(error){await close();throw error;}
}
/**
* One migrated template per test file: each clone (CREATE DATABASE ... TEMPLATE) is its own fresh brain,
* so permanent receipt IDs never cross tests, without re-running every migration per test.
*/
export async function persistencePostgresTemplate(databaseUrl:string, poolSize=4, prepare?:(engine:PostgresEngine)=>Promise<void>):Promise<{clone:()=>Promise<{engine:PostgresEngine;close:()=>Promise<void>}>;dispose:()=>Promise<void>}> {
const template=await isolatedPersistencePostgres(databaseUrl);
try { await prepare?.(template.engine); } catch (error) { await template.close(); throw error; }
await template.engine.disconnect();
const name=new URL(template.databaseUrl).pathname.slice(1);
const admin=postgres(databaseUrl,{max:1,prepare:false});
let clones=0;
return {
clone:async()=>{
const database=`${name}_${clones++}`;
await admin.unsafe(`CREATE DATABASE ${database} TEMPLATE ${name}`);
const url=new URL(databaseUrl);url.pathname=`/${database}`;
const engine=new PostgresEngine();
const close=async()=>{await engine.disconnect();await admin.unsafe(`DROP DATABASE ${database} WITH (FORCE)`);};
try {await engine.connect({database_url:url.toString(),poolSize});return{engine,close};}
catch(error){await close();throw error;}
},
dispose:async()=>{await admin.end();await template.close();},
};
}