using Domain.Entities.Feed;
using Microsoft.EntityFrameworkCore;
using Microsoft.EntityFrameworkCore.Metadata.Builders;

namespace Infrastructure.Persistence.Configurations.Feed;

public sealed class FeedCommentConfiguration : IEntityTypeConfiguration<FeedComment>
{
    public void Configure(EntityTypeBuilder<FeedComment> builder)
    {
        builder.HasIndex(x => x.FeedPostID);
        builder.HasIndex(x => x.MemberID);
        builder.HasIndex(x => x.ParentID);
        builder.HasIndex(x => new { x.FeedPostID, x.IsDeleted, x.ParentID, x.CreatedAt }).IsDescending(false, false, false, true);
        builder.HasIndex(x => new { x.FeedPostID, x.IsDeleted, x.ParentID, x.Score, x.ID }).IsDescending(false, false, false, true, true);
        builder.HasIndex(x => new { x.FeedPostID, x.MemberID, x.IsDeleted, x.ParentID, x.CreatedAt }).IsDescending(false, false, false, false, true);

        builder.HasOne(x => x.FeedPost).WithMany(x => x.FeedComment).HasForeignKey(x => x.FeedPostID).OnDelete(DeleteBehavior.Cascade);
        builder.HasOne(x => x.Member).WithMany().HasForeignKey(x => x.MemberID).OnDelete(DeleteBehavior.Restrict);
        builder.HasOne(x => x.Parent).WithMany(x => x.Children).HasForeignKey(x => x.ParentID).OnDelete(DeleteBehavior.Restrict);

        builder.HasMany(x => x.FeedCommentLike).WithOne(x => x.FeedComment).HasForeignKey(x => x.FeedCommentID).OnDelete(DeleteBehavior.Cascade);

        builder.ToTable(nameof(FeedComment), t => t.HasComment("피드 댓글 (Reddit식 계층형)"));
        builder.HasKey(x => x.ID);
        builder.Property(x => x.ID).ValueGeneratedOnAdd().HasComment("PK");
        builder.Property(x => x.FeedPostID).IsRequired().HasComment("FeedPost ID");
        builder.Property(x => x.MemberID).IsRequired().HasComment("작성 회원 ID");
        builder.Property(x => x.ParentID).HasComment("부모 댓글 ID (대댓글용)");
        builder.Property(x => x.Depth).IsRequired().HasComment("중첩 깊이 (0 = 루트)");
        builder.Property(x => x.Content).HasMaxLength(2000).IsRequired().HasComment("댓글 내용");
        builder.Property(x => x.Likes).IsRequired().HasComment("좋아요 수");
        builder.Property(x => x.Replies).IsRequired().HasComment("자식 댓글 수");
        builder.Property(x => x.Reports).IsRequired().HasComment("신고 수");
        builder.Property(x => x.Score).IsRequired().HasComment("랭킹 스코어");
        builder.Property(x => x.IsDeleted).IsRequired().HasComment("삭제 여부");
        builder.Property(x => x.IpAddress).HasMaxLength(50);
        builder.Property(x => x.UserAgent).HasMaxLength(255);
        builder.Property(x => x.DeletedAt).HasComment("삭제 일시");
        builder.Property(x => x.UpdatedAt).HasComment("수정 일시");
        builder.Property(x => x.CreatedAt).IsRequired().HasComment("등록 일시");
    }
}