From 91bbd29dbe2738459cef83b5204844a2c136a84f Mon Sep 17 00:00:00 2001 From: Kyren223 Date: Sat, 23 Nov 2024 22:41:28 +0200 Subject: Added message queries --- query/messages.sql | 14 +++++++++++++- 1 file changed, 13 insertions(+), 1 deletion(-) (limited to 'query/messages.sql') diff --git a/query/messages.sql b/query/messages.sql index c345068..f7be629 100644 --- a/query/messages.sql +++ b/query/messages.sql @@ -1,5 +1,13 @@ --- name: ListMessages :many +-- 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 @@ -16,3 +24,7 @@ UPDATE messages SET content = ? WHERE id = ? RETURNING *; + +-- name: DeleteMessage :exec +DELETE FROM messages +WHERE id = ?; -- cgit v1.3.1