shithub Public

Watch 1 Fork 0 Star 0

MySQL · 458 bytes Raw Blame History

  
        1
        -- SPDX-License-Identifier: AGPL-3.0-or-later
      
        2
        
        3
        -- name: AppendStepLogChunk :one
      
        4
        INSERT INTO workflow_step_log_chunks (step_id, seq, chunk)
      
        5
        VALUES ($1, $2, $3)
      
        6
        RETURNING id, step_id, seq, created_at;
      
        7
        
        8
        -- name: ListStepLogChunks :many
      
        9
        SELECT id, step_id, seq, chunk, created_at
      
        10
        FROM workflow_step_log_chunks
      
        11
        WHERE step_id = $1 AND seq > $2
      
        12
        ORDER BY seq ASC
      
        13
        LIMIT $3;
      
        14
        
        15
        -- name: DeleteStepLogChunks :exec
      
        16
        DELETE FROM workflow_step_log_chunks WHERE step_id = $1;
      
        17

1	-- SPDX-License-Identifier: AGPL-3.0-or-later
2
3	-- name: AppendStepLogChunk :one
4	INSERT INTO workflow_step_log_chunks (step_id, seq, chunk)
5	VALUES ($1, $2, $3)
6	RETURNING id, step_id, seq, created_at;
7
8	-- name: ListStepLogChunks :many
9	SELECT id, step_id, seq, chunk, created_at
10	FROM workflow_step_log_chunks
11	WHERE step_id = $1 AND seq > $2
12	ORDER BY seq ASC
13	LIMIT $3;
14
15	-- name: DeleteStepLogChunks :exec
16	DELETE FROM workflow_step_log_chunks WHERE step_id = $1;
17