using Microsoft.EntityFrameworkCore;
using Sakayaki.Models;

namespace Sakayaki.Services;

public sealed class AppDbContext : DbContext
{
    public AppDbContext(DbContextOptions<AppDbContext> options) : base(options)
    {
    }

    public DbSet<FanboxFolder> FanboxFolders => Set<FanboxFolder>();

    protected override void OnModelCreating(ModelBuilder modelBuilder)
    {
        base.OnModelCreating(modelBuilder);

        var entity = modelBuilder.Entity<FanboxFolder>();
        entity.ToTable("FanboxFolders");
        entity.HasKey(x => x.Id);
        entity.Property(x => x.Id).ValueGeneratedOnAdd();
        entity.Property(x => x.CreatedAt).ValueGeneratedOnAdd();
        entity.Property(x => x.FolderName).HasMaxLength(255).IsRequired();
        entity.Property(x => x.Author).HasMaxLength(100).IsRequired();
        entity.Property(x => x.Date).HasColumnType("date").IsRequired();
        entity.Property(x => x.Title).HasMaxLength(255).IsRequired();
        entity.Property(x => x.Keywords).HasMaxLength(1024);
    }
}