using System.Text.Json; using ClassNotify.Server.Domain.Entities; using ClassNotify.Shared.Models; using Microsoft.EntityFrameworkCore; namespace ClassNotify.Server.Data; public class JsonMigrationResult { public bool Migrated { get; set; } public string? BackupPath { get; set; } public int TenantsCount { get; set; } public int ClassroomsCount { get; set; } public int UsersCount { get; set; } public int DevicesCount { get; set; } public int CredentialsCount { get; set; } public int ActivationCodesCount { get; set; } public int NotificationsCount { get; set; } } public static class JsonMigrationService { public static async Task MigrateAsync(ClassNotifyDbContext dbContext, string? dataDirectory, ILogger logger) { var result = new JsonMigrationResult(); var marker = await dbContext.MigrationMarkers.FindAsync("JsonMigration_v1"); if (marker != null) { logger.LogInformation("JSON migration marker 'JsonMigration_v1' already exists (migrated at {MigratedAt}). Skipping migration.", marker.MigratedAt); return result; } var dataDir = dataDirectory ?? Path.Combine(AppContext.BaseDirectory, "data"); if (!Directory.Exists(dataDir)) { logger.LogInformation("No 'data' directory found at {DataDir}. Skipping JSON migration.", dataDir); return result; } var tenantsFile = Path.Combine(dataDir, "tenants.json"); var classroomsFile = Path.Combine(dataDir, "classrooms.json"); var usersFile = Path.Combine(dataDir, "users.json"); var devicesFile = Path.Combine(dataDir, "devices.json"); var credsFile = Path.Combine(dataDir, "device_credentials.json"); var codesFile = Path.Combine(dataDir, "activation_codes.json"); var notifsFile = Path.Combine(dataDir, "notifications.json"); if (!File.Exists(tenantsFile) && !File.Exists(classroomsFile) && !File.Exists(usersFile) && !File.Exists(devicesFile) && !File.Exists(credsFile) && !File.Exists(codesFile) && !File.Exists(notifsFile)) { logger.LogInformation("No legacy JSON data files found in {DataDir}. Skipping JSON migration.", dataDir); return result; } logger.LogInformation("Starting one-time legacy JSON to PostgreSQL transactional migration from {DataDir}...", dataDir); using var tx = await dbContext.Database.BeginTransactionAsync(); try { // 1. Tenants var tenantDict = new Dictionary(); if (!await dbContext.Tenants.AnyAsync(t => t.Id == "global")) { var globalTenant = new Tenant { Id = "global", Name = "全局平台管理", IsActive = true, CreatedAt = DateTimeOffset.UtcNow }; dbContext.Tenants.Add(globalTenant); tenantDict["global"] = globalTenant; } if (File.Exists(tenantsFile)) { var json = await File.ReadAllTextAsync(tenantsFile); var tenants = JsonSerializer.Deserialize>(json) ?? new(); foreach (var t in tenants) { if (!await dbContext.Tenants.AnyAsync(existing => existing.Id == t.Id) && !tenantDict.ContainsKey(t.Id)) { dbContext.Tenants.Add(t); tenantDict[t.Id] = t; result.TenantsCount++; } } await dbContext.SaveChangesAsync(); } // 2. Classrooms if (File.Exists(classroomsFile)) { var json = await File.ReadAllTextAsync(classroomsFile); var classrooms = JsonSerializer.Deserialize>(json) ?? new(); foreach (var c in classrooms) { if (!await dbContext.Classrooms.AnyAsync(existing => existing.TenantId == c.TenantId && existing.Id == c.Id)) { dbContext.Classrooms.Add(c); result.ClassroomsCount++; } } await dbContext.SaveChangesAsync(); } // 3. Users if (File.Exists(usersFile)) { var json = await File.ReadAllTextAsync(usersFile); var users = JsonSerializer.Deserialize>(json) ?? new(); foreach (var u in users) { if (!await dbContext.Users.AnyAsync(existing => existing.Username == u.Username)) { // Ensure tenant exists if (!string.IsNullOrEmpty(u.TenantId) && !await dbContext.Tenants.AnyAsync(t => t.Id == u.TenantId)) { var newTenant = new Tenant { Id = u.TenantId, Name = u.TenantId, IsActive = true, CreatedAt = DateTimeOffset.UtcNow }; dbContext.Tenants.Add(newTenant); await dbContext.SaveChangesAsync(); } dbContext.Users.Add(u); result.UsersCount++; } } await dbContext.SaveChangesAsync(); } // 4. Devices var migratedDevices = new List(); if (File.Exists(devicesFile)) { var json = await File.ReadAllTextAsync(devicesFile); var devices = JsonSerializer.Deserialize>(json) ?? new(); var usedInstallationIds = new HashSet(StringComparer.OrdinalIgnoreCase); foreach (var d in devices) { if (!await dbContext.Devices.AnyAsync(existing => existing.Id == d.Id)) { // Ensure tenant and classroom exist if (!await dbContext.Tenants.AnyAsync(t => t.Id == d.TenantId)) { dbContext.Tenants.Add(new Tenant { Id = d.TenantId, Name = d.TenantId, IsActive = true, CreatedAt = DateTimeOffset.UtcNow }); await dbContext.SaveChangesAsync(); } if (!await dbContext.Classrooms.AnyAsync(c => c.TenantId == d.TenantId && c.Id == d.ClassroomId)) { dbContext.Classrooms.Add(new Classroom { TenantId = d.TenantId, Id = d.ClassroomId, DisplayName = d.ClassroomId }); await dbContext.SaveChangesAsync(); } // Handle legacy duplicate InstallationId gracefully if (!string.IsNullOrEmpty(d.InstallationId)) { if (usedInstallationIds.Contains(d.InstallationId) || await dbContext.Devices.AnyAsync(existing => existing.InstallationId == d.InstallationId)) { logger.LogWarning("Legacy duplicate InstallationId {InstId} detected for Device {DeviceId}. Renaming for unique constraint.", d.InstallationId, d.Id); d.InstallationId = $"{d.InstallationId}_dup_{d.Id}"; } usedInstallationIds.Add(d.InstallationId); } dbContext.Devices.Add(d); migratedDevices.Add(d); result.DevicesCount++; } } await dbContext.SaveChangesAsync(); } // 5. Device Credentials if (File.Exists(credsFile)) { var json = await File.ReadAllTextAsync(credsFile); var creds = JsonSerializer.Deserialize>(json) ?? new(); var usedCredInstIds = new HashSet(StringComparer.OrdinalIgnoreCase); foreach (var c in creds) { if (!await dbContext.DeviceCredentials.AnyAsync(existing => existing.DeviceId == c.DeviceId)) { if (!string.IsNullOrEmpty(c.InstallationId)) { if (usedCredInstIds.Contains(c.InstallationId) || await dbContext.DeviceCredentials.AnyAsync(existing => existing.InstallationId == c.InstallationId)) { c.InstallationId = $"{c.InstallationId}_dup_{c.DeviceId}"; } usedCredInstIds.Add(c.InstallationId); } dbContext.DeviceCredentials.Add(c); result.CredentialsCount++; } } await dbContext.SaveChangesAsync(); } // 6. Activation Codes if (File.Exists(codesFile)) { var json = await File.ReadAllTextAsync(codesFile); var codes = JsonSerializer.Deserialize>(json) ?? new(); foreach (var a in codes) { if (!await dbContext.ActivationCodes.AnyAsync(existing => existing.Code == a.Code)) { if (!await dbContext.Tenants.AnyAsync(t => t.Id == a.TenantId)) { dbContext.Tenants.Add(new Tenant { Id = a.TenantId, Name = a.TenantId, IsActive = true, CreatedAt = DateTimeOffset.UtcNow }); await dbContext.SaveChangesAsync(); } dbContext.ActivationCodes.Add(a); result.ActivationCodesCount++; } } await dbContext.SaveChangesAsync(); } // 7. Notifications if (File.Exists(notifsFile)) { var json = await File.ReadAllTextAsync(notifsFile); var notifDtos = JsonSerializer.Deserialize>(json) ?? new(); var allDevices = await dbContext.Devices.ToListAsync(); foreach (var n in notifDtos) { if (!await dbContext.Notifications.AnyAsync(existing => existing.Id == n.Id)) { var notifEntity = new Notification { Id = n.Id, TenantId = n.TenantId, ClassroomId = n.ClassId, SenderName = string.IsNullOrWhiteSpace(n.SenderName) ? "系统" : n.SenderName, Message = n.Message, Title = "🔔 老师呼叫", Priority = string.IsNullOrWhiteSpace(n.Priority) ? "Normal" : n.Priority, CreatedAt = n.CreatedAt }; dbContext.Notifications.Add(notifEntity); result.NotificationsCount++; // Associate receipt if device exists in classroom var targetDev = allDevices.FirstOrDefault(d => d.TenantId == n.TenantId && d.ClassroomId == n.ClassId); if (targetDev != null) { var receipt = new NotificationReceipt { Id = $"rcpt_{Guid.NewGuid():N}", NotificationId = n.Id, DeviceId = targetDev.Id, Status = string.IsNullOrWhiteSpace(n.Status) ? "Sent" : n.Status, DeviceReceivedAt = n.CreatedAt, DisplayedAt = n.CreatedAt, AcknowledgedAt = n.ConfirmedAt, UpdatedAt = n.ConfirmedAt ?? n.CreatedAt }; dbContext.NotificationReceipts.Add(receipt); } } } await dbContext.SaveChangesAsync(); } // Write Migration Marker var markerRecord = new MigrationMarker { Id = "JsonMigration_v1", MigratedAt = DateTimeOffset.UtcNow, Details = $"Successfully migrated Tenants={result.TenantsCount}, Classrooms={result.ClassroomsCount}, Users={result.UsersCount}, Devices={result.DevicesCount}, Credentials={result.CredentialsCount}, Codes={result.ActivationCodesCount}, Notifications={result.NotificationsCount}." }; dbContext.MigrationMarkers.Add(markerRecord); await dbContext.SaveChangesAsync(); await tx.CommitAsync(); result.Migrated = true; logger.LogInformation("JSON to PostgreSQL transaction committed successfully: {Details}", markerRecord.Details); // Move legacy JSON files to data/json-backup-YYYYMMDD-HHmmss/ var backupDir = Path.Combine(dataDir, $"json-backup-{DateTime.UtcNow:yyyyMMdd-HHmmss}"); Directory.CreateDirectory(backupDir); result.BackupPath = backupDir; string[] jsonFiles = { tenantsFile, classroomsFile, usersFile, devicesFile, credsFile, codesFile, notifsFile }; foreach (var file in jsonFiles) { if (File.Exists(file)) { var dest = Path.Combine(backupDir, Path.GetFileName(file)); File.Move(file, dest, overwrite: true); } } logger.LogInformation("Legacy JSON files safely moved to backup directory: {BackupDir}", backupDir); return result; } catch (Exception ex) { await tx.RollbackAsync(); logger.LogError(ex, "FATAL: JSON to PostgreSQL migration failed. Transaction rolled back, legacy JSON files preserved."); throw; } } }