Files

51 lines
2.0 KiB
Go

package postgres
import (
"context"
"github.com/google/uuid"
"github.com/jackc/pgx/v5"
"gitea.privcloud.tech/vlad_marlo/mtusi2026lab2/internal/model/dto"
)
// CreateMessage serializes timestamps on the owning chat and atomically appends a message.
func (s *Store) CreateMessage(ctx context.Context, message dto.MessageDTO) (dto.MessageDTO, error) {
ctx, cancel := context.WithTimeout(ctx, s.timeout)
defer cancel()
err := pgx.BeginFunc(ctx, s.pool, func(tx pgx.Tx) error {
if err := tx.QueryRow(ctx, `UPDATE chats SET last_message_at=GREATEST(clock_timestamp(),last_message_at+interval '1 microsecond')
WHERE id=@chat RETURNING last_message_at`, pgx.StrictNamedArgs{"chat": message.ChatID}).Scan(&message.CreatedAt); err != nil {
return err
}
_, err := tx.Exec(ctx, `INSERT INTO messages(id,chat_id,sender_id,text,created_at) VALUES(@id,@chat,@sender,@text,@time)`, pgx.StrictNamedArgs{
"id": message.ID, "chat": message.ChatID, "sender": message.SenderID, "text": message.Text, "time": message.CreatedAt,
})
return err
})
return message, normalize(err)
}
// Messages reads an indexed keyset page without scanning earlier history.
func (s *Store) Messages(ctx context.Context, chatID uuid.UUID, position dto.PositionDTO, limit int) ([]dto.MessageDTO, error) {
ctx, cancel := context.WithTimeout(ctx, s.timeout)
defer cancel()
rows, err := s.pool.Query(ctx, `SELECT id,chat_id,sender_id,text,created_at FROM messages
WHERE chat_id=@chat AND (created_at,id)>(@time,@id) ORDER BY created_at,id LIMIT @limit`, pgx.StrictNamedArgs{
"chat": chatID, "time": position.CreatedAt, "id": position.ID, "limit": limit,
})
if err != nil {
return nil, normalize(err)
}
defer rows.Close()
messages := make([]dto.MessageDTO, 0)
for rows.Next() {
var message dto.MessageDTO
if err := rows.Scan(&message.ID, &message.ChatID, &message.SenderID, &message.Text, &message.CreatedAt); err != nil {
return nil, normalize(err)
}
messages = append(messages, message)
}
return messages, normalize(rows.Err())
}