this repo has no description
edavis.dev
1// Code generated by sqlc. DO NOT EDIT.
2// versions:
3// sqlc v1.27.0
4// source: query.sql
5
6package mostliked
7
8import (
9 "context"
10)
11
12const insertLang = `-- name: InsertLang :exec
13insert or ignore into langs (uri, lang) values (?, ?)
14`
15
16type InsertLangParams struct {
17 Uri string
18 Lang string
19}
20
21func (q *Queries) InsertLang(ctx context.Context, arg InsertLangParams) error {
22 _, err := q.db.ExecContext(ctx, insertLang, arg.Uri, arg.Lang)
23 return err
24}
25
26const insertPost = `-- name: InsertPost :exec
27insert or ignore into posts (uri, create_ts, likes) values (?, ?, ?)
28`
29
30type InsertPostParams struct {
31 Uri string
32 CreateTs int64
33 Likes int64
34}
35
36func (q *Queries) InsertPost(ctx context.Context, arg InsertPostParams) error {
37 _, err := q.db.ExecContext(ctx, insertPost, arg.Uri, arg.CreateTs, arg.Likes)
38 return err
39}
40
41const trimPosts = `-- name: TrimPosts :exec
42delete from posts where create_ts < unixepoch('now', '-24 hours')
43`
44
45func (q *Queries) TrimPosts(ctx context.Context) error {
46 _, err := q.db.ExecContext(ctx, trimPosts)
47 return err
48}
49
50const updateLikes = `-- name: UpdateLikes :exec
51update posts set likes = likes + 1 where uri = ?
52`
53
54func (q *Queries) UpdateLikes(ctx context.Context, uri string) error {
55 _, err := q.db.ExecContext(ctx, updateLikes, uri)
56 return err
57}