using System.Collections.Generic;
using AnalyticsDAL.DTO.AnalysisAggregation.V1;
using AnalyticsDAL.DTO.BICatalog;
using AnalyticsDAL.DTO.Warehouse;
using GB5Shared.DTO.Framework.Login;

namespace AnalyticsDAL.CustomCode.Warehouse
{
    public interface IWarehouseDAL
    {
        Task<WarehouseFactDTO?> GetFactById(int factId, LoginDTO login, CancellationToken ct);
        Task<List<WarehouseMeasureDTO>> GetMeasuresByFactId(int factId, LoginDTO login, CancellationToken ct);

        /// <summary>Builds and executes the GROUP BY SQL for a Warehouse-kind dataset —
        /// the fact table LEFT JOINed to DIMOU/DIMDATE (the only two conformed dimensions
        /// the ported facts are grained by), following the same aggregation-expression
        /// conventions as AnalyticsDAL/Query/Analysis/AnalysisQB.cs.</summary>
        Task<List<Dictionary<string, object?>>> ExecuteAggregationAsync(
            DatasetResolutionDTO resolution,
            AnalysisQueryDefinition definition,
            LoginDTO login,
            CancellationToken ct);
    }
}