Skip to content

Garry's Opinionated OpenClaw/Hermes Agent Brain

TypeScript
3.4 KB
Raw Blame
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();},
  };
}