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