Added message queries

1 files changed, 13 insertions, 1 deletions

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 = ?;