code/api/Database/AppDatabase.cs


1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36

using File = I2R.Storage.Api.Database.Models.File;

namespace I2R.Storage.Api.Database;

public class AppDatabase : DbContext
{
    public AppDatabase(DbContextOptions<AppDatabase> options) : base(options) { }
    public DbSet<User> Users { get; set; }
    public DbSet<File> Files { get; set; }
    public DbSet<Folder> Folders { get; set; }
    public DbSet<Permission> Permissions { get; set; }
    public DbSet<PermissionGroup> PermissionGroups { get; set; }

    protected override void OnModelCreating(ModelBuilder modelBuilder) {
        modelBuilder.Entity<User>(e => { e.ToTable("users"); });
        modelBuilder.Entity<File>(e => {
            e.HasMany(c => c.Permissions);
            e.HasOne(c => c.Folder);
            e.ToTable("files");
        });
        modelBuilder.Entity<Folder>(e => {
            e.HasMany(c => c.Files);
            e.HasMany(c => c.Permissions);
            e.ToTable("folders");
        });
        modelBuilder.Entity<PermissionGroup>(e => {
            e.HasMany(c => c.Users);
            e.ToTable("permission_groups");
        });
        modelBuilder.Entity<Permission>(e => {
            e.HasOne(c => c.Group);
            e.ToTable("permissions");
        });
        base.OnModelCreating(modelBuilder);
    }
}