using System;
using System.Collections.Generic;
using System.Diagnostics.CodeAnalysis;
using System.Threading.Tasks;

namespace Strata.DecisionSupport.Biz.Test.Unit.UnitTests
{
    [ExcludeFromCodeCoverage]
    [TestFixture, Category("Unit"), Category("DSS")]
    public class TestSqlQueries : UnitTestBase
    {
        [TestCaseSource(typeof(SnowflakeTestCases), nameof(SnowflakeTestCases.TestCases))]
        public async Task VerifyQuery<TI, T>(TI obj, T queryInfo, Func<IEnumerable<TI>, IEnumerable<TI>> orderby) where T : class
            => await base.VerifyQuery(queryInfo);

        [TestCaseSource(typeof(SnowflakeTestCases), nameof(SnowflakeTestCases.TestCases))]
        public async Task VerifyDictionary<TI, T>(TI obj, T queryInfo, Func<IEnumerable<TI>, IEnumerable<TI>> orderby) where T : class
            => await base.VerifyDictionary(queryInfo);

        [TestCaseSource(typeof(SnowflakeTestCases), nameof(SnowflakeTestCases.TestCases))]
        public async Task VerifyParameters<TI, T>(TI obj, T queryInfo, Func<IEnumerable<TI>, IEnumerable<TI>> orderby) where T : class
            => await base.VerifyParameters(queryInfo);

        [TestCaseSource(typeof(SnowflakeTestCases), nameof(SnowflakeTestCases.TestCases))]
        public async Task VerifyArgs<TI, T>(TI obj, T queryInfo, Func<IEnumerable<TI>, IEnumerable<TI>> orderby) where T : class
            => await base.VerifyArgs(queryInfo);

        protected override string Query<T>(T queryInfo) where T : class
            => SnowflakeTestCases.Query(queryInfo);

    }
}