namespace FrameworkDAL.Query.EIPConversation.EIPRestActionCfg
{
    public static class EIPRestActionCfgQB
    {
        public const string GET_BY_ACTIONCODE = @"
            SELECT TOP 1
                r.RESTACTIONCFGID  AS RestActionCfgId,
                a.ACTIONCODE       AS ActionCode,
                r.HTTPMETHOD       AS HttpMethod,
                NULL               AS BaseUrl,  -- BASEURL column does not exist in MEIPRESTACTIONCFG DDL; DTO.BaseUrl is nullable
                r.ENDPOINTPATH     AS EndpointPath,
                r.PAYLOADTEMPLATE  AS PayloadTemplate,
                r.HEADERSJSON      AS HeadersJson,
                r.TIMEOUTSECONDS   AS TimeoutSeconds
            FROM MEIPRESTACTIONCFG r
            INNER JOIN MEIPACTIONREGISTRY a ON a.ACTIONID = r.ACTIONID
            WHERE a.ACTIONCODE = @ActionCode
              AND r.STATUS  = 1
              AND r.ISACTIVE = 1
            ORDER BY r.CONFIGVERSION DESC";
    }
}