forked from mtusi2026/mtusi2026lab2
51 lines
2.0 KiB
Go
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())
|
|
}
|