using MatDenDagen.Models;
using Microsoft.EntityFrameworkCore;

namespace MatDenDagen.Infrastructure.Storage.Database;

public sealed class QuestionnaireContext(DbContextOptions<QuestionnaireContext> options) : DbContext(options)
{
    public required DbSet<Question> Questions { get; init; }
    public required DbSet<Submission> Submissions { get; init; }
    public required DbSet<Participant> Participants { get; init; }

    protected override void OnModelCreating(ModelBuilder modelBuilder)
    {
        var questionBuilder = modelBuilder.Entity<Question>();
        questionBuilder.HasKey(q => q.Id);
        questionBuilder.Property(q => q.Text);

        var submissionBuilder = modelBuilder.Entity<Submission>();
        submissionBuilder.HasKey(s => s.Id);
        submissionBuilder.HasMany(s => s.Answers).WithOne();
        submissionBuilder.HasMany(s => s.Uploads).WithOne();
        submissionBuilder.HasOne<Participant>().WithMany().HasForeignKey(s => s.Participant);

        var answerBuilder = modelBuilder.Entity<Answer>();
        answerBuilder.HasKey(a => a.Id);
        answerBuilder.Property(a => a.Text);
        answerBuilder.HasOne<Question>().WithMany().HasForeignKey(a => a.QuestionId);

        var uploadBuilder = modelBuilder.Entity<Upload>();
        uploadBuilder.HasKey(u => u.Id);
        uploadBuilder.Property(u => u.Name);

        var participantBuilder = modelBuilder.Entity<Participant>();
        participantBuilder.HasKey(p => p.Id);
        participantBuilder.Property(p => p.Name);
        participantBuilder.HasIndex(p => p.PhoneNumber).IsUnique();
    }
}