github.com/navikt/knorten@v0.0.0-20240419132333-1333f46ed8b6/pkg/database/queries/events.sql (about)

     1  -- name: EventCreate :exec
     2  INSERT INTO Events (owner, type, payload, status, deadline)
     3  VALUES (@owner,
     4          @type,
     5          @payload,
     6          'new',
     7          @deadline);
     8  
     9  -- name: EventGet :one
    10  SELECT *
    11  FROM Events
    12  WHERE id = @id;
    13  
    14  -- name: EventsByOwnerGet :many
    15  SELECT *
    16  FROM Events
    17  WHERE owner = @owner
    18  ORDER BY updated_at DESC
    19  LIMIT sqlc.narg('lim');
    20  
    21  -- name: EventsProcessingGet :many
    22  SELECT *
    23  FROM events
    24  WHERE status = 'processing'
    25  ORDER BY created_at DESC;
    26  
    27  -- name: EventsReset :exec
    28  UPDATE events
    29  SET status = 'pending'
    30  WHERE status = 'processing';
    31  
    32  -- name: EventsUpcomingGet :many
    33  SELECT *
    34  FROM Events
    35  WHERE status = 'new'
    36     OR status = 'pending'
    37     OR status = 'deadline_reached'
    38  ORDER BY created_at ASC;
    39  
    40  -- name: EventsGetType :many
    41  SELECT *
    42  FROM Events
    43  WHERE type = @event_type;
    44  
    45  -- name: EventSetStatus :exec
    46  UPDATE Events
    47  SET status = @status
    48  WHERE id = @id;
    49  
    50  -- name: EventIncrementRetryCount :exec
    51  UPDATE events
    52  SET retry_count = retry_count + 1
    53  WHERE id = @id;
    54  
    55  -- name: EventLogCreate :exec
    56  INSERT INTO Event_Logs (event_id, log_type, message)
    57  VALUES (@event_id, @log_type, @message);
    58  
    59  -- name: EventLogsForEventGet :many
    60  SELECT *
    61  FROM event_logs
    62  WHERE event_id = @id
    63  ORDER BY created_at DESC;