blob: 7acac3f136ed13e9668bb3dd3a4d85f9a0c3019e (
plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
|
-- name: CreateConference :one
INSERT INTO conferences (
url, title, venue, city
) VALUES (
$1, $2, $3, $4
)
RETURNING *;
-- name: UpdateConferenceDetails :one
UPDATE conferences SET (
title, venue, city
) = ($2, $3, $4)
WHERE id = $1
RETURNING *;
-- name: GetConferences :many
SELECT * FROM conferences;
-- name: DeleteConference :exec
DELETE FROM conferences
WHERE id = $1;
|
