diff options
| author | Kyren223 <Kyren223@proton.me> | 2024-11-23 17:10:29 +0200 |
|---|---|---|
| committer | Kyren223 <Kyren223@proton.me> | 2024-11-23 17:10:29 +0200 |
| commit | 63a1d24295122728820a61aa93b3da6cd6d401d9 (patch) | |
| tree | 04f0ecce4fb19682cbab969d20861eadeefff59b /internal/data/messages.sql.go | |
| parent | ae6362c91f2d5d51cc606c9baed9c76b50e7ddfe (diff) | |
Updated user queries and added trigger on user delete
Diffstat (limited to 'internal/data/messages.sql.go')
| -rw-r--r-- | internal/data/messages.sql.go | 6 |
1 files changed, 4 insertions, 2 deletions
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 { |