lib/presentation/providers/database_provider.dart

import 'package:flutter_riverpod/flutter_riverpod.dart';
import 'package:isar/isar.dart';
import 'package:path_provider/path_provider.dart';
import '../../data/models/exercise.dart';
import '../../data/models/set_entry.dart';
import '../../data/models/workout.dart';
import '../../data/models/workout_exercise.dart';

final databaseProvider = FutureProvider<Isar>((ref) async {
  final dir = await getApplicationDocumentsDirectory();
  
  final isar = await Isar.open(
    [
      ExerciseSchema,
      WorkoutSchema,
      WorkoutExerciseSchema,
      SetEntrySchema,
    ],
    directory: dir.path,
    name: 'trainlog_db',
  );
  
  return isar;
});