Sage/lib/data/local/hive_database.dart

import 'package:hive_flutter/hive_flutter.dart';
import '../../features/inventory/models/food_item.dart';
import '../../features/settings/models/app_settings.dart';
import '../../features/settings/models/household.dart';

/// Singleton class to manage Hive database
class HiveDatabase {
  static bool _initialized = false;

  /// Initialize Hive
  static Future<void> init() async {
    if (_initialized) return;

    await Hive.initFlutter();

    // Register adapters
    Hive.registerAdapter(FoodItemAdapter());
    Hive.registerAdapter(LocationAdapter());
    Hive.registerAdapter(ExpirationStatusAdapter());
    Hive.registerAdapter(AppSettingsAdapter());
    Hive.registerAdapter(HouseholdAdapter());

    _initialized = true;
  }

  /// Get the food items box
  static Future<Box<FoodItem>> getFoodBox() async {
    if (!Hive.isBoxOpen('foodItems')) {
      return await Hive.openBox<FoodItem>('foodItems');
    }
    return Hive.box<FoodItem>('foodItems');
  }

  /// Get the settings box
  static Future<Box<AppSettings>> getSettingsBox() async {
    if (!Hive.isBoxOpen('appSettings')) {
      return await Hive.openBox<AppSettings>('appSettings');
    }
    return Hive.box<AppSettings>('appSettings');
  }

  /// Get or create app settings
  static Future<AppSettings> getSettings() async {
    final box = await getSettingsBox();
    if (box.isEmpty) {
      final settings = AppSettings();
      await box.add(settings);
      return settings;
    }
    return box.getAt(0)!;
  }

  /// Get the households box
  static Future<Box<Household>> getHouseholdsBox() async {
    if (!Hive.isBoxOpen('households')) {
      return await Hive.openBox<Household>('households');
    }
    return Hive.box<Household>('households');
  }

  /// Get household by ID
  static Future<Household?> getHousehold(String id) async {
    final box = await getHouseholdsBox();
    return box.values.firstWhere(
      (h) => h.id == id,
      orElse: () => throw Exception('Household not found'),
    );
  }

  /// Save household
  static Future<void> saveHousehold(Household household) async {
    final box = await getHouseholdsBox();
    await box.put(household.id, household);
  }

  /// Clear all food items
  static Future<void> clearAll() async {
    final box = await getFoodBox();
    await box.clear();
  }

  /// Clear ALL data (food, settings, households)
  static Future<void> clearAllData() async {
    final foodBox = await getFoodBox();
    final settingsBox = await getSettingsBox();
    final householdsBox = await getHouseholdsBox();

    await foodBox.clear();
    await settingsBox.clear();
    await householdsBox.clear();

    print('✅ All data cleared from Hive');
  }

  /// Close all boxes
  static Future<void> closeAll() async {
    await Hive.close();
  }
}