shithub Public

Watch 1 Fork 0 Star 0

MySQL · 398 bytes Raw Blame History

  
        1
        -- SPDX-License-Identifier: AGPL-3.0-or-later
      
        2
        
        3
        -- name: MarkRunnerJWTUsed :one
      
        4
        INSERT INTO runner_jwt_used (jti, runner_id, job_id, run_id, repo_id, expires_at)
      
        5
        VALUES ($1, $2, $3, $4, $5, $6)
      
        6
        ON CONFLICT (jti) DO NOTHING
      
        7
        RETURNING jti, runner_id, job_id, run_id, repo_id, expires_at, used_at;
      
        8
        
        9
        -- name: DeleteOldRunnerJWTUsesForCleanup :execrows
      
        10
        DELETE FROM runner_jwt_used WHERE expires_at < $1;
      
        11

1	-- SPDX-License-Identifier: AGPL-3.0-or-later
2
3	-- name: MarkRunnerJWTUsed :one
4	INSERT INTO runner_jwt_used (jti, runner_id, job_id, run_id, repo_id, expires_at)
5	VALUES ($1, $2, $3, $4, $5, $6)
6	ON CONFLICT (jti) DO NOTHING
7	RETURNING jti, runner_id, job_id, run_id, repo_id, expires_at, used_at;
8
9	-- name: DeleteOldRunnerJWTUsesForCleanup :execrows
10	DELETE FROM runner_jwt_used WHERE expires_at < $1;
11