aboutsummaryrefslogtreecommitdiffstats
path: root/code/api/Database/AppDatabase.cs
blob: 3735d89f3c337eb4479f0f5d1b68cedf2c473326 (plain) (blame)
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
37
38
39
40
using File = Quality.Storage.Api.Database.Models.File;

namespace Quality.Storage.Api.Database;

using File = File;

public class AppDatabase(DbContextOptions<AppDatabase> options) : DbContext(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.HasOne(c => c.Parent);
			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);
	}
}