| 1 | -- SPDX-License-Identifier: AGPL-3.0-or-later |
| 2 | |
| 3 | -- name: UpsertWorkflowJobSecretMask :exec |
| 4 | INSERT INTO workflow_job_secret_masks (job_id, ciphertext, nonce) |
| 5 | VALUES ($1, $2, $3) |
| 6 | ON CONFLICT (job_id) DO UPDATE |
| 7 | SET ciphertext = EXCLUDED.ciphertext, |
| 8 | nonce = EXCLUDED.nonce, |
| 9 | created_at = now(); |
| 10 | |
| 11 | -- name: GetWorkflowJobSecretMask :one |
| 12 | SELECT job_id, ciphertext, nonce, created_at |
| 13 | FROM workflow_job_secret_masks |
| 14 | WHERE job_id = $1; |
| 15 |