this repo has no description
1-- name: InsertPost :exec
2insert or ignore into posts (uri, create_ts, likes) values (?, ?, ?);
3
4-- name: InsertLang :exec
5insert or ignore into langs (uri, lang) values (?, ?);
6
7-- name: UpdateLikes :exec
8update posts set likes = likes + 1 where uri = ?;
9
10-- name: TrimPosts :exec
11delete from posts where create_ts < unixepoch('now', '-24 hours');
12
13-- name: ViewFeed :many
14select posts.uri, create_ts, likes, lang
15from posts
16left join langs on posts.uri = langs.uri
17order by likes desc
18limit ? offset ?;