mirror of
https://github.com/Kyren223/eko.git
synced 2025-09-07 05:58:21 +00:00
35 lines
661 B
SQL
35 lines
661 B
SQL
-- name: GetMessageById :one
|
|
SELECT * FROM messages
|
|
WHERE id = ?;
|
|
|
|
-- name: GetFrequencyMessages :many
|
|
SELECT * FROM messages
|
|
WHERE frequency_id = ?
|
|
ORDER BY id;
|
|
|
|
-- name: GetDirectMessages :many
|
|
SELECT * FROM messages
|
|
WHERE
|
|
(sender_id = @user1 AND receiver_id = @user2) OR
|
|
(sender_id = @user2 AND receiver_id = @user1)
|
|
ORDER BY id;
|
|
|
|
-- name: CreateMessage :one
|
|
INSERT INTO messages (
|
|
id, content, sender_id, frequency_id, receiver_id, ping
|
|
) VALUES (
|
|
?, ?, ?, ?, ?, ?
|
|
)
|
|
RETURNING *;
|
|
|
|
-- name: EditMessage :one
|
|
UPDATE messages SET
|
|
edited = true,
|
|
content = ?
|
|
WHERE id = ?
|
|
RETURNING *;
|
|
|
|
-- name: DeleteMessage :exec
|
|
DELETE FROM messages
|
|
WHERE id = ?;
|