namespace GB5Shared.DirectAction
{
    // INDEX: TDIRECTACTIONTOKEN — clustered PK on TOKENHASH + IX on (TOKENHASH, TENANTID)
    public static class DirectActionTokenQB
    {
        public const string GET_BY_HASH = @"
            SELECT TOKENHASH       AS TokenHash,
                   CONTEXTID       AS ContextId,
                   ACTIONCODE      AS ActionCode,
                   ASSIGNEEUSERID  AS AssigneeUserId,
                   TENANTID        AS TenantId,
                   EXPIRESAT       AS ExpiresAt,
                   USEDAT          AS UsedAt,
                   STATUS          AS Status,
                   CREATEDON       AS CreatedOn
            FROM   TDIRECTACTIONTOKEN
            WHERE  TOKENHASH = @TokenHash
              AND  TENANTID  = @TenantId";

        public const string INSERT_USED = @"
            INSERT INTO TDIRECTACTIONTOKEN
                (TOKENHASH, CONTEXTID, ACTIONCODE, ASSIGNEEUSERID, TENANTID, EXPIRESAT, USEDAT, STATUS, REMARKS, CREATEDON)
            VALUES
                (@TokenHash, @ContextId, @ActionCode, @AssigneeUserId, @TenantId, @ExpiresAt, @UsedAt, @Status, @Remarks, GETUTCDATE())";
    }
}