namespace FrameworkDAL.Query.ActionProcessor
{
    /// <summary>
    /// SQL constants for LPROCESSEDACTION (idempotency log, IDENTITY PK).
    /// UK_LPROCESSEDACTION_ACTIONRUNID ensures each ActionRunId is processed only once.
    /// </summary>
    public static class ProcessedActionQB
    {
        // =====================================================
        // Check if ActionRunId was already processed
        // =====================================================
        public const string CHECK_EXISTS = @"
SELECT COUNT(1)
FROM   LPROCESSEDACTION
WHERE  ACTIONRUNID = @ActionRunId
";

        // =====================================================
        // Record that an action run was successfully processed
        // =====================================================
        public const string INSERT = @"
INSERT INTO LPROCESSEDACTION (ACTIONRUNID, CREATEDBYID, CREATEDON)
VALUES (@ActionRunId, @CreatedById, GETDATE())
";
    }
}