import { createClient } from '@libsql/client';
import { drizzle } from 'drizzle-orm/libsql';
import { migrate } from 'drizzle-orm/libsql/migrator';
import * as schema from './schema';

export async function createTestDb() {
	const client = createClient({ url: ':memory:' });
	const db = drizzle(client, { schema });

	await migrate(db, { migrationsFolder: './drizzle' });

	return { db, client };
}

export type TestDb = Awaited<ReturnType<typeof createTestDb>>;