blob: a903ac7024c7b2dfeb7b29c0475f469f6b6e6b54 (
plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
|
-- name: GetFavouritesForUserConference :many
SELECT * FROM favourites
WHERE user_id = $1 AND conference_id = $2;
-- name: GetFavouritesForUser :many
SELECT * FROM favourites
WHERE user_id = $1;
-- name: CreateFavourite :one
INSERT INTO favourites (
user_id, event_guid, event_id, conference_id
) VALUES (
$1, $2, $3, $4
)
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 AND conference_id = $4;
|
