Added the ability to delete messages in frequencies

1 files changed, 19 insertions, 0 deletions

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
+}