From 63a1d24295122728820a61aa93b3da6cd6d401d9 Mon Sep 17 00:00:00 2001 From: Kyren223 Date: Sat, 23 Nov 2024 17:10:29 +0200 Subject: Updated user queries and added trigger on user delete --- internal/data/messages.sql.go | 6 ++++-- 1 file changed, 4 insertions(+), 2 deletions(-) (limited to 'internal/data/messages.sql.go') diff --git a/internal/data/messages.sql.go b/internal/data/messages.sql.go index e84b306..33e010d 100644 --- a/internal/data/messages.sql.go +++ b/internal/data/messages.sql.go @@ -17,7 +17,7 @@ INSERT INTO messages ( ) VALUES ( ?, ?, ?, ?, ? ) -RETURNING id, sender_id, content, frequency_id, receiver_id +RETURNING id, sender_id, content, edited, frequency_id, receiver_id ` type CreateMessageParams struct { @@ -41,6 +41,7 @@ func (q *Queries) CreateMessage(ctx context.Context, arg CreateMessageParams) (M &i.ID, &i.SenderID, &i.Content, + &i.Edited, &i.FrequencyID, &i.ReceiverID, ) @@ -48,7 +49,7 @@ func (q *Queries) CreateMessage(ctx context.Context, arg CreateMessageParams) (M } const listMessages = `-- name: ListMessages :many -SELECT id, sender_id, content, frequency_id, receiver_id FROM messages +SELECT id, sender_id, content, edited, frequency_id, receiver_id FROM messages ORDER BY id ` @@ -65,6 +66,7 @@ func (q *Queries) ListMessages(ctx context.Context) ([]Message, error) { &i.ID, &i.SenderID, &i.Content, + &i.Edited, &i.FrequencyID, &i.ReceiverID, ); err != nil { -- cgit v1.3.1