forked from mtusi2026/mtusi2026lab2
79 lines
2.7 KiB
Go
79 lines
2.7 KiB
Go
package postgres
|
|
|
|
import (
|
|
"context"
|
|
"errors"
|
|
|
|
"github.com/google/uuid"
|
|
"github.com/jackc/pgx/v5"
|
|
|
|
"gitflic.ru/akselbant/mtusi2026lab1-fork/internal/pkg/domain"
|
|
chatusecase "gitflic.ru/akselbant/mtusi2026lab1-fork/internal/usecase/chat"
|
|
)
|
|
|
|
func (s *Storage) CreateChat(ctx context.Context, title string, members []string) (domain.Chat, error) {
|
|
ctx, cancel := context.WithTimeout(ctx, s.timeout)
|
|
defer cancel()
|
|
tx, err := s.pool.Begin(ctx)
|
|
if err != nil {
|
|
return domain.Chat{}, dbError(err)
|
|
}
|
|
defer tx.Rollback(context.WithoutCancel(ctx))
|
|
chat := domain.Chat{ID: uuid.NewString(), Title: title, MemberIDs: append([]string(nil), members...)}
|
|
err = tx.QueryRow(ctx, `INSERT INTO chats(id,title) VALUES($1,$2) RETURNING created_at`, chat.ID, title).Scan(&chat.CreatedAt)
|
|
if err != nil {
|
|
return domain.Chat{}, dbError(err)
|
|
}
|
|
for i, member := range members {
|
|
if _, err = tx.Exec(ctx, `INSERT INTO chat_members(chat_id,user_id,ordinal) VALUES($1,$2,$3)`, chat.ID, member, i); err != nil {
|
|
return domain.Chat{}, dbError(err)
|
|
}
|
|
}
|
|
if err = tx.Commit(ctx); err != nil {
|
|
return domain.Chat{}, dbError(err)
|
|
}
|
|
return chat, nil
|
|
}
|
|
|
|
const chatColumns = `c.id::text,c.title,c.created_at,ARRAY(SELECT m.user_id::text FROM chat_members m WHERE m.chat_id=c.id ORDER BY m.ordinal)`
|
|
|
|
func (s *Storage) ChatForUser(ctx context.Context, chatID, userID string) (domain.Chat, error) {
|
|
ctx, cancel := context.WithTimeout(ctx, s.timeout)
|
|
defer cancel()
|
|
var chat domain.Chat
|
|
err := s.pool.QueryRow(ctx, `SELECT `+chatColumns+` FROM chats c
|
|
WHERE c.id=$1 AND EXISTS(SELECT 1 FROM chat_members m WHERE m.chat_id=c.id AND m.user_id=$2)`, chatID, userID).
|
|
Scan(&chat.ID, &chat.Title, &chat.CreatedAt, &chat.MemberIDs)
|
|
if errors.Is(err, pgx.ErrNoRows) {
|
|
return chat, chatusecase.ErrChatNotFound
|
|
}
|
|
return chat, dbError(err)
|
|
}
|
|
|
|
func (s *Storage) ListChats(ctx context.Context, userID string, after *domain.Position, limit int) ([]domain.Chat, error) {
|
|
ctx, cancel := context.WithTimeout(ctx, s.timeout)
|
|
defer cancel()
|
|
query := `SELECT ` + chatColumns + ` FROM chats c JOIN chat_members member ON member.chat_id=c.id
|
|
WHERE member.user_id=$1`
|
|
args := []any{userID, limit}
|
|
if after != nil {
|
|
query += ` AND (c.created_at,c.id)>($3,$4)`
|
|
args = append(args, after.CreatedAt, after.ID)
|
|
}
|
|
query += ` ORDER BY c.created_at,c.id LIMIT $2`
|
|
rows, err := s.pool.Query(ctx, query, args...)
|
|
if err != nil {
|
|
return nil, dbError(err)
|
|
}
|
|
defer rows.Close()
|
|
chats := make([]domain.Chat, 0)
|
|
for rows.Next() {
|
|
var chat domain.Chat
|
|
if err = rows.Scan(&chat.ID, &chat.Title, &chat.CreatedAt, &chat.MemberIDs); err != nil {
|
|
return nil, dbError(err)
|
|
}
|
|
chats = append(chats, chat)
|
|
}
|
|
return chats, dbError(rows.Err())
|
|
}
|