using System.Security.Cryptography; using System.Text; using ClassNotify.Server.Domain.Entities; using Microsoft.EntityFrameworkCore; namespace ClassNotify.Server.Data; public static class DbInitializer { public static async Task InitializeAsync(ClassNotifyDbContext dbContext, IHostEnvironment env, IConfiguration config, ILogger logger) { // 1. Always ensure 'global' tenant exists for SuperAdmin users if (!await dbContext.Tenants.AnyAsync(t => t.Id == "global")) { dbContext.Tenants.Add(new Tenant { Id = "global", Name = "全局平台管理", IsActive = true, CreatedAt = DateTimeOffset.UtcNow }); await dbContext.SaveChangesAsync(); } // Schema auto-patch for Commercial Pilot & Dual-Distribution (Turn 50) try { if (dbContext.Database.IsRelational()) { await dbContext.Database.ExecuteSqlRawAsync("ALTER TABLE \"ActivationCodes\" ADD COLUMN IF NOT EXISTS \"Notes\" VARCHAR(255);"); await dbContext.Database.ExecuteSqlRawAsync("ALTER TABLE \"ActivationCodes\" ADD COLUMN IF NOT EXISTS \"TargetClassNameAtIssue\" VARCHAR(100);"); await dbContext.Database.ExecuteSqlRawAsync("ALTER TABLE \"ActivationCodes\" ADD COLUMN IF NOT EXISTS \"AssignedTeacherId\" VARCHAR(100);"); await dbContext.Database.ExecuteSqlRawAsync("ALTER TABLE \"ActivationCodes\" ADD COLUMN IF NOT EXISTS \"AssignedTeacherName\" VARCHAR(100);"); await dbContext.Database.ExecuteSqlRawAsync("ALTER TABLE \"ActivationCodes\" ADD COLUMN IF NOT EXISTS \"DistributionMethod\" VARCHAR(50) DEFAULT 'External';"); await dbContext.Database.ExecuteSqlRawAsync("ALTER TABLE \"ActivationCodes\" ADD COLUMN IF NOT EXISTS \"AssignedAt\" TIMESTAMPTZ;"); await dbContext.Database.ExecuteSqlRawAsync("ALTER TABLE \"ActivationCodes\" ADD COLUMN IF NOT EXISTS \"AssignedByUserId\" VARCHAR(100);"); await dbContext.Database.ExecuteSqlRawAsync("ALTER TABLE \"ActivationCodes\" ADD COLUMN IF NOT EXISTS \"SecretExposedAtUtc\" TIMESTAMPTZ;"); await dbContext.Database.ExecuteSqlRawAsync("ALTER TABLE \"ActivationCodes\" ADD COLUMN IF NOT EXISTS \"Id\" VARCHAR(100);"); await dbContext.Database.ExecuteSqlRawAsync("UPDATE \"ActivationCodes\" SET \"Id\" = 'act_' || md5(\"Code\") WHERE \"Id\" IS NULL;"); await dbContext.Database.ExecuteSqlRawAsync("CREATE INDEX IF NOT EXISTS \"IX_ActivationCodes_Id\" ON \"ActivationCodes\" (\"Id\");"); await dbContext.Database.ExecuteSqlRawAsync("ALTER TABLE \"ActivationCodes\" ADD COLUMN IF NOT EXISTS \"Status\" VARCHAR(50) DEFAULT 'Issued';"); await dbContext.Database.ExecuteSqlRawAsync("ALTER TABLE \"ActivationCodes\" ADD COLUMN IF NOT EXISTS \"RevokedAtUtc\" TIMESTAMPTZ;"); await dbContext.Database.ExecuteSqlRawAsync("ALTER TABLE \"ActivationCodes\" ADD COLUMN IF NOT EXISTS \"RevokedReason\" VARCHAR(255);"); await dbContext.Database.ExecuteSqlRawAsync("ALTER TABLE \"ActivationCodes\" ADD COLUMN IF NOT EXISTS \"Purpose\" VARCHAR(100) DEFAULT 'ProvisionAndLicense';"); await dbContext.Database.ExecuteSqlRawAsync("ALTER TABLE \"Tenants\" ADD COLUMN IF NOT EXISTS \"TenantType\" VARCHAR(50) DEFAULT 'School';"); await dbContext.Database.ExecuteSqlRawAsync("CREATE INDEX IF NOT EXISTS \"IX_ActivationCodes_TenantId_AssignedTeacherId\" ON \"ActivationCodes\" (\"TenantId\", \"AssignedTeacherId\");"); await dbContext.Database.ExecuteSqlRawAsync(@" CREATE TABLE IF NOT EXISTS ""ActivationCodeAssignments"" ( ""Id"" VARCHAR(100) PRIMARY KEY, ""TenantId"" VARCHAR(100) NOT NULL, ""ActivationCodeId"" VARCHAR(100) NOT NULL, ""CodeMasked"" VARCHAR(100) NOT NULL, ""TeacherUserId"" VARCHAR(100) NOT NULL, ""TeacherName"" VARCHAR(100) NOT NULL, ""AssignedByUserId"" VARCHAR(100) NOT NULL, ""AssignedAtUtc"" TIMESTAMPTZ NOT NULL, ""UnassignedAtUtc"" TIMESTAMPTZ, ""Reason"" VARCHAR(255) ); CREATE INDEX IF NOT EXISTS ""IX_ActivationCodeAssignments_CodeId"" ON ""ActivationCodeAssignments"" (""ActivationCodeId""); CREATE INDEX IF NOT EXISTS ""IX_ActivationCodeAssignments_Teacher"" ON ""ActivationCodeAssignments"" (""TenantId"", ""TeacherUserId""); "); await dbContext.Database.ExecuteSqlRawAsync("ALTER TABLE \"DeviceLicenses\" ADD COLUMN IF NOT EXISTS \"ClientRequestId\" VARCHAR(100);"); await dbContext.Database.ExecuteSqlRawAsync(@" CREATE TABLE IF NOT EXISTS ""UpdateReleases"" ( ""Id"" VARCHAR(100) PRIMARY KEY, ""Version"" VARCHAR(50) NOT NULL, ""MinRequiredVersion"" VARCHAR(50), ""ReleaseNotes"" TEXT, ""PackageHash"" VARCHAR(128) NOT NULL, ""PackageSizeBytes"" BIGINT NOT NULL, ""StoragePath"" VARCHAR(500) NOT NULL, ""TargetRing"" VARCHAR(50) NOT NULL, ""IsActive"" BOOLEAN NOT NULL, ""ReleasedAtUtc"" TIMESTAMPTZ NOT NULL, ""ReleasedByUserId"" VARCHAR(100) ); CREATE TABLE IF NOT EXISTS ""DeviceUpdateBatches"" ( ""Id"" VARCHAR(100) PRIMARY KEY, ""ReleaseId"" VARCHAR(100) NOT NULL, ""TenantId"" VARCHAR(100), ""TargetRing"" VARCHAR(50) NOT NULL, ""TargetDeviceCount"" INT NOT NULL, ""CompletedDeviceCount"" INT NOT NULL, ""FailedDeviceCount"" INT NOT NULL, ""Status"" VARCHAR(50) NOT NULL, ""CreatedAtUtc"" TIMESTAMPTZ NOT NULL, ""StartedAtUtc"" TIMESTAMPTZ, ""CompletedAtUtc"" TIMESTAMPTZ, ""CreatedByUserId"" VARCHAR(100) ); CREATE TABLE IF NOT EXISTS ""DeviceUpdateRuns"" ( ""Id"" VARCHAR(100) PRIMARY KEY, ""BatchId"" VARCHAR(100) NOT NULL, ""DeviceId"" VARCHAR(100) NOT NULL, ""TenantId"" VARCHAR(100) NOT NULL, ""TargetVersion"" VARCHAR(50) NOT NULL, ""Status"" VARCHAR(50) NOT NULL, ""CurrentPhase"" VARCHAR(50), ""ProgressPercent"" INT NOT NULL, ""AttemptCount"" INT NOT NULL, ""LastAttemptAtUtc"" TIMESTAMPTZ, ""CompletedAtUtc"" TIMESTAMPTZ, ""ErrorMessage"" TEXT, ""Logs"" TEXT ); CREATE TABLE IF NOT EXISTS ""NotificationHistoryDismissals"" ( ""Id"" VARCHAR(100) PRIMARY KEY, ""TenantId"" VARCHAR(100) NOT NULL, ""UserId"" VARCHAR(100) NOT NULL, ""NotificationId"" VARCHAR(100) NOT NULL, ""DismissedAtUtc"" TIMESTAMPTZ NOT NULL ); CREATE UNIQUE INDEX IF NOT EXISTS ""IX_NotificationHistoryDismissals_User_Notification"" ON ""NotificationHistoryDismissals"" (""UserId"", ""NotificationId""); CREATE INDEX IF NOT EXISTS ""IX_NotificationHistoryDismissals_Tenant_User"" ON ""NotificationHistoryDismissals"" (""TenantId"", ""UserId""); "); } } catch (Exception ex) { logger.LogWarning(ex, "Schema auto-patch check warning: {Message}", ex.Message); } // 2. HARD PRODUCTION SEED GUARD: // In Production environment, NEVER allow development seeding under any circumstances, // even if SeedDevelopmentData is erroneously set to true in configuration. if (env.IsProduction()) { if (config.GetValue("SeedDevelopmentData")) { logger.LogWarning("SECURITY ALERT: SeedDevelopmentData=true was configured in Production environment! Hard guard engaged: development seeding is strictly prohibited in Production."); } logger.LogInformation("Production environment: Development seeding is strictly prohibited. Skipping."); return; } // Only seed sample schools/classes/devices in non-production development environments bool seedDevData = config.GetValue("SeedDevelopmentData") || env.IsDevelopment(); if (!seedDevData) { logger.LogInformation("Skipping development data seeding."); return; } // If tenants other than 'global' already exist, skip development seed if (await dbContext.Tenants.AnyAsync(t => t.Id != "global")) { return; } logger.LogInformation("Seeding initial development tenants, classrooms, users, and activation codes..."); // Development Tenants var t1 = new Tenant { Id = "t_beijing_no4", Name = "北京四中", IsActive = true, CreatedAt = DateTimeOffset.UtcNow }; var t2 = new Tenant { Id = "t_shanghai_high", Name = "上海实验学校", IsActive = true, CreatedAt = DateTimeOffset.UtcNow }; dbContext.Tenants.AddRange(t1, t2); // Development Classrooms var c1 = new Classroom { Id = "cls_801", TenantId = "t_beijing_no4", DisplayName = "八年级(1)班", Grade = "初二", RoomNumber = "综合楼301" }; var c2 = new Classroom { Id = "cls_802", TenantId = "t_beijing_no4", DisplayName = "八年级(2)班", Grade = "初二", RoomNumber = "综合楼302" }; var c3 = new Classroom { Id = "cls_801", TenantId = "t_shanghai_high", DisplayName = "高一(1)班", Grade = "高一", RoomNumber = "实验楼101" }; dbContext.Classrooms.AddRange(c1, c2, c3); // Development Users var hasher = new Microsoft.AspNetCore.Identity.PasswordHasher(); var uSuper = new User { Id = "usr_super", TenantId = "global", Username = "admin", FullName = "超级管理员", Role = "SuperAdmin" }; uSuper.PasswordHash = hasher.HashPassword(uSuper, "admin888"); var uAdminBj = new User { Id = "usr_admin_bj", TenantId = "t_beijing_no4", Username = "admin_bj4", FullName = "北京四中管理员", Role = "SchoolAdmin" }; uAdminBj.PasswordHash = hasher.HashPassword(uAdminBj, "admin123"); var uAdminSh = new User { Id = "usr_admin_sh", TenantId = "t_shanghai_high", Username = "admin_sh", FullName = "上海实验管理员", Role = "SchoolAdmin" }; uAdminSh.PasswordHash = hasher.HashPassword(uAdminSh, "admin123"); var u101 = new User { Id = "usr_101", TenantId = "t_beijing_no4", Username = "teacher_zhang", FullName = "张老师", Role = "Teacher" }; u101.PasswordHash = hasher.HashPassword(u101, "teacher123"); var u201 = new User { Id = "usr_201", TenantId = "t_shanghai_high", Username = "teacher_li", FullName = "李老师", Role = "Teacher" }; u201.PasswordHash = hasher.HashPassword(u201, "teacher123"); dbContext.Users.AddRange(uSuper, uAdminBj, uAdminSh, u101, u201); // Development Activation Codes dbContext.ActivationCodes.AddRange( new ActivationCode { Code = "TEST-2026", TenantId = "t_beijing_no4", ClassroomId = "cls_801", ExpiresAt = DateTimeOffset.UtcNow.AddDays(30), IsUsed = false }, new ActivationCode { Code = "BJ81-2026", TenantId = "t_beijing_no4", ClassroomId = "cls_801", ExpiresAt = DateTimeOffset.UtcNow.AddDays(30), IsUsed = false }, new ActivationCode { Code = "BJ82-2026", TenantId = "t_beijing_no4", ClassroomId = "cls_802", ExpiresAt = DateTimeOffset.UtcNow.AddDays(30), IsUsed = false }, new ActivationCode { Code = "BJ81-DEMO", TenantId = "t_beijing_no4", ClassroomId = "cls_801", ExpiresAt = DateTimeOffset.UtcNow.AddDays(30), IsUsed = false }, new ActivationCode { Code = "SH01-2026", TenantId = "t_shanghai_high", ClassroomId = "cls_801", ExpiresAt = DateTimeOffset.UtcNow.AddDays(30), IsUsed = false } ); await dbContext.SaveChangesAsync(); logger.LogInformation("Development seed completed successfully."); } }