From 58c6a6d38a5ebbd7bfc9c698227b931a2252e140 Mon Sep 17 00:00:00 2001 From: Kyren223 Date: Tue, 14 Jan 2025 19:09:18 +0200 Subject: Added the ability to delete messages in frequencies --- internal/data/messages.sql.go | 19 +++++++++++++++++++ 1 file changed, 19 insertions(+) (limited to 'internal/data') diff --git a/internal/data/messages.sql.go b/internal/data/messages.sql.go index 43edb7d..a3d8257 100644 --- a/internal/data/messages.sql.go +++ b/internal/data/messages.sql.go @@ -163,3 +163,22 @@ func (q *Queries) GetFrequencyMessages(ctx context.Context, frequencyID *snowfla } return items, nil } + +const getMessageById = `-- name: GetMessageById :one +SELECT id, sender_id, content, edited, frequency_id, receiver_id FROM messages +WHERE id = ? +` + +func (q *Queries) GetMessageById(ctx context.Context, id snowflake.ID) (Message, error) { + row := q.db.QueryRowContext(ctx, getMessageById, id) + var i Message + err := row.Scan( + &i.ID, + &i.SenderID, + &i.Content, + &i.Edited, + &i.FrequencyID, + &i.ReceiverID, + ) + return i, err +} -- cgit v1.3.1