blob: c3450680f3b05ec59bec4c4f19355b7b1a0e8071 (
plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
|
-- name: ListMessages :many
SELECT * FROM messages
ORDER BY id;
-- name: CreateMessage :one
INSERT INTO messages (
id, content, sender_id, frequency_id, receiver_id
) VALUES (
?, ?, ?, ?, ?
)
RETURNING *;
-- name: EditMessage :one
UPDATE messages SET
edited = true,
content = ?
WHERE id = ?
RETURNING *;
|
