Files

59 lines
2.4 KiB
Go

package postgres
import (
"context"
"github.com/google/uuid"
"github.com/jackc/pgx/v5"
"gitea.privcloud.tech/vlad_marlo/mtusi2026lab2/internal/model/dto"
)
// CreateChat commits the chat and every member together, rolling back on any failure.
func (s *Store) CreateChat(ctx context.Context, chat dto.ChatDTO) (dto.ChatDTO, 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, `INSERT INTO chats(id,title) VALUES(@id,@title) RETURNING created_at`, pgx.StrictNamedArgs{"id": chat.ID, "title": chat.Title}).Scan(&chat.CreatedAt); err != nil {
return err
}
_, err := tx.Exec(ctx, `INSERT INTO chat_members(chat_id,user_id) SELECT @chat,id FROM unnest(@members::uuid[]) AS member(id)`, pgx.StrictNamedArgs{"chat": chat.ID, "members": chat.MemberIDs})
return err
})
return chat, normalize(err)
}
// Chat reads a chat and its immutable membership in one snapshot.
func (s *Store) Chat(ctx context.Context, id uuid.UUID) (dto.ChatDTO, error) {
ctx, cancel := context.WithTimeout(ctx, s.timeout)
defer cancel()
var chat dto.ChatDTO
err := s.pool.QueryRow(ctx, `SELECT c.id,c.title,c.created_at,ARRAY(SELECT user_id FROM chat_members WHERE chat_id=c.id ORDER BY user_id)
FROM chats c WHERE c.id=@id`, pgx.StrictNamedArgs{"id": id}).Scan(&chat.ID, &chat.Title, &chat.CreatedAt, &chat.MemberIDs)
return chat, normalize(err)
}
// Chats returns the requested keyset page of chats visible to a user.
func (s *Store) Chats(ctx context.Context, userID uuid.UUID, position dto.PositionDTO, limit int) ([]dto.ChatDTO, error) {
ctx, cancel := context.WithTimeout(ctx, s.timeout)
defer cancel()
rows, err := s.pool.Query(ctx, `SELECT c.id,c.title,c.created_at,ARRAY(SELECT user_id FROM chat_members WHERE chat_id=c.id ORDER BY user_id)
FROM chats c JOIN chat_members m ON m.chat_id=c.id
WHERE m.user_id=@user AND (c.created_at,c.id)>(@time,@id) ORDER BY c.created_at,c.id LIMIT @limit`, pgx.StrictNamedArgs{
"user": userID, "time": position.CreatedAt, "id": position.ID, "limit": limit,
})
if err != nil {
return nil, normalize(err)
}
defer rows.Close()
chats := make([]dto.ChatDTO, 0)
for rows.Next() {
var chat dto.ChatDTO
if err := rows.Scan(&chat.ID, &chat.Title, &chat.CreatedAt, &chat.MemberIDs); err != nil {
return nil, normalize(err)
}
chats = append(chats, chat)
}
return chats, normalize(rows.Err())
}