continuousimprovement/tests/Strata.ContinuousImprovement.Biz.Test.Integration/SnowflakeIntegrationTests/TestSnowflakeDatabaseContext.cs

using Strata.ContinuousImprovement.Biz.Exploration;
using Strata.ContinuousImprovement.Biz.Exploration.CaseTypeFamilies;
using Strata.ContinuousImprovement.Biz.Exploration.Filters;
using System.Diagnostics.CodeAnalysis;
using static Strata.ContinuousImprovement.Biz.Exploration.ExplorationService;

namespace Strata.ContinuousImprovement.Biz.Test.Integration.SnowflakeIntegrationTests
{
    [ExcludeFromCodeCoverage]
    [TestFixture, Category("Integration"), Category("CCI")]
    public class TestSnowflakeDatabaseContext : IntegrationTestBase
    {
        [Test, Ignore("Test database needs to be rolled over to the new year")]
        public async Task BuildCaseTypeFamilySummaryQueryTest()
        {
            var queryParams = new QueryParams
            {
                CodeType = UtilizationVariation.VariationCaseTypes.CaseTypeCategories.MSDRG
            };

            int year = DateTime.Now.Year;
            var dischargeDate = new FilterChipItem
            {
                ChipType = ChipType.DateRange,
                Filters = [],
                DateRange = [new DateTime(year, 1, 1), new DateTime(year + 1, 1, 1).AddTicks(-1)]
            };

            var filters = new Exploration.Filters.Filter
            {
                DischargeDateStart = dischargeDate.DateRange.First(),
                DischargeDateEnd = dischargeDate.DateRange.Last(),
                FilterChipItems = [dischargeDate]
            };

            var filterStrings = await ExplorationFilterService.GetFilterStringsAsync(filters.FilterChipItems, queryParams, CancellationToken.None);
            var ctfSummaryQuery = ExplorationServiceQuery.BuildCaseTypeFamilySummaryQuery(filterStrings.QueryFilters, filterStrings.EncounterSummaryFilters);

            var ctfCostDriverInfos = await SnowflakeDatabaseContext
                .QueryAsync<CaseTypeFamilyEncounterInfo>(ctfSummaryQuery, "CaseTypeFamily CostDriver Summary", queryParams);
            Assert.That(ctfCostDriverInfos, Is.Not.Null.And.Not.Empty
                .And.All.InstanceOf<CaseTypeFamilyEncounterInfo>());
        }

    }
}