import { getDatabase } from '../database';
import type { Settings } from '../../types';

const DEFAULTS: Settings = {
  locale: 'fr',
  biometricEnabled: false,
  notificationsEnabled: true,
  reduceMotion: false,
  domesticHourlyRate: 18,
  currency: 'CAD',
};

export class SettingsRepository {
  async get<K extends keyof Settings>(key: K): Promise<Settings[K]> {
    const db = await getDatabase();
    const row = await db.getFirstAsync<{ value: string }>('SELECT value FROM settings WHERE key = ?', [key]);
    if (!row) return DEFAULTS[key];
    try {
      return JSON.parse(row.value);
    } catch {
      return row.value as any;
    }
  }

  async set<K extends keyof Settings>(key: K, value: Settings[K]): Promise<void> {
    const db = await getDatabase();
    const serialized = typeof value === 'string' ? value : JSON.stringify(value);
    await db.runAsync(
      'INSERT OR REPLACE INTO settings (key, value) VALUES (?, ?)',
      [key, serialized]
    );
  }

  async getAll(): Promise<Settings> {
    const db = await getDatabase();
    const rows = await db.getAllAsync<{ key: string; value: string }>('SELECT * FROM settings');
    const settings = { ...DEFAULTS };
    for (const row of rows) {
      try {
        (settings as any)[row.key] = JSON.parse(row.value);
      } catch {
        (settings as any)[row.key] = row.value;
      }
    }
    return settings;
  }

  async deleteAll(): Promise<void> {
    const db = await getDatabase();
    await db.runAsync('DELETE FROM settings');
  }

  async exportAll(): Promise<string> {
    const db = await getDatabase();
    const tables = ['users', 'households', 'incomes', 'expenses', 'budgets', 'equity_snapshots', 'domestic_work', 'settings', 'notifications'];
    const data: Record<string, any[]> = {};
    for (const table of tables) {
      try {
        data[table] = await db.getAllAsync(`SELECT * FROM ${table}`);
      } catch {
        data[table] = [];
      }
    }
    return JSON.stringify(data, null, 2);
  }

  async deleteAllData(): Promise<void> {
    const db = await getDatabase();
    const tables = ['notifications', 'equity_snapshots', 'domestic_work', 'expenses', 'budgets', 'incomes', 'households', 'users', 'settings'];
    for (const table of tables) {
      await db.runAsync(`DELETE FROM ${table}`);
    }
  }
}
