Files
mtusi2026lab2/internal/storage/message_postgres.go

122 lines
2.4 KiB
Go

package storage
import (
"context"
"errors"
"fmt"
"time"
"github.com/google/uuid"
"github.com/jackc/pgx/v5"
"github.com/jackc/pgx/v5/pgconn"
"github.com/jackc/pgx/v5/pgxpool"
"mtusi2026lab2/internal/model"
)
var ErrMessageMemberNotFound = errors.New("sender is not a chat member")
type MessageStore struct {
pool *pgxpool.Pool
}
func NewMessageStore(pool *pgxpool.Pool) *MessageStore {
return &MessageStore{pool: pool}
}
func (s *MessageStore) CreateMessage(
ctx context.Context,
message model.Message,
) error {
const query = `
INSERT INTO messages (
id, chat_id, sender_id, text, created_at
)
VALUES ($1, $2, $3, $4, $5)
`
_, err := s.pool.Exec(ctx, query,
message.ID,
message.ChatID,
message.SenderID,
message.Text,
message.CreatedAt,
)
if err != nil {
var pgErr *pgconn.PgError
if errors.As(err, &pgErr) && pgErr.Code == "23503" {
return ErrMessageMemberNotFound
}
return fmt.Errorf("create message: %w", err)
}
return nil
}
// ListMessages implements keyset pagination.
// Cursor is the created_at + id of the previous page's last item.
func (s *MessageStore) ListMessages(
ctx context.Context,
chatID uuid.UUID,
limit int,
cursorTime *time.Time,
cursorID *uuid.UUID,
) ([]model.Message, bool, error) {
var rows pgx.Rows
var err error
if cursorTime == nil || cursorID == nil {
rows, err = s.pool.Query(ctx, `
SELECT id, chat_id, sender_id, text, created_at
FROM messages
WHERE chat_id = $1
ORDER BY created_at, id
LIMIT $2
`, chatID, limit+1)
} else {
rows, err = s.pool.Query(ctx, `
SELECT id, chat_id, sender_id, text, created_at
FROM messages
WHERE chat_id = $1
AND (created_at, id) > ($2, $3)
ORDER BY created_at, id
LIMIT $4
`, chatID, *cursorTime, *cursorID, limit+1)
}
if err != nil {
return nil, false, fmt.Errorf("list messages: %w", err)
}
defer rows.Close()
messages := make([]model.Message, 0, limit+1)
for rows.Next() {
var message model.Message
if err := rows.Scan(
&message.ID,
&message.ChatID,
&message.SenderID,
&message.Text,
&message.CreatedAt,
); err != nil {
return nil, false, fmt.Errorf("scan message: %w", err)
}
messages = append(messages, message)
}
if err := rows.Err(); err != nil {
return nil, false, fmt.Errorf("iterate messages: %w", err)
}
hasMore := len(messages) > limit
if hasMore {
messages = messages[:limit]
}
return messages, hasMore, nil
}