using System.Data.Common;
using Dotnet.Samples.AspNetCore.WebApi.Data;
using Dotnet.Samples.AspNetCore.WebApi.Migrations;
using Microsoft.Data.Sqlite;
using Microsoft.EntityFrameworkCore;
using Microsoft.EntityFrameworkCore.Migrations;

namespace Dotnet.Samples.AspNetCore.WebApi.Tests.Utilities
{
    /// <summary>
    /// A Fake is a working implementation that's simpler than the real one.
    /// It usually has some "real" logic but is not suitable for production
    /// (e.g., an in‑memory database instead of a full SQL Server). Fakes are
    /// useful when you need behavior that's closer to reality but still want
    /// to avoid external dependencies.
    /// </summary>
    public static class DatabaseFakes
    {
        /// <summary>
        /// Creates an in-memory SQLite connection and DbContext options for testing.
        /// The connection remains open for the lifetime of the test.
        /// </summary>
        /// <returns>A tuple containing the SQLite connection and DbContext options.</returns>
        public static (DbConnection, DbContextOptions<PlayerDbContext>) CreateSqliteConnection()
        {
            var dbConnection = new SqliteConnection("Filename=:memory:");
            dbConnection.Open();

            var dbContextOptions = new DbContextOptionsBuilder<PlayerDbContext>()
                .UseSqlite(dbConnection)
                .ReplaceService<IMigrationsAssembly, ProviderSpecificMigrationsAssembly>()
                .Options;

            return (dbConnection, dbContextOptions);
        }

        /// <summary>
        /// Creates a PlayerDbContext instance with the specified options.
        /// </summary>
        /// <param name="dbContextOptions">The DbContext options to use.</param>
        /// <returns>A new PlayerDbContext instance.</returns>
        public static PlayerDbContext CreateDbContext(
            DbContextOptions<PlayerDbContext> dbContextOptions
        )
        {
            return new PlayerDbContext(dbContextOptions);
        }

        /// <summary>
        /// Applies all pending EF Core migrations to the test database, including seed data.
        /// Extension method for PlayerDbContext.
        /// </summary>
        /// <param name="context">The PlayerDbContext instance.</param>
        public static async Task MigrateAsync(this PlayerDbContext context)
        {
            await context.Database.MigrateAsync();
        }
    }
}