namespace GB5Shared.ActionProcessor.Query
{
    /// <summary>
    /// SQL constants for resolving a webhook endpoint's MWEBSERVICE.URITEMPLATE — used by
    /// GB5Shared.ActionProcessor.WebhookEndpointResolver.
    /// </summary>
    public static class WebhookEndpointQB
    {
        public const string GET_WEBSERVICE_URL = @"
SELECT W.URITEMPLATE       AS UriTemplate,
       W.SECONDURITEMPLATE AS SecondUriTemplate
FROM   MWEBSERVICE W
WHERE  W.WEBSERVICEID = @WebServiceId;
--AND    W.STATUS       = 1
--AND    W.TENANTID     = @TenantId";

        // 0 = caller should submit every row as one list in a single call; 1 (default when NULL —
        // every pre-existing MWEBSERVICE row) = caller keeps calling once per row, as before.
        public const string GET_REQUEST_SCHEMA_TYPE = @"
SELECT ISNULL(W.REQUESTSCHEMATYPE, 1)
FROM   MWEBSERVICE W
WHERE  W.WEBSERVICEID = @WebServiceId;";
    }
}