| | | 1 | | using Npgsql; |
| | | 2 | | using System.Data.Common; |
| | | 3 | | using Syki.Back.Auth.Users; |
| | | 4 | | using Audit.EntityFramework; |
| | | 5 | | using Syki.Back.Domain.Identity; |
| | | 6 | | using Microsoft.AspNetCore.Identity.EntityFrameworkCore; |
| | | 7 | | using Microsoft.AspNetCore.DataProtection.EntityFrameworkCore; |
| | | 8 | | |
| | | 9 | | namespace Syki.Back.Database; |
| | | 10 | | |
| | | 11 | | public partial class SykiDbContext(DbContextOptions<SykiDbContext> options, NpgsqlDataSource npgsqlDataSource, HybridCac |
| | 2124 | 12 | | : IdentityDbContext<SykiUser, SykiRole, int, SykiUserClaim, SykiUserRole, SykiUserLogin, SykiRoleClaim, SykiUserToke |
| | | 13 | | { |
| | 2416 | 14 | | public HybridCache Cache { get; set; } = cache; |
| | | 15 | | |
| | 8316 | 16 | | public RequestUser RequestUser { get; set; } = new(); |
| | | 17 | | |
| | 3570 | 18 | | public string ActivityId { get; set; } |
| | 3570 | 19 | | public string Operation { get; set; } |
| | | 20 | | |
| | 2130 | 21 | | public DbSet<DataProtectionKey> DataProtectionKeys { get; set; } |
| | | 22 | | |
| | | 23 | | protected override void OnConfiguring(DbContextOptionsBuilder optionsBuilder) |
| | | 24 | | { |
| | 1798 | 25 | | optionsBuilder.UseSnakeCaseNamingConvention(); |
| | 3596 | 26 | | optionsBuilder.UseNpgsql(npgsqlDataSource, x => x.MigrationsHistoryTable("migrations", DbSchemas.Syki)); |
| | | 27 | | |
| | 1798 | 28 | | optionsBuilder.AddInterceptors(new AuditSaveChangesInterceptor()); |
| | 1798 | 29 | | } |
| | | 30 | | |
| | | 31 | | protected override void OnModelCreating(ModelBuilder modelBuilder) |
| | | 32 | | { |
| | 4 | 33 | | base.OnModelCreating(modelBuilder); |
| | | 34 | | |
| | 4 | 35 | | ConfigureAudit(modelBuilder); |
| | 4 | 36 | | ConfigureCampi(modelBuilder); |
| | 4 | 37 | | ConfigureCourses(modelBuilder); |
| | 4 | 38 | | ConfigureCourseCurriculums(modelBuilder); |
| | 4 | 39 | | ConfigureCourseOfferings(modelBuilder); |
| | 4 | 40 | | ConfigurePeriods(modelBuilder); |
| | 4 | 41 | | ConfigureTeachers(modelBuilder); |
| | 4 | 42 | | ConfigureStudents(modelBuilder); |
| | 4 | 43 | | ConfigureCommands(modelBuilder); |
| | 4 | 44 | | ConfigureIdentity(modelBuilder); |
| | 4 | 45 | | ConfigureDisciplines(modelBuilder); |
| | 4 | 46 | | ConfigureInstitutions(modelBuilder); |
| | | 47 | | |
| | 4 | 48 | | ConfigureDatabaseNames(modelBuilder); |
| | 4 | 49 | | } |
| | | 50 | | |
| | | 51 | | private static void ConfigureDatabaseNames(ModelBuilder modelBuilder) |
| | | 52 | | { |
| | 264 | 53 | | foreach (var entity in modelBuilder.Model.GetEntityTypes()) |
| | | 54 | | { |
| | 128 | 55 | | if (entity.GetTableName().IsEmpty()) continue; |
| | | 56 | | |
| | 128 | 57 | | entity.SetTableName(entity.GetTableName().ToSnakeCase().Replace("asp_net_", "")); |
| | | 58 | | |
| | 600 | 59 | | foreach (var fk in entity.GetForeignKeys()) |
| | | 60 | | { |
| | 172 | 61 | | if (fk.GetConstraintName().HasValue()) |
| | | 62 | | { |
| | 172 | 63 | | fk.SetConstraintName(fk.GetConstraintName()!.Replace("~", "").Replace("1", "")); |
| | | 64 | | } |
| | | 65 | | } |
| | | 66 | | |
| | 584 | 67 | | foreach (var index in entity.GetIndexes()) |
| | | 68 | | { |
| | 164 | 69 | | index.SetDatabaseName(index.GetDatabaseName()?.ToSnakeCase()); |
| | | 70 | | } |
| | | 71 | | } |
| | 4 | 72 | | } |
| | | 73 | | |
| | | 74 | | public async Task<DbConnection> GetOpenConnectionAsync(CancellationToken ct = default) |
| | | 75 | | { |
| | 0 | 76 | | await Database.OpenConnectionAsync(ct); |
| | 0 | 77 | | return Database.GetDbConnection(); |
| | 0 | 78 | | } |
| | | 79 | | |
| | | 80 | | public async Task<int> SaveChangesAsync<TEntity>(TEntity entity) |
| | | 81 | | { |
| | 124 | 82 | | Add(entity); |
| | 124 | 83 | | return await SaveChangesAsync(); |
| | 124 | 84 | | } |
| | | 85 | | } |