using Npgsql;

namespace NpgsqlRest;

/// <summary>
/// Helper class for logging SQL command executions at Trace level.
/// Use this when a command is about to be executed.
/// For configuration logging (endpoints, SQL command templates), use regular Logger.LogDebug.
/// </summary>
public static class CommandLogger
{
    /// <summary>
    /// Logs a command execution at Trace level. Call this immediately before executing a command.
    /// </summary>
    /// <param name="command">The NpgsqlCommand to log.</param>
    /// <param name="logger">The logger to use.</param>
    /// <param name="name">The name/context of the operation (e.g., "PasskeyAuth.Login", "RoutineSource").</param>
    public static void LogCommand(NpgsqlCommand command, ILogger? logger, string name)
    {
        if (logger?.IsEnabled(LogLevel.Trace) != true)
        {
            return;
        }

        var sb = StringBuilderPool.Rent();
        try
        {
            for (int i = 0; i < command.Parameters.Count; i++)
            {
                sb.Append('$');
                sb.Append(i + 1);
                sb.Append('=');
                sb.AppendLine(PgConverters.SerializeDatbaseObject(command.Parameters[i].Value));
            }

            sb.Append(command.CommandText);
            logger.LogTrace("{name}:\n{query}", name, sb.ToString());
        }
        finally
        {
            StringBuilderPool.Return(sb);
        }
    }

    /// <summary>
    /// Extension method for NpgsqlCommand to log command execution at Trace level.
    /// Uses the static Logger from NpgsqlRestOptions.
    /// </summary>
    /// <param name="command">The NpgsqlCommand to log.</param>
    /// <param name="name">The name/context of the operation.</param>
    public static void LogCommand(this NpgsqlCommand command, string name)
    {
        LogCommand(command, NpgsqlRestOptions.Logger, name);
    }
}