import { getDatabase, generateId } from '../database';
import type { EquitySnapshot } from '../../types';

export class EquityRepository {
  async create(snapshot: Omit<EquitySnapshot, 'id'>): Promise<EquitySnapshot> {
    const db = await getDatabase();
    const id = generateId();
    await db.runAsync(
      `INSERT INTO equity_snapshots (id, household_id, date, income_a, income_b, common_charges,
       domestic_hours_a, domestic_hours_b, domestic_hourly_rate, ratio_a, ratio_b, adjusted_ratio_a, adjusted_ratio_b)
       VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)`,
      [id, snapshot.householdId, snapshot.date, snapshot.incomeA, snapshot.incomeB, snapshot.commonCharges,
       snapshot.domesticHoursA, snapshot.domesticHoursB, snapshot.domesticHourlyRate,
       snapshot.ratioA, snapshot.ratioB, snapshot.adjustedRatioA, snapshot.adjustedRatioB]
    );
    return { id, ...snapshot };
  }

  async getByHousehold(householdId: string): Promise<EquitySnapshot[]> {
    const db = await getDatabase();
    const rows = await db.getAllAsync<any>(
      'SELECT * FROM equity_snapshots WHERE household_id = ? ORDER BY date DESC',
      [householdId]
    );
    return rows.map(this.mapRow);
  }

  async getLatest(householdId: string): Promise<EquitySnapshot | null> {
    const db = await getDatabase();
    const row = await db.getFirstAsync<any>(
      'SELECT * FROM equity_snapshots WHERE household_id = ? ORDER BY date DESC LIMIT 1',
      [householdId]
    );
    return row ? this.mapRow(row) : null;
  }

  async deleteAll(householdId: string): Promise<void> {
    const db = await getDatabase();
    await db.runAsync('DELETE FROM equity_snapshots WHERE household_id = ?', [householdId]);
  }

  private mapRow(row: any): EquitySnapshot {
    return {
      id: row.id,
      householdId: row.household_id,
      date: row.date,
      incomeA: row.income_a,
      incomeB: row.income_b,
      commonCharges: row.common_charges,
      domesticHoursA: row.domestic_hours_a,
      domesticHoursB: row.domestic_hours_b,
      domesticHourlyRate: row.domestic_hourly_rate,
      ratioA: row.ratio_a,
      ratioB: row.ratio_b,
      adjustedRatioA: row.adjusted_ratio_a,
      adjustedRatioB: row.adjusted_ratio_b,
    };
  }
}
