blob: 94e914c07513ce591147a7c41a24ffe7cc504e8e (
plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
|
-- name: GetFavouritesForUser :many
SELECT * FROM favourites
WHERE user_id = $1;
-- name: CreateFavourite :one
INSERT INTO favourites (
user_id, event_guid, event_id
) VALUES (
$1, $2, $3
)
RETURNING *;
-- name: DeleteFavourite :exec
DELETE FROM favourites
WHERE id = $1;
-- name: DeleteFavouriteByEventDetails :execrows
DELETE FROM favourites
WHERE (event_guid = $1 OR event_id = $2) AND user_id = $3;
|
