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