certificate_validations.sql RawHistoryFolder

1-- name: GetCertificateValidation :one
2SELECT * FROM certificate_validations
3WHERE hostname = ? AND certificate_hash = ?
4AND (expires_at IS NULL OR expires_at > datetime('now'))
5LIMIT 1;
6
7-- name: GetCertificateValidationByHostname :one
8SELECT * FROM certificate_validations
9WHERE hostname = ?
10AND (expires_at IS NULL OR expires_at > datetime('now'))
11ORDER BY created_at DESC
12LIMIT 1;
13
14-- name: StoreCertificateValidation :exec
15INSERT OR REPLACE INTO certificate_validations (hostname, certificate_hash, user_decision, expires_at)
16VALUES (?, ?, ?, ?);
17
18-- name: DeleteExpiredCertificateValidations :exec
19DELETE FROM certificate_validations 
20WHERE expires_at IS NOT NULL AND expires_at <= datetime('now');
21
22-- name: DeleteCertificateValidation :exec
23DELETE FROM certificate_validations
24WHERE hostname = ? AND certificate_hash = ?;
25
26-- name: ListCertificateValidations :many
27SELECT * FROM certificate_validations
28WHERE (expires_at IS NULL OR expires_at > datetime('now'))
29ORDER BY hostname;