keii.dev
1-- name: CreateUserLikePost :exec
2INSERT INTO
3 user_like_post (user_id, post_id, status)
4VALUES
5 (?, ?, ?);
6
7-- name: CreateUserLikePostComment :exec
8INSERT INTO
9 user_like_post (user_id, post_id, status)
10VALUES
11 (?, ?, ?);
12
13-- name: GetUserPostLikes :one
14SELECT
15 user_like_post.id,
16 user_like_post.user_id,
17 user_like_post.post_id,
18 user_like_post.status
19FROM
20 user_like_post
21WHERE
22 user_like_post.user_id = ?
23 AND user_like_post.post_id = ?;
24
25-- name: GetUserPostCommentLikes :one
26SELECT
27 user_like_post_comment.id,
28 user_like_post_comment.user_id,
29 user_like_post_comment.post_comment_id,
30 user_like_post_comment.status
31FROM
32 user_like_post_comment
33WHERE
34 user_like_post_comment.user_id = ?
35 AND user_like_post_comment.post_comment_id = ?;
36
37-- name: UpdateUserLikePostStatus :exec
38UPDATE user_like_post
39SET
40 status = ?
41WHERE
42 id = ?;
43
44-- name: UpdateUserLikePostCommentStatus :exec
45UPDATE user_like_post_comment
46SET
47 status = ?
48WHERE
49 id = ?;