61 lines
1.6 KiB
Go
61 lines
1.6 KiB
Go
// Code generated by sqlc. DO NOT EDIT.
|
|
// versions:
|
|
// sqlc v1.31.1
|
|
// source: run_credentials.sql
|
|
|
|
package postgresdb
|
|
|
|
import (
|
|
"context"
|
|
"time"
|
|
)
|
|
|
|
const deleteExpiredRunCredentials = `-- name: DeleteExpiredRunCredentials :exec
|
|
DELETE FROM run_credentials WHERE expires_at <= $1
|
|
`
|
|
|
|
func (q *Queries) DeleteExpiredRunCredentials(ctx context.Context, expiresAt time.Time) error {
|
|
_, err := q.db.Exec(ctx, deleteExpiredRunCredentials, expiresAt)
|
|
return err
|
|
}
|
|
|
|
const deleteRunCredential = `-- name: DeleteRunCredential :exec
|
|
DELETE FROM run_credentials WHERE digest = $1
|
|
`
|
|
|
|
func (q *Queries) DeleteRunCredential(ctx context.Context, digest []byte) error {
|
|
_, err := q.db.Exec(ctx, deleteRunCredential, digest)
|
|
return err
|
|
}
|
|
|
|
const insertRunCredential = `-- name: InsertRunCredential :exec
|
|
INSERT INTO run_credentials (digest, task_id, expires_at) VALUES ($1, $2, $3)
|
|
`
|
|
|
|
type InsertRunCredentialParams struct {
|
|
Digest []byte
|
|
TaskID int64
|
|
ExpiresAt time.Time
|
|
}
|
|
|
|
func (q *Queries) InsertRunCredential(ctx context.Context, arg InsertRunCredentialParams) error {
|
|
_, err := q.db.Exec(ctx, insertRunCredential, arg.Digest, arg.TaskID, arg.ExpiresAt)
|
|
return err
|
|
}
|
|
|
|
const runCredentialTask = `-- name: RunCredentialTask :one
|
|
SELECT task_id FROM run_credentials WHERE digest = $1 AND expires_at > $2
|
|
`
|
|
|
|
type RunCredentialTaskParams struct {
|
|
Digest []byte
|
|
ExpiresAt time.Time
|
|
}
|
|
|
|
func (q *Queries) RunCredentialTask(ctx context.Context, arg RunCredentialTaskParams) (int64, error) {
|
|
row := q.db.QueryRow(ctx, runCredentialTask, arg.Digest, arg.ExpiresAt)
|
|
var task_id int64
|
|
err := row.Scan(&task_id)
|
|
return task_id, err
|
|
}
|