| | | 1 | | using ArturRios.Heimdall.Domain.Entities; |
| | | 2 | | using Microsoft.EntityFrameworkCore; |
| | | 3 | | using Microsoft.EntityFrameworkCore.Metadata.Builders; |
| | | 4 | | |
| | | 5 | | namespace ArturRios.Heimdall.Data.EntityMaps; |
| | | 6 | | |
| | | 7 | | internal static class ApplicationDbMap |
| | | 8 | | { |
| | | 9 | | public static void Configure(this EntityTypeBuilder<Application> application) |
| | | 10 | | { |
| | 4 | 11 | | application.ToTable("application"); |
| | | 12 | | |
| | 4 | 13 | | application.HasKey(x => x.Id); |
| | | 14 | | |
| | 4 | 15 | | application.Property(x => x.PublicId).IsRequired(); |
| | 4 | 16 | | application.HasIndex(x => x.PublicId).IsUnique(); |
| | | 17 | | |
| | 4 | 18 | | application.Property(x => x.Name).IsRequired(); |
| | | 19 | | |
| | 4 | 20 | | application.Property(x => x.IsDeleted).HasDefaultValue(false); |
| | | 21 | | |
| | 4 | 22 | | application.Property(x => x.CreatedAt).HasDefaultValueSql("now()"); |
| | 4 | 23 | | application.Property(x => x.UpdatedAt).HasDefaultValueSql("now()"); |
| | | 24 | | |
| | | 25 | | // Every application belongs to exactly one scope (FR-AP-02); hard-deleting the scope |
| | | 26 | | // cascades to its applications (NFR-08). |
| | 4 | 27 | | application.HasOne(x => x.Scope) |
| | 4 | 28 | | .WithMany(s => s.Applications) |
| | 4 | 29 | | .HasForeignKey(x => x.ScopeId) |
| | 4 | 30 | | .IsRequired() |
| | 4 | 31 | | .OnDelete(DeleteBehavior.Cascade); |
| | | 32 | | |
| | | 33 | | // Every application has exactly one owning person (FR-AP-03); hard-deleting the owner |
| | | 34 | | // cascades to the applications they own (NFR-11). |
| | 4 | 35 | | application.HasOne(x => x.Owner) |
| | 4 | 36 | | .WithMany(p => p.OwnedApplications) |
| | 4 | 37 | | .HasForeignKey(x => x.OwnerId) |
| | 4 | 38 | | .IsRequired() |
| | 4 | 39 | | .OnDelete(DeleteBehavior.Cascade); |
| | 4 | 40 | | } |
| | | 41 | | } |