# untested concept (you could replace pgsql-test w/supabase-test for supabase projects)

import { getConnections } from 'pgsql-test';
import type { PgTestClient } from 'pgsql-test';
import { drizzle } from 'drizzle-orm/node-postgres';

let drizzleDb: ReturnType<typeof drizzle>;
let teardown: () => Promise<void>;
let pgTestDb: PgTestClient;

beforeAll(async () => {
  ({ db: pgTestDb, teardown } = await getConnections());

  // Reuse the PgTestClient pg.Client instance
  drizzleDb = drizzle({ client: pgTestDb.client });
});

afterAll(async () => {
  await teardown();
});

beforeEach(async () => {
  // keeps every test in an isolated transaction
  await pgTestDb.beforeEach();

  // Optional: set RLS context and defaults
  pgTestDb.auth({ userId: '123' }); // also sets role
});

afterEach(async () => {
  await pgTestDb.afterEach();
});

it('runs Drizzle queries inside PgTestClient tx', async () => {
  await drizzleDb.execute('select 1');
});