summaryrefslogtreecommitdiff
path: root/query/messages.sql
diff options
context:
space:
mode:
authorKyren223 <Kyren223@proton.me>2025-01-14 19:09:18 +0200
committerKyren223 <Kyren223@proton.me>2025-01-14 19:09:18 +0200
commit58c6a6d38a5ebbd7bfc9c698227b931a2252e140 (patch)
treefd08e25f2c53e6f035a90b02de615c7190856b21 /query/messages.sql
parent2e1707c45bc78523fa91880dcd407ea886863a68 (diff)
Added the ability to delete messages in frequencies
Diffstat (limited to 'query/messages.sql')
-rw-r--r--query/messages.sql4
1 files changed, 4 insertions, 0 deletions
diff --git a/query/messages.sql b/query/messages.sql
index f7be629..063b576 100644
--- a/query/messages.sql
+++ b/query/messages.sql
@@ -1,3 +1,7 @@
+-- name: GetMessageById :one
+SELECT * FROM messages
+WHERE id = ?;
+
-- name: GetFrequencyMessages :many
SELECT * FROM messages
WHERE frequency_id = ?