1// Code generated by sqlc. DO NOT EDIT.
2// versions:
3// sqlc v1.30.0
4// source: zoom.sql
5
6package sqlc
7
8import (
9 "context"
10)
11
12const DeleteZoomLevel = `-- name: DeleteZoomLevel :exec
13DELETE FROM zoom_levels WHERE domain = ?
14`
15
16func (q *Queries) DeleteZoomLevel(ctx context.Context, domain string) error {
17 _, err := q.db.ExecContext(ctx, DeleteZoomLevel, domain)
18 return err
19}
20
21const GetZoomLevel = `-- name: GetZoomLevel :one
22SELECT domain, zoom_factor, updated_at FROM zoom_levels WHERE domain = ? LIMIT 1
23`
24
25func (q *Queries) GetZoomLevel(ctx context.Context, domain string) (ZoomLevel, error) {
26 row := q.db.QueryRowContext(ctx, GetZoomLevel, domain)
27 var i ZoomLevel
28 err := row.Scan(&i.Domain, &i.ZoomFactor, &i.UpdatedAt)
29 return i, err
30}
31
32const ListZoomLevels = `-- name: ListZoomLevels :many
33SELECT domain, zoom_factor, updated_at FROM zoom_levels ORDER BY updated_at DESC
34`
35
36func (q *Queries) ListZoomLevels(ctx context.Context) ([]ZoomLevel, error) {
37 rows, err := q.db.QueryContext(ctx, ListZoomLevels)
38 if err != nil {
39 return nil, err
40 }
41 defer rows.Close()
42 items := []ZoomLevel{}
43 for rows.Next() {
44 var i ZoomLevel
45 if err := rows.Scan(&i.Domain, &i.ZoomFactor, &i.UpdatedAt); err != nil {
46 return nil, err
47 }
48 items = append(items, i)
49 }
50 if err := rows.Close(); err != nil {
51 return nil, err
52 }
53 if err := rows.Err(); err != nil {
54 return nil, err
55 }
56 return items, nil
57}
58
59const SetZoomLevel = `-- name: SetZoomLevel :exec
60INSERT INTO zoom_levels (domain, zoom_factor, updated_at)
61VALUES (?, ?, CURRENT_TIMESTAMP)
62ON CONFLICT(domain) DO UPDATE SET
63 zoom_factor = excluded.zoom_factor,
64 updated_at = CURRENT_TIMESTAMP
65`
66
67type SetZoomLevelParams struct {
68 Domain string `json:"domain"`
69 ZoomFactor float64 `json:"zoom_factor"`
70}
71
72func (q *Queries) SetZoomLevel(ctx context.Context, arg SetZoomLevelParams) error {
73 _, err := q.db.ExecContext(ctx, SetZoomLevel, arg.Domain, arg.ZoomFactor)
74 return err
75}