import { readFile } from 'node:fs/promises';
import postgres from 'postgres';

if (!process.env.DB_URL) throw new Error('DB_URL is required');
const client = postgres(process.env.DB_URL, { max: 1 });
try {
	await client.begin(async (tx) => {
		await tx.unsafe(await readFile(new URL('./foundation-migration.sql', import.meta.url), 'utf8'));
	});
	console.log('Foundation migration applied');
} finally {
	await client.end();
}