1// Code generated by sqlc. DO NOT EDIT.
2// versions:
3// sqlc v1.30.0
4// source: certificate_validations.sql
5
6package db
7
8import (
9 "context"
10 "database/sql"
11)
12
13const DeleteCertificateValidation = `-- name: DeleteCertificateValidation :exec
14DELETE FROM certificate_validations
15WHERE hostname = ? AND certificate_hash = ?
16`
17
18func (q *Queries) DeleteCertificateValidation(ctx context.Context, hostname string, certificateHash string) error {
19 _, err := q.db.ExecContext(ctx, DeleteCertificateValidation, hostname, certificateHash)
20 return err
21}
22
23const DeleteExpiredCertificateValidations = `-- name: DeleteExpiredCertificateValidations :exec
24DELETE FROM certificate_validations
25WHERE expires_at IS NOT NULL AND expires_at <= datetime('now')
26`
27
28func (q *Queries) DeleteExpiredCertificateValidations(ctx context.Context) error {
29 _, err := q.db.ExecContext(ctx, DeleteExpiredCertificateValidations)
30 return err
31}
32
33const GetCertificateValidation = `-- name: GetCertificateValidation :one
34SELECT id, hostname, certificate_hash, user_decision, created_at, expires_at FROM certificate_validations
35WHERE hostname = ? AND certificate_hash = ?
36AND (expires_at IS NULL OR expires_at > datetime('now'))
37LIMIT 1
38`
39
40func (q *Queries) GetCertificateValidation(ctx context.Context, hostname string, certificateHash string) (CertificateValidation, error) {
41 row := q.db.QueryRowContext(ctx, GetCertificateValidation, hostname, certificateHash)
42 var i CertificateValidation
43 err := row.Scan(
44 &i.ID,
45 &i.Hostname,
46 &i.CertificateHash,
47 &i.UserDecision,
48 &i.CreatedAt,
49 &i.ExpiresAt,
50 )
51 return i, err
52}
53
54const StoreCertificateValidation = `-- name: StoreCertificateValidation :exec
55INSERT OR REPLACE INTO certificate_validations (hostname, certificate_hash, user_decision, expires_at)
56VALUES (?, ?, ?, ?)
57`
58
59func (q *Queries) StoreCertificateValidation(ctx context.Context, hostname string, certificateHash string, userDecision string, expiresAt sql.NullTime) error {
60 _, err := q.db.ExecContext(ctx, StoreCertificateValidation,
61 hostname,
62 certificateHash,
63 userDecision,
64 expiresAt,
65 )
66 return err
67}