mirror of
https://github.com/SamyRai/tercul-backend.git
synced 2025-12-27 04:01:34 +00:00
d50722dad5
Some checks failed
- Updated database models and repositories to replace uint IDs with UUIDs. - Modified test fixtures to generate and use UUIDs for authors, translations, users, and works. - Adjusted mock implementations to align with the new UUID structure. - Ensured all relevant functions and methods are updated to handle UUIDs correctly. - Added necessary imports for UUID handling in various files.
73 lines
2.2 KiB
Go
73 lines
2.2 KiB
Go
package sql
|
|
|
|
import (
|
|
"context"
|
|
"errors"
|
|
"tercul/internal/domain"
|
|
"tercul/internal/platform/config"
|
|
|
|
"github.com/google/uuid"
|
|
"go.opentelemetry.io/otel"
|
|
"go.opentelemetry.io/otel/trace"
|
|
"gorm.io/gorm"
|
|
)
|
|
|
|
type categoryRepository struct {
|
|
*BaseRepositoryImpl[domain.Category]
|
|
db *gorm.DB
|
|
tracer trace.Tracer
|
|
}
|
|
|
|
// NewCategoryRepository creates a new CategoryRepository.
|
|
func NewCategoryRepository(db *gorm.DB, cfg *config.Config) domain.CategoryRepository {
|
|
return &categoryRepository{
|
|
BaseRepositoryImpl: NewBaseRepositoryImpl[domain.Category](db, cfg),
|
|
db: db,
|
|
tracer: otel.Tracer("category.repository"),
|
|
}
|
|
}
|
|
|
|
// FindByName finds a category by name
|
|
func (r *categoryRepository) FindByName(ctx context.Context, name string) (*domain.Category, error) {
|
|
ctx, span := r.tracer.Start(ctx, "FindByName")
|
|
defer span.End()
|
|
var category domain.Category
|
|
if err := r.db.WithContext(ctx).Where("name = ?", name).First(&category).Error; err != nil {
|
|
if errors.Is(err, gorm.ErrRecordNotFound) {
|
|
return nil, domain.ErrEntityNotFound
|
|
}
|
|
return nil, err
|
|
}
|
|
return &category, nil
|
|
}
|
|
|
|
// ListByWorkID finds categories by work ID
|
|
func (r *categoryRepository) ListByWorkID(ctx context.Context, workID uuid.UUID) ([]domain.Category, error) {
|
|
ctx, span := r.tracer.Start(ctx, "ListByWorkID")
|
|
defer span.End()
|
|
var categories []domain.Category
|
|
if err := r.db.WithContext(ctx).Joins("JOIN work_categories ON work_categories.category_id = categories.id").
|
|
Where("work_categories.work_id = ?", workID).
|
|
Find(&categories).Error; err != nil {
|
|
return nil, err
|
|
}
|
|
return categories, nil
|
|
}
|
|
|
|
// ListByParentID finds categories by parent ID
|
|
func (r *categoryRepository) ListByParentID(ctx context.Context, parentID *uuid.UUID) ([]domain.Category, error) {
|
|
ctx, span := r.tracer.Start(ctx, "ListByParentID")
|
|
defer span.End()
|
|
var categories []domain.Category
|
|
if parentID == nil {
|
|
if err := r.db.WithContext(ctx).Where("parent_id IS NULL").Find(&categories).Error; err != nil {
|
|
return nil, err
|
|
}
|
|
} else {
|
|
if err := r.db.WithContext(ctx).Where("parent_id = ?", *parentID).Find(&categories).Error; err != nil {
|
|
return nil, err
|
|
}
|
|
}
|
|
return categories, nil
|
|
}
|