using System.Reflection;
using System.Text.Json;
using Sbroenne.ExcelMcp.CLI.Commands;
using Sbroenne.ExcelMcp.CLI.Infrastructure;
using Sbroenne.ExcelMcp.Core.Models.Actions;
using Spectre.Console.Cli;
using Xunit;
namespace Sbroenne.ExcelMcp.CLI.Tests.Unit;
[Trait("Layer", "CLI")]
[Trait("Category", "Unit")]
[Trait("Feature", "ActionValidation")]
[Trait("Speed", "Fast")]
public sealed class ActionValidatorTests
{
public static IEnumerable<object[]> ActionEnumTypes =>
[
[typeof(WorksheetAction)],
[typeof(WorksheetStyleAction)],
[typeof(RangeAction)],
[typeof(RangeEditAction)],
[typeof(RangeFormatAction)],
[typeof(RangeLinkAction)],
[typeof(TableAction)],
[typeof(PowerQueryAction)],
[typeof(PivotTableAction)],
[typeof(ChartAction)],
[typeof(ChartConfigAction)],
[typeof(ConnectionAction)],
[typeof(NamedRangeAction)],
[typeof(ConditionalFormatAction)],
[typeof(VbaAction)],
[typeof(DataModelAction)],
[typeof(DataModelRelAction)],
[typeof(SlicerAction)]
];
// Note: datamodelrel is MCP-only (not in CLI) - it's a sub-tool of datamodel
private static readonly string[] ExpectedCommands =
[
"sheet",
"range",
"table",
"powerquery",
"pivottable",
"chart",
"chartconfig",
"connection",
"namedrange",
"conditionalformat",
"vba",
"datamodel",
"slicer"
];
[Theory]
[MemberData(nameof(ActionEnumTypes))]
public void GetValidActions_ReturnsAllActionStrings(Type enumType)
{
var expected = GetExpectedActions(enumType);
var actual = GetActualActions(enumType);
Assert.Equal(expected, actual);
}
[Fact]
public void ListActionsCommand_AllCommands_ReturnsExpectedKeys()
{
var command = new ListActionsCommand();
var settings = new ListActionsCommand.Settings();
var context = new CommandContext(
Array.Empty<string>(),
new FakeRemainingArguments(),
"actions",
null);
var output = CaptureOutput(() => command.Execute(context, settings, CancellationToken.None));
using var document = JsonDocument.Parse(output);
Assert.True(document.RootElement.GetProperty("success").GetBoolean());
var commands = document.RootElement.GetProperty("commands");
foreach (var expected in ExpectedCommands)
{
Assert.True(commands.TryGetProperty(expected, out _), $"Missing command '{expected}'.");
}
}
private static string[] GetExpectedActions(Type enumType)
{
var actionMethod = typeof(ActionExtensions)
.GetMethods(BindingFlags.Public | BindingFlags.Static)
.First(m => m.Name == "ToActionString" && m.GetParameters().Length == 1 && m.GetParameters()[0].ParameterType == enumType);
var values = Enum.GetValues(enumType);
var results = new List<string>(values.Length);
foreach (var value in values)
{
var action = actionMethod.Invoke(null, [value]) as string;
results.Add(action ?? string.Empty);
}
return results.OrderBy(action => action, StringComparer.OrdinalIgnoreCase).ToArray();
}
private static string[] GetActualActions(Type enumType)
{
var method = typeof(ActionValidator)
.GetMethods(BindingFlags.Public | BindingFlags.Static)
.First(m => m.Name == "GetValidActions" && m.IsGenericMethodDefinition)
.MakeGenericMethod(enumType);
var actions = (IReadOnlyCollection<string>)method.Invoke(null, null)!;
return actions.OrderBy(action => action, StringComparer.OrdinalIgnoreCase).ToArray();
}
private static string CaptureOutput(Func<int> action)
{
var original = Console.Out;
using var writer = new StringWriter();
try
{
Console.SetOut(writer);
action();
return writer.ToString().Trim();
}
finally
{
Console.SetOut(original);
}
}
private sealed class FakeRemainingArguments : IRemainingArguments
{
private static readonly ILookup<string, string?> EmptyLookup =
Array.Empty<string>().ToLookup(_ => string.Empty, _ => (string?)null);
public ILookup<string, string?> Parsed { get; } = EmptyLookup;
public IReadOnlyList<string> Raw { get; } = Array.Empty<string>();
}
}
