Changes in / [0496e6e:e7bafc0]

Files:

• docs/Ph8.md (deleted)
• iknow-api/Program.cs (modified) (1 diff)
• iknow-api/Services/Implementations/EnrollmentService.cs (modified) (3 diffs)
• iknow-api/appsettings.Development.json.example (modified) (1 diff)

iknow-api/Program.cs

@@ -66 +66 @@
 // Postgres type by name; PgEnumLabels covers the members whose label is not
 // simply the lowercased member name.
-// AddDbContextPool reuses the DbContext instances themselves; the connections
-// underneath them are pooled separately by Npgsql, sized in the connection
-// string. Both matter here because every physical connection is one more
-// channel through the SSH tunnel.
-builder.Services.AddDbContextPool<AppDbContext>(options =>
+builder.Services.AddDbContext<AppDbContext>(options =>
     options.UseNpgsql(
         builder.Configuration.GetConnectionString("DefaultConnection"),

iknow-api/Services/Implementations/EnrollmentService.cs

@@ -3 +3 @@
 using iknow_api.Models;
 using Microsoft.EntityFrameworkCore;
-using Npgsql;
 
 namespace iknow_api.Services
@@ -221 +220 @@
                 };
             }
-            catch (DbUpdateException ex) when (IsUniqueViolation(ex))
-            {
-                // Two enrolments for the same semester sent at the same time both
-                // pass the check above, because each transaction reads the state
-                // from before the other one wrote. UNIQUE (user_id, semester_id)
-                // is what actually settles it, so the loser gets the same
-                // sentence as if the check had caught it.
-                await transaction.RollbackAsync();
-                return Fail("You are already enrolled in that semester.");
-            }
             catch
             {
@@ -237 +226 @@
             }
         }
-
-        /// <summary>23505 is unique_violation.</summary>
-        private static bool IsUniqueViolation(DbUpdateException ex) =>
-            ex.InnerException is PostgresException { SqlState: "23505" };
 
         private static EnrollSemesterResultDto Fail(string message) =>

iknow-api/appsettings.Development.json.example

@@ -7 +7 @@
   },
   "ConnectionStrings": {
-    "DefaultConnection": "Host=localhost;Port=9999;Database=db_202526z_va_prj_know2026;Username=db_202526z_va_prj_iknow2026_owner;Password=YOUR_DB_PASSWORD_HERE;Search Path=project;Include Error Detail=true;Maximum Pool Size=10;Minimum Pool Size=1;Connection Idle Lifetime=300;Timeout=15"
+    "DefaultConnection": "Host=localhost;Port=9999;Database=db_202526z_va_prj_know2026;Username=db_202526z_va_prj_iknow2026_owner;Password=YOUR_DB_PASSWORD_HERE;Search Path=project;Include Error Detail=true"
   },
   "Jwt": {