forked from mtusi2026/mtusi2026lab4
53 lines
2.2 KiB
Go
53 lines
2.2 KiB
Go
package postgres
|
|
|
|
import (
|
|
"context"
|
|
"errors"
|
|
"slices"
|
|
|
|
"github.com/jackc/pgx/v5"
|
|
|
|
"gitea.privcloud.tech/vlad_marlo/mtusi2026lab4/internal/model/dto"
|
|
"gitea.privcloud.tech/vlad_marlo/mtusi2026lab4/internal/store"
|
|
)
|
|
|
|
// replayMessage serializes one chat and returns an unexpired original response.
|
|
func replayMessage(ctx context.Context, tx pgx.Tx, message dto.MessageDTO) (dto.MessageDTO, bool, error) {
|
|
var locked string
|
|
if err := tx.QueryRow(ctx, "SELECT id FROM chats WHERE id=@chat FOR UPDATE", pgx.StrictNamedArgs{"chat": message.ChatID}).Scan(&locked); err != nil {
|
|
return dto.MessageDTO{}, false, err
|
|
}
|
|
if message.IdempotencyKey == "" {
|
|
return dto.MessageDTO{}, false, nil
|
|
}
|
|
args := pgx.StrictNamedArgs{"user": message.SenderID, "chat": message.ChatID, "key": message.IdempotencyKey}
|
|
if _, err := tx.Exec(ctx, `DELETE FROM message_idempotency WHERE user_id=@user AND chat_id=@chat AND key=@key AND expires_at<=clock_timestamp()`, args); err != nil {
|
|
return dto.MessageDTO{}, false, err
|
|
}
|
|
var original dto.MessageDTO
|
|
err := tx.QueryRow(ctx, `SELECT m.id,m.chat_id,m.sender_id,m.text,m.created_at,m.attachment_ids FROM message_idempotency i JOIN messages m ON m.id=i.message_id
|
|
WHERE i.user_id=@user AND i.chat_id=@chat AND i.key=@key`, args).Scan(&original.ID, &original.ChatID, &original.SenderID, &original.Text, &original.CreatedAt, &original.AttachmentIDs)
|
|
if errors.Is(err, pgx.ErrNoRows) {
|
|
return dto.MessageDTO{}, false, nil
|
|
}
|
|
if err != nil {
|
|
return dto.MessageDTO{}, false, err
|
|
}
|
|
if original.Text != message.Text || !slices.Equal(original.AttachmentIDs, message.AttachmentIDs) {
|
|
return dto.MessageDTO{}, false, store.ErrConflict
|
|
}
|
|
return original, true, nil
|
|
}
|
|
|
|
// rememberMessage stores the result in the same transaction as the message insert.
|
|
func rememberMessage(ctx context.Context, tx pgx.Tx, message dto.MessageDTO) error {
|
|
if message.IdempotencyKey == "" {
|
|
return nil
|
|
}
|
|
_, err := tx.Exec(ctx, `INSERT INTO message_idempotency(user_id,chat_id,key,message_id,expires_at)
|
|
VALUES(@user,@chat,@key,@id,clock_timestamp()+interval '24 hours')`, pgx.StrictNamedArgs{
|
|
"user": message.SenderID, "chat": message.ChatID, "key": message.IdempotencyKey, "id": message.ID,
|
|
})
|
|
return err
|
|
}
|