SPB Git forge

spb/toveli

Public
14commits 1branches 0releases
1.1 MBsize
maindefault branch
2 h agolast push
TypeScript 50.6% JavaScript 46.1% SQL 2.1% Shell 0.6% CSS 0.5%
1.0 KB · 13 lines typescript
Raw Blame History
1// 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).2process.env.DATABASE_URL = process.env.TEST_DATABASE_URL ?? "postgresql://toveli_app:toveli_dev@127.0.0.1:5432/toveli_test";3process.env.OTP_HMAC_SECRET = "test-otp-secret-0123456789abcdef";4process.env.SESSION_SECRET = "test-session-secret-0123456789abcdef";5process.env.APP_BASE_URL = "http://localhost:3000";6process.env.STORAGE_DIR = "/tmp/toveli-test-media";7import { sql } from "drizzle-orm";8import { db, rawSql } from "../../src/db/client";9export async function resetDb() {10  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`);11}12export async function closeDb() { await rawSql().end({ timeout: 2 }); }13