using FastEndpoints;
using GB5Shared.DTO.Framework.Login;
using GB5Shared.DTO.Framework.ResponseStandard;
using GB5Shared.FastEndPoint;
using SwBLL.Query;
using static GB5Shared.GB5Constant.Constant;
using GB5Shared.Authorization;

namespace SwSL.EndPoints.Query;

//[MenuRights("SWQUERY", RightOperation.Update)]
public class ExecuteAdHocQuery : BaseEndpoint<ExecuteAdHocQuery.Parameters, ResponseStandardDTO<object>>
{
    private readonly ISwQueryBLL _bll;

    public ExecuteAdHocQuery(ISwQueryBLL bll) => _bll = bll;

    public override void Configure()
    {
        Post("/Query/ExecuteAdHocQuery");
        AllowAnonymous();
    }

    public record Parameters(
        [property: FromHeader] string                      Login,
        [property: QueryParam] string                      QueryCode,
        [property: QueryParam] int                         DbServerId,
        [property: FromBody]   Dictionary<string, object?> Body,
        [property: QueryParam] int?                        ClientDbId = null,
        [property: QueryParam] string?                      DatabaseName = null);

    // Never cache — live query results, user-supplied parameters
    protected override string? GetCacheKey(Parameters req, LoginDTO loginDTO) => null;

    protected override async Task<ResponseStandardDTO<object>> ExecuteAsync(
        Parameters req, LoginDTO loginDTO, CancellationToken ct)
    {
        var result = await _bll.ExecuteAdHocQuery(
            req.QueryCode, req.Body, req.DbServerId, req.DatabaseName, loginDTO, ct,
            clientDbId: req.ClientDbId);
        return await GB5Shared.ResponseStandard.Response.CreateSuccessResponse(
            result, CacheKeyLevel.NOT_REQUIRED, loginDTO);
    }
}