// Base PostgreSQL éphémère pour les tests d'intégration : toveli_test (migrations appliquées par `pnpm db:migrate` avec DATABASE_URL=…/toveli_test).
process.env.DATABASE_URL = process.env.TEST_DATABASE_URL ?? "postgresql://toveli_app:toveli_dev@127.0.0.1:5432/toveli_test";
process.env.OTP_HMAC_SECRET = "test-otp-secret-0123456789abcdef";
process.env.SESSION_SECRET = "test-session-secret-0123456789abcdef";
process.env.APP_BASE_URL = "http://localhost:3000";
process.env.STORAGE_DIR = "/tmp/toveli-test-media";
import { sql } from "drizzle-orm";
import { db, rawSql } from "../../src/db/client";
export async function resetDb() {
  await db().execute(sql`truncate users, user_profiles, otp_challenges, sessions, user_roles, properties, listings, listing_media, listing_versions, listing_claims, favorites, saved_searches, email_deliveries, inquiries, messages, viewing_requests, reports, moderation_actions, audit_events, rate_limits restart identity cascade`);
}
export async function closeDb() { await rawSql().end({ timeout: 2 }); }