whitelist.sql.go RawHistoryFolder

1// Code generated by sqlc. DO NOT EDIT.
2// versions:
3//   sqlc v1.30.0
4// source: whitelist.sql
5
6package sqlc
7
8import (
9	"context"
10)
11
12const AddToWhitelist = `-- name: AddToWhitelist :exec
13INSERT OR IGNORE INTO content_whitelist (domain, created_at) VALUES (?, CURRENT_TIMESTAMP)
14`
15
16func (q *Queries) AddToWhitelist(ctx context.Context, domain string) error {
17	_, err := q.db.ExecContext(ctx, AddToWhitelist, domain)
18	return err
19}
20
21const GetAllWhitelistedDomains = `-- name: GetAllWhitelistedDomains :many
22SELECT domain FROM content_whitelist ORDER BY domain
23`
24
25func (q *Queries) GetAllWhitelistedDomains(ctx context.Context) ([]string, error) {
26	rows, err := q.db.QueryContext(ctx, GetAllWhitelistedDomains)
27	if err != nil {
28		return nil, err
29	}
30	defer rows.Close()
31	items := []string{}
32	for rows.Next() {
33		var domain string
34		if err := rows.Scan(&domain); err != nil {
35			return nil, err
36		}
37		items = append(items, domain)
38	}
39	if err := rows.Close(); err != nil {
40		return nil, err
41	}
42	if err := rows.Err(); err != nil {
43		return nil, err
44	}
45	return items, nil
46}
47
48const IsWhitelisted = `-- name: IsWhitelisted :one
49SELECT COUNT(*) FROM content_whitelist WHERE domain = ? LIMIT 1
50`
51
52func (q *Queries) IsWhitelisted(ctx context.Context, domain string) (int64, error) {
53	row := q.db.QueryRowContext(ctx, IsWhitelisted, domain)
54	var count int64
55	err := row.Scan(&count)
56	return count, err
57}
58
59const RemoveFromWhitelist = `-- name: RemoveFromWhitelist :exec
60DELETE FROM content_whitelist WHERE domain = ?
61`
62
63func (q *Queries) RemoveFromWhitelist(ctx context.Context, domain string) error {
64	_, err := q.db.ExecContext(ctx, RemoveFromWhitelist, domain)
65	return err
66}