import { setupTestDatabase } from '../src/setup-db.js';

// Store a single test database instance
let globalTestDb = null;

// Setup the test database
export function setupTestDb() {
  if (!globalTestDb) {
    globalTestDb = setupTestDatabase();
  }
  return globalTestDb;
}

// Get the test database
export function getTestDb() {
  return globalTestDb;
}

// Cleanup test database
export function cleanupTestDb() {
  if (globalTestDb) {
    try {
      // Delete in correct order due to foreign keys
      globalTestDb.exec(`
        DELETE FROM mood_components;
        DELETE FROM mood;
        DELETE FROM users;
      `);
    } catch (err) {
      console.error('Error cleaning test DB:', err);
    }
  }
}