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

namespace Infrastructure.Persistence.Configurations.Members;

public sealed class ChannelHandleHistoryConfiguration : IEntityTypeConfiguration<ChannelHandleHistory>
{
    public void Configure(EntityTypeBuilder<ChannelHandleHistory> builder)
    {
        builder.HasOne(x => x.Channel).WithMany().HasForeignKey(x => x.ChannelID).OnDelete(DeleteBehavior.Cascade);

        builder.ToTable(nameof(ChannelHandleHistory), x => x.HasComment("채널 핸들 변경 이력"));
        builder.HasKey(x => x.ID);
        builder.Property(x => x.ID).ValueGeneratedOnAdd().HasComment("PK");
        builder.Property(x => x.ChannelID).IsRequired().HasComment("채널 ID");
        builder.Property(x => x.OldHandle).HasMaxLength(30).IsRequired().HasComment("이전 핸들");
        builder.Property(x => x.ChangedAt).IsRequired().HasComment("변경 일시");

        builder.HasIndex(x => x.OldHandle);
        builder.HasIndex(x => new { x.ChannelID, x.ChangedAt }).IsDescending(false, true);
    }
}