| | | 1 | | // SPDX-FileCopyrightText: 2026 Alper Çelik <[email protected]> |
| | | 2 | | // |
| | | 3 | | // SPDX-License-Identifier: AGPL-3.0-or-later |
| | | 4 | | |
| | | 5 | | using System.Reflection; |
| | | 6 | | using LinqKit; |
| | | 7 | | using Microsoft.EntityFrameworkCore; |
| | | 8 | | using Microsoft.EntityFrameworkCore.Infrastructure; |
| | | 9 | | using Npgsql; |
| | | 10 | | |
| | | 11 | | namespace Api.Database; |
| | | 12 | | |
| | | 13 | | public partial class PGContext(DbContextOptions options, IConfiguration? config = null) |
| | 1 | 14 | | : DbContext(options) |
| | | 15 | | { |
| | | 16 | | public string SchemaName { get; set; } = |
| | 1 | 17 | | config?["ConnectionStrings:PGSchema"] ?? "public"; |
| | | 18 | | |
| | | 19 | | protected override void OnModelCreating(ModelBuilder modelBuilder) |
| | 1 | 20 | | { |
| | 1 | 21 | | modelBuilder.HasDefaultSchema(SchemaName); |
| | | 22 | | |
| | 1 | 23 | | base.OnModelCreating(modelBuilder); |
| | 1 | 24 | | modelBuilder.ApplyConfigurationsFromAssembly( |
| | 1 | 25 | | Assembly.GetAssembly(this.GetType()!)! |
| | 1 | 26 | | ); |
| | 1 | 27 | | } |
| | | 28 | | |
| | | 29 | | protected override void OnConfiguring(DbContextOptionsBuilder optionsBuilder) => |
| | 1 | 30 | | optionsBuilder |
| | 1 | 31 | | .ReplaceService<IModelCacheKeyFactory, SchemaModelCacheKeyFactory>() |
| | 1 | 32 | | .UseSnakeCaseNamingConvention() |
| | 1 | 33 | | .UseValidationCheckConstraints() |
| | 1 | 34 | | .UseNpgsql( |
| | 1 | 35 | | config?.GetConnectionString("PG") ?? "", |
| | 1 | 36 | | nopts => nopts.SetPostgresVersion(18, 0).UseNodaTime() |
| | 1 | 37 | | ) |
| | 1 | 38 | | .WithExpressionExpanding(); |
| | | 39 | | } |
| | | 40 | | |
| | | 41 | | public class SchemaModelCacheKeyFactory : IModelCacheKeyFactory |
| | | 42 | | { |
| | | 43 | | public object Create(DbContext context, bool designTime) |
| | | 44 | | { |
| | | 45 | | return context is PGContext pgContext |
| | | 46 | | ? (context.GetType(), pgContext.SchemaName, designTime) |
| | | 47 | | : (context.GetType(), designTime); |
| | | 48 | | } |
| | | 49 | | } |