Files

53 lines
2.2 KiB
Go

package postgres
import (
"context"
"errors"
"slices"
"github.com/jackc/pgx/v5"
"gitea.privcloud.tech/vlad_marlo/mtusi2026lab5/internal/model/dto"
"gitea.privcloud.tech/vlad_marlo/mtusi2026lab5/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
}