blob: b3ebd734d40aba2bf2643dd61e655d111ff0894a (
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
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
|
using System;
using DevHive.Data.Models;
using DevHive.Data.RelationModels;
using Microsoft.AspNetCore.Identity.EntityFrameworkCore;
using Microsoft.EntityFrameworkCore;
namespace DevHive.Data
{
public class DevHiveContext : IdentityDbContext<User, Role, Guid>
{
public DevHiveContext(DbContextOptions<DevHiveContext> options)
: base(options) { }
public DbSet<Technology> Technologies { get; set; }
public DbSet<Language> Languages { get; set; }
public DbSet<Post> Posts { get; set; }
public DbSet<Comment> Comments { get; set; }
public DbSet<UserFriend> UserFriends { get; set; }
public DbSet<Rating> Rating { get; set; }
public DbSet<RatedPost> RatedPost { get; set; }
public DbSet<UserRate> UserRate { get; set; }
protected override void OnModelCreating(ModelBuilder builder)
{
/* User */
builder.Entity<User>()
.HasIndex(x => x.UserName)
.IsUnique();
builder.Entity<User>()
.HasOne(x => x.ProfilePicture)
.WithOne(x => x.User)
.HasForeignKey<ProfilePicture>(x => x.UserId);
/* Roles */
builder.Entity<User>()
.HasMany(x => x.Roles)
.WithMany(x => x.Users);
/* Friends */
builder.Entity<UserFriend>()
.HasKey(x => new { x.UserId, x.FriendId });
builder.Entity<UserFriend>()
.HasOne(x => x.User)
.WithMany(x => x.MyFriends)
.HasForeignKey(x => x.UserId);
builder.Entity<UserFriend>()
.HasOne(x => x.Friend)
.WithMany(x => x.FriendsOf)
.HasForeignKey(x => x.FriendId);
/* Languages */
builder.Entity<User>()
.HasMany(x => x.Languages)
.WithMany(x => x.Users)
.UsingEntity(x => x.ToTable("LanguageUser"));
builder.Entity<Language>()
.HasMany(x => x.Users)
.WithMany(x => x.Languages)
.UsingEntity(x => x.ToTable("LanguageUser"));
/* Technologies */
builder.Entity<User>()
.HasMany(x => x.Technologies)
.WithMany(x => x.Users)
.UsingEntity(x => x.ToTable("TechnologyUser"));
builder.Entity<Technology>()
.HasMany(x => x.Users)
.WithMany(x => x.Technologies)
.UsingEntity(x => x.ToTable("TechnologyUser"));
/* Post */
builder.Entity<Post>()
.HasOne(x => x.Creator)
.WithMany(x => x.Posts);
builder.Entity<Post>()
.HasMany(x => x.Comments)
.WithOne(x => x.Post);
/* Comment */
builder.Entity<Comment>()
.HasOne(x => x.Post)
.WithMany(x => x.Comments);
builder.Entity<Comment>()
.HasOne(x => x.Creator)
.WithMany(x => x.Comments);
/* Rating */
builder.Entity<Rating>()
.HasKey(x => x.Id);
// builder.Entity<Rating>()
// .HasOne(x => x.Post)
// .WithOne(x => x.Rating)
// .HasForeignKey<Post>(x => x.RatingId);
// builder.Entity<Post>()
// .HasOne(x => x.Rating)
// .WithOne(x => x.Post);
// builder.Entity<Rating>()
// .HasMany(x => x.UsersThatRated);
// /* User Rated Posts */
builder.Entity<RatedPost>()
.HasKey(x => new { x.UserId, x.PostId });
// builder.Entity<RatedPost>()
// .HasOne(x => x.User)
// .WithMany(x => x.RatedPosts);
// builder.Entity<RatedPost>()
// .HasOne(x => x.Post);
// builder.Entity<User>()
// .HasMany(x => x.RatedPosts);
base.OnModelCreating(builder);
}
}
}
|
