DatabaseListCommandTests.cs•6.42 kB
// Copyright (c) Microsoft Corporation.
// Licensed under the MIT License.
using System.CommandLine.Parsing;
using System.Text.Json;
using System.Text.Json.Serialization;
using AzureMcp.Core.Models;
using AzureMcp.Core.Models.Command;
using AzureMcp.Core.Options;
using AzureMcp.Kusto.Commands;
using AzureMcp.Kusto.Services;
using Microsoft.Extensions.DependencyInjection;
using Microsoft.Extensions.Logging;
using NSubstitute;
using Xunit;
namespace AzureMcp.Kusto.UnitTests;
public sealed class DatabaseListCommandTests
{
private readonly IServiceProvider _serviceProvider;
private readonly IKustoService _kusto;
private readonly ILogger<DatabaseListCommand> _logger;
public DatabaseListCommandTests()
{
_kusto = Substitute.For<IKustoService>();
_logger = Substitute.For<ILogger<DatabaseListCommand>>();
var collection = new ServiceCollection();
collection.AddSingleton(_kusto);
_serviceProvider = collection.BuildServiceProvider();
}
public static IEnumerable<object[]> DatabaseArgumentMatrix()
{
yield return new object[] { "--subscription sub1 --cluster mycluster", false };
yield return new object[] { "--cluster-uri https://mycluster.kusto.windows.net", true };
}
[Theory]
[MemberData(nameof(DatabaseArgumentMatrix))]
public async Task ExecuteAsync_ReturnsDatabases(string cliArgs, bool useClusterUri)
{
// Arrange
var expectedDatabases = new List<string> { "db1", "db2" };
if (useClusterUri)
{
_kusto.ListDatabases(
"https://mycluster.kusto.windows.net",
Arg.Any<string>(), Arg.Any<AuthMethod?>(), Arg.Any<RetryPolicyOptions>())
.Returns(expectedDatabases);
}
else
{
_kusto.ListDatabases(
"sub1", "mycluster", Arg.Any<string>(), Arg.Any<AuthMethod?>(), Arg.Any<RetryPolicyOptions>())
.Returns(expectedDatabases);
}
var command = new DatabaseListCommand(_logger);
var parser = new Parser(command.GetCommand());
var args = parser.Parse(cliArgs);
var context = new CommandContext(_serviceProvider);
// Act
var response = await command.ExecuteAsync(context, args);
// Assert
Assert.NotNull(response);
Assert.NotNull(response.Results);
var json = JsonSerializer.Serialize(response.Results);
var result = JsonSerializer.Deserialize<DatabaseListResult>(json);
Assert.NotNull(result);
Assert.Equal(expectedDatabases, result.Databases);
}
[Theory]
[MemberData(nameof(DatabaseArgumentMatrix))]
public async Task ExecuteAsync_ReturnsNull_WhenNoDatabasesExist(string cliArgs, bool useClusterUri)
{
// Arrange
if (useClusterUri)
{
_kusto.ListDatabases(
"https://mycluster.kusto.windows.net",
Arg.Any<string>(), Arg.Any<AuthMethod?>(), Arg.Any<RetryPolicyOptions>())
.Returns([]);
}
else
{
_kusto.ListDatabases(
"sub1", "mycluster", Arg.Any<string>(), Arg.Any<AuthMethod?>(), Arg.Any<RetryPolicyOptions>())
.Returns([]);
}
var command = new DatabaseListCommand(_logger);
var parser = new Parser(command.GetCommand());
var args = parser.Parse(cliArgs);
var context = new CommandContext(_serviceProvider);
// Act
var response = await command.ExecuteAsync(context, args);
// Assert
Assert.NotNull(response);
Assert.Null(response.Results);
}
[Theory]
[MemberData(nameof(DatabaseArgumentMatrix))]
public async Task ExecuteAsync_HandlesException_AndSetsException(string cliArgs, bool useClusterUri)
{
// Arrange
var expectedError = "Test error. To mitigate this issue, please refer to the troubleshooting guidelines here at https://aka.ms/azmcp/troubleshooting.";
if (useClusterUri)
{
_kusto.ListDatabases(
"https://mycluster.kusto.windows.net",
Arg.Any<string>(), Arg.Any<AuthMethod?>(), Arg.Any<RetryPolicyOptions>())
.Returns(Task.FromException<List<string>>(new Exception("Test error")));
}
else
{
_kusto.ListDatabases(
"sub1", "mycluster", Arg.Any<string>(), Arg.Any<AuthMethod?>(), Arg.Any<RetryPolicyOptions>())
.Returns(Task.FromException<List<string>>(new Exception("Test error")));
}
var command = new DatabaseListCommand(_logger);
var parser = new Parser(command.GetCommand());
var args = parser.Parse(cliArgs);
var context = new CommandContext(_serviceProvider);
// Act
var response = await command.ExecuteAsync(context, args);
// Assert
Assert.NotNull(response);
Assert.Equal(500, response.Status);
Assert.Equal(expectedError, response.Message);
}
[Fact]
public async Task ExecuteAsync_ReturnsBadRequest_WhenMissingRequiredOptions()
{
var command = new DatabaseListCommand(_logger);
var parser = new Parser(command.GetCommand());
var args = parser.Parse(""); // No arguments
var context = new CommandContext(_serviceProvider);
var response = await command.ExecuteAsync(context, args);
Assert.NotNull(response);
Assert.Equal(400, response.Status);
Assert.Contains("Either --cluster-uri must be provided", response.Message, StringComparison.OrdinalIgnoreCase);
}
[Fact]
public async Task ExecuteAsync_ReturnsBadRequest_WhenMissingAllRequiredOptions()
{
var command = new DatabaseListCommand(_logger);
var parser = new Parser(command.GetCommand());
var args = parser.Parse(""); // No arguments
var context = new CommandContext(_serviceProvider);
var response = await command.ExecuteAsync(context, args);
Assert.NotNull(response);
Assert.Equal(400, response.Status);
Assert.Contains("Either --cluster-uri must be provided", response.Message, StringComparison.OrdinalIgnoreCase);
}
private sealed class DatabaseListResult
{
[JsonPropertyName("databases")]
public List<string>? Databases { get; set; }
}
}