blob: 490475de372f48c8d0ba292af6b00c2b00ca1d95 (
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: CreateCalendar :one
INSERT INTO calendars (
user_id, name, key
) VALUES (
$1, $2, $3
)
RETURNING *;
-- name: GetCalendarForUser :one
SELECT * FROM calendars
WHERE user_id = $1 LIMIT 1;
-- name: GetCalendarByName :one
SELECT * FROM calendars
WHERE name = $1 LIMIT 1;
-- name: DeleteCalendar :execrows
DELETE FROM calendars
WHERE user_id = $1;
-- name: DeleteCalendarByName :execrows
DELETE FROM calendars
WHERE name = $1;
|
