query/messages.sql


1
2
3
4
5
6
7
8
9
10
11

-- 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 *;