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 GetCertificateValidationByHostname = `-- name: GetCertificateValidationByHostname :one
55SELECT id, hostname, certificate_hash, user_decision, created_at, expires_at FROM certificate_validations
56WHERE hostname = ?
57AND (expires_at IS NULL OR expires_at > datetime('now'))
58ORDER BY created_at DESC
59LIMIT 1
60`
61
62func (q *Queries) GetCertificateValidationByHostname(ctx context.Context, hostname string) (CertificateValidation, error) {
63 row := q.db.QueryRowContext(ctx, GetCertificateValidationByHostname, hostname)
64 var i CertificateValidation
65 err := row.Scan(
66 &i.ID,
67 &i.Hostname,
68 &i.CertificateHash,
69 &i.UserDecision,
70 &i.CreatedAt,
71 &i.ExpiresAt,
72 )
73 return i, err
74}
75
76const StoreCertificateValidation = `-- name: StoreCertificateValidation :exec
77INSERT OR REPLACE INTO certificate_validations (hostname, certificate_hash, user_decision, expires_at)
78VALUES (?, ?, ?, ?)
79`
80
81func (q *Queries) StoreCertificateValidation(ctx context.Context, hostname string, certificateHash string, userDecision string, expiresAt sql.NullTime) error {
82 _, err := q.db.ExecContext(ctx, StoreCertificateValidation,
83 hostname,
84 certificateHash,
85 userDecision,
86 expiresAt,
87 )
88 return err
89}