namespace marlin.web.Data;

using System.Linq.Expressions;
using System.Text.Json;
using core;
using core.functional;
using core.models;
using Microsoft.EntityFrameworkCore;
using Microsoft.EntityFrameworkCore.Storage.ValueConversion;
using Models;

// user-based session grant
// agent id/token grant
// agent job claim session grant
// service grant
public interface IActiveGrant
{
    bool CanAccessSource(Guid sourceId);
}

public class ApplicationDbContext : DbContext
{
    public DbSet<VersionControlSource> Sources => this.Set<VersionControlSource>();
    public DbSet<VersionControlledBranch> SourceBranches => this.Set<VersionControlledBranch>();
    public DbSet<VersionControlledCommit> SourceCommits => this.Set<VersionControlledCommit>();
    public DbSet<VersionControlledBlob> SourceBlobs => this.Set<VersionControlledBlob>();
    public DbSet<VersionControlSecret> Secrets => this.Set<VersionControlSecret>();
    public DbSet<Job> Jobs => this.Set<Job>();
    public DbSet<Agent> Agents => this.Set<Agent>();
    public DbSet<WorkflowSnapshot> WorkflowSnapshots => this.Set<WorkflowSnapshot>();
    
    public ApplicationDbContext(DbContextOptions<ApplicationDbContext> options)
        : base(options) { }

    protected override void OnModelCreating(ModelBuilder modelBuilder)
    {
        modelBuilder
            .Entity<Agent>()
            .Property(p => p.Capabilities)
            .HasJsonConversion();

        modelBuilder
            .Entity<VersionControlledCommit>()
            .HasAlternateKey(x => new { x.SourceId, x.Hash });

        modelBuilder
            .Entity<VersionControlSecret>()
            .Property(p => p.Content)
            .HasJsonConversion();

        modelBuilder
            .Entity<VersionControlledCommit>()
            .HasOne(x => x.WorkflowSnapshot)
            .WithOne(x => x.Commit)
            .HasForeignKey<WorkflowSnapshot>(x => x.CommitId);

        modelBuilder
            .Entity<WorkflowSnapshot>()
            .Property(p => p.Workflow)
            .HasJsonConversion();

        base.OnModelCreating(modelBuilder);
    }
}