using System.Threading.Tasks;
using Microsoft.Extensions.Configuration;
using Shouldly;
using Xunit;
using ZB.MOM.WW.LmxOpcUa.Host.Configuration;
using ZB.MOM.WW.LmxOpcUa.Host.GalaxyRepository;

namespace ZB.MOM.WW.LmxOpcUa.IntegrationTests
{
    /// <summary>
    ///     Integration tests that exercise the real Galaxy repository queries against the test database configuration.
    /// </summary>
    public class GalaxyRepositoryServiceTests
    {
        /// <summary>
        ///     Loads repository configuration from the integration test settings and controls whether extended attributes are
        ///     enabled.
        /// </summary>
        /// <param name="extendedAttributes">A value indicating whether the extended attribute query path should be enabled.</param>
        /// <returns>The repository configuration used by the integration test.</returns>
        private static GalaxyRepositoryConfiguration LoadConfig(bool extendedAttributes = false)
        {
            var configuration = new ConfigurationBuilder()
                .AddJsonFile("appsettings.test.json", false)
                .Build();

            var config = new GalaxyRepositoryConfiguration();
            configuration.GetSection("GalaxyRepository").Bind(config);
            config.ExtendedAttributes = extendedAttributes;
            return config;
        }

        /// <summary>
        ///     Confirms that the standard attribute query returns rows from the repository.
        /// </summary>
        [Fact]
        public async Task GetAttributesAsync_StandardMode_ReturnsRows()
        {
            var config = LoadConfig(false);
            var service = new GalaxyRepositoryService(config);

            var results = await service.GetAttributesAsync();

            results.ShouldNotBeEmpty();
            // Standard mode: PrimitiveName and AttributeSource should be empty
            results.ShouldAllBe(r => r.PrimitiveName == "" && r.AttributeSource == "");
        }

        /// <summary>
        ///     Confirms that the extended attribute query returns more rows than the standard query path.
        /// </summary>
        [Fact]
        public async Task GetAttributesAsync_ExtendedMode_ReturnsMoreRows()
        {
            var standardConfig = LoadConfig(false);
            var extendedConfig = LoadConfig(true);
            var standardService = new GalaxyRepositoryService(standardConfig);
            var extendedService = new GalaxyRepositoryService(extendedConfig);

            var standardResults = await standardService.GetAttributesAsync();
            var extendedResults = await extendedService.GetAttributesAsync();

            extendedResults.Count.ShouldBeGreaterThan(standardResults.Count);
        }

        /// <summary>
        ///     Confirms that the extended attribute query includes both primitive and dynamic attribute sources.
        /// </summary>
        [Fact]
        public async Task GetAttributesAsync_ExtendedMode_IncludesPrimitiveAttributes()
        {
            var config = LoadConfig(true);
            var service = new GalaxyRepositoryService(config);

            var results = await service.GetAttributesAsync();

            results.ShouldContain(r => r.AttributeSource == "primitive");
            results.ShouldContain(r => r.AttributeSource == "dynamic");
        }

        /// <summary>
        ///     Confirms that extended mode populates attribute-source metadata across the result set.
        /// </summary>
        [Fact]
        public async Task GetAttributesAsync_ExtendedMode_PrimitiveNamePopulated()
        {
            var config = LoadConfig(true);
            var service = new GalaxyRepositoryService(config);

            var results = await service.GetAttributesAsync();

            // Some primitive attributes have non-empty primitive names
            // (though many have empty primitive_name for the root UDO)
            results.ShouldNotBeEmpty();
            // All should have an attribute source
            results.ShouldAllBe(r => r.AttributeSource == "primitive" || r.AttributeSource == "dynamic");
        }

        /// <summary>
        ///     Confirms that standard-mode results always include fully qualified tag references.
        /// </summary>
        [Fact]
        public async Task GetAttributesAsync_StandardMode_AllHaveFullTagReference()
        {
            var config = LoadConfig(false);
            var service = new GalaxyRepositoryService(config);

            var results = await service.GetAttributesAsync();

            results.ShouldAllBe(r => !string.IsNullOrEmpty(r.FullTagReference));
            results.ShouldAllBe(r => r.FullTagReference.Contains("."));
        }

        /// <summary>
        ///     Confirms that extended-mode results always include fully qualified tag references.
        /// </summary>
        [Fact]
        public async Task GetAttributesAsync_ExtendedMode_AllHaveFullTagReference()
        {
            var config = LoadConfig(true);
            var service = new GalaxyRepositoryService(config);

            var results = await service.GetAttributesAsync();

            results.ShouldAllBe(r => !string.IsNullOrEmpty(r.FullTagReference));
            results.ShouldAllBe(r => r.FullTagReference.Contains("."));
        }
    }
}