| | | 1 | | using System; |
| | | 2 | | using System.Collections.Generic; |
| | | 3 | | using System.Globalization; |
| | | 4 | | using System.IO; |
| | | 5 | | using System.Linq; |
| | | 6 | | using System.Reflection; |
| | | 7 | | using System.Threading; |
| | | 8 | | using System.Threading.Tasks; |
| | | 9 | | using Emby.Server.Implementations.Serialization; |
| | | 10 | | using Jellyfin.Database.Implementations; |
| | | 11 | | using Jellyfin.Server.Implementations.SystemBackupService; |
| | | 12 | | using Jellyfin.Server.Migrations.Stages; |
| | | 13 | | using Jellyfin.Server.ServerSetupApp; |
| | | 14 | | using MediaBrowser.Common.Configuration; |
| | | 15 | | using MediaBrowser.Controller.SystemBackupService; |
| | | 16 | | using MediaBrowser.Model.Configuration; |
| | | 17 | | using Microsoft.EntityFrameworkCore; |
| | | 18 | | using Microsoft.EntityFrameworkCore.Infrastructure; |
| | | 19 | | using Microsoft.EntityFrameworkCore.Migrations; |
| | | 20 | | using Microsoft.EntityFrameworkCore.Storage; |
| | | 21 | | using Microsoft.Extensions.Logging; |
| | | 22 | | |
| | | 23 | | namespace Jellyfin.Server.Migrations; |
| | | 24 | | |
| | | 25 | | /// <summary> |
| | | 26 | | /// Handles Migration of the Jellyfin data structure. |
| | | 27 | | /// </summary> |
| | | 28 | | internal class JellyfinMigrationService |
| | | 29 | | { |
| | | 30 | | private const string DbFilename = "library.db"; |
| | | 31 | | private readonly IDbContextFactory<JellyfinDbContext> _dbContextFactory; |
| | | 32 | | private readonly ILoggerFactory _loggerFactory; |
| | | 33 | | private readonly IStartupLogger _startupLogger; |
| | | 34 | | private readonly IBackupService? _backupService; |
| | | 35 | | private readonly IJellyfinDatabaseProvider? _jellyfinDatabaseProvider; |
| | | 36 | | private readonly IApplicationPaths _applicationPaths; |
| | | 37 | | private (string? LibraryDb, string? JellyfinDb, BackupManifestDto? FullBackup) _backupKey; |
| | | 38 | | |
| | | 39 | | /// <summary> |
| | | 40 | | /// Initializes a new instance of the <see cref="JellyfinMigrationService"/> class. |
| | | 41 | | /// </summary> |
| | | 42 | | /// <param name="dbContextFactory">Provides access to the jellyfin database.</param> |
| | | 43 | | /// <param name="loggerFactory">The logger factory.</param> |
| | | 44 | | /// <param name="startupLogger">The startup logger for Startup UI intigration.</param> |
| | | 45 | | /// <param name="applicationPaths">Application paths for library.db backup.</param> |
| | | 46 | | /// <param name="backupService">The jellyfin backup service.</param> |
| | | 47 | | /// <param name="jellyfinDatabaseProvider">The jellyfin database provider.</param> |
| | | 48 | | public JellyfinMigrationService( |
| | | 49 | | IDbContextFactory<JellyfinDbContext> dbContextFactory, |
| | | 50 | | ILoggerFactory loggerFactory, |
| | | 51 | | IStartupLogger<JellyfinMigrationService> startupLogger, |
| | | 52 | | IApplicationPaths applicationPaths, |
| | | 53 | | IBackupService? backupService = null, |
| | | 54 | | IJellyfinDatabaseProvider? jellyfinDatabaseProvider = null) |
| | | 55 | | { |
| | 66 | 56 | | _dbContextFactory = dbContextFactory; |
| | 66 | 57 | | _loggerFactory = loggerFactory; |
| | 66 | 58 | | _startupLogger = startupLogger; |
| | 66 | 59 | | _backupService = backupService; |
| | 66 | 60 | | _jellyfinDatabaseProvider = jellyfinDatabaseProvider; |
| | 66 | 61 | | _applicationPaths = applicationPaths; |
| | | 62 | | #pragma warning disable CS0618 // Type or member is obsolete |
| | 66 | 63 | | Migrations = [.. typeof(IMigrationRoutine).Assembly.GetTypes().Where(e => typeof(IMigrationRoutine).IsAssignable |
| | 66 | 64 | | .Select(e => (Type: e, Metadata: e.GetCustomAttribute<JellyfinMigrationAttribute>(), Backup: e.GetCustomAttr |
| | 66 | 65 | | .Where(e => e.Metadata is not null) |
| | 66 | 66 | | .GroupBy(e => e.Metadata!.Stage) |
| | 66 | 67 | | .Select(f => |
| | 66 | 68 | | { |
| | 66 | 69 | | var stage = new MigrationStage(f.Key); |
| | 66 | 70 | | foreach (var item in f) |
| | 66 | 71 | | { |
| | 66 | 72 | | JellyfinMigrationBackupAttribute? backupMetadata = null; |
| | 66 | 73 | | if (item.Backup?.Any() == true) |
| | 66 | 74 | | { |
| | 66 | 75 | | backupMetadata = item.Backup.Aggregate(MergeBackupAttributes); |
| | 66 | 76 | | } |
| | 66 | 77 | | |
| | 66 | 78 | | stage.Add(new(item.Type, item.Metadata!, backupMetadata)); |
| | 66 | 79 | | } |
| | 66 | 80 | | |
| | 66 | 81 | | return stage; |
| | 66 | 82 | | })]; |
| | | 83 | | #pragma warning restore CS0618 // Type or member is obsolete |
| | 66 | 84 | | } |
| | | 85 | | |
| | | 86 | | private interface IInternalMigration |
| | | 87 | | { |
| | | 88 | | Task PerformAsync(IStartupLogger logger); |
| | | 89 | | } |
| | | 90 | | |
| | | 91 | | private HashSet<MigrationStage> Migrations { get; set; } |
| | | 92 | | |
| | | 93 | | public async Task CheckFirstTimeRunOrMigration(IApplicationPaths appPaths, StartupOptions startupOptions) |
| | | 94 | | { |
| | 22 | 95 | | var logger = _startupLogger.With(_loggerFactory.CreateLogger<JellyfinMigrationService>()).BeginGroup($"Migration |
| | 22 | 96 | | logger.LogInformation("Initialise Migration service."); |
| | 22 | 97 | | var xmlSerializer = new MyXmlSerializer(); |
| | 22 | 98 | | var serverConfig = File.Exists(appPaths.SystemConfigurationFilePath) |
| | 22 | 99 | | ? (ServerConfiguration)xmlSerializer.DeserializeFromFile(typeof(ServerConfiguration), appPaths.SystemConfigu |
| | 22 | 100 | | : new ServerConfiguration(); |
| | 22 | 101 | | if (!serverConfig.IsStartupWizardCompleted || startupOptions.StartupMode is Configuration.StartupMode.SeedSystem |
| | | 102 | | { |
| | 22 | 103 | | logger.LogInformation("System initialization detected. Seed data. Startup mode is: {StartupMode}", startupOp |
| | 22 | 104 | | var flatApplyMigrations = Migrations.SelectMany(e => e.Where(f => !f.Metadata.RunMigrationOnSetup)).ToArray( |
| | | 105 | | |
| | 22 | 106 | | var dbContext = await _dbContextFactory.CreateDbContextAsync().ConfigureAwait(false); |
| | 22 | 107 | | await using (dbContext.ConfigureAwait(false)) |
| | | 108 | | { |
| | 22 | 109 | | var databaseCreator = dbContext.Database.GetService<IDatabaseCreator>() as IRelationalDatabaseCreator |
| | 22 | 110 | | ?? throw new InvalidOperationException("Jellyfin does only support relational databases."); |
| | 22 | 111 | | if (!await databaseCreator.ExistsAsync().ConfigureAwait(false)) |
| | | 112 | | { |
| | 22 | 113 | | await databaseCreator.CreateAsync().ConfigureAwait(false); |
| | | 114 | | } |
| | | 115 | | |
| | 22 | 116 | | var historyRepository = dbContext.GetService<IHistoryRepository>(); |
| | | 117 | | |
| | 22 | 118 | | await historyRepository.CreateIfNotExistsAsync().ConfigureAwait(false); |
| | 22 | 119 | | var appliedMigrations = await dbContext.Database.GetAppliedMigrationsAsync().ConfigureAwait(false); |
| | 22 | 120 | | var startupScripts = flatApplyMigrations |
| | 22 | 121 | | .Where(e => !appliedMigrations.Any(f => f != e.BuildCodeMigrationId())) |
| | 22 | 122 | | .Select(e => (Migration: e.Metadata, Script: historyRepository.GetInsertScript(new HistoryRow(e.Buil |
| | 22 | 123 | | .ToArray(); |
| | 1716 | 124 | | foreach (var item in startupScripts) |
| | | 125 | | { |
| | 836 | 126 | | logger.LogInformation("Seed migration {Key}-{Name}.", item.Migration.Key, item.Migration.Name); |
| | 836 | 127 | | await dbContext.Database.ExecuteSqlRawAsync(item.Script).ConfigureAwait(false); |
| | | 128 | | } |
| | 22 | 129 | | } |
| | | 130 | | |
| | 22 | 131 | | logger.LogInformation("Migration system initialisation completed."); |
| | 22 | 132 | | } |
| | | 133 | | else |
| | | 134 | | { |
| | | 135 | | // migrate any existing migration.xml files |
| | 0 | 136 | | var migrationConfigPath = Path.Join(appPaths.ConfigurationDirectoryPath, "migrations.xml"); |
| | 0 | 137 | | var migrationOptions = File.Exists(migrationConfigPath) |
| | 0 | 138 | | ? (MigrationOptions)xmlSerializer.DeserializeFromFile(typeof(MigrationOptions), migrationConfigPath)! |
| | 0 | 139 | | : null; |
| | 0 | 140 | | if (migrationOptions is not null && migrationOptions.Applied.Count > 0) |
| | | 141 | | { |
| | 0 | 142 | | logger.LogInformation("Old migration style migration.xml detected. Migrate now."); |
| | | 143 | | try |
| | | 144 | | { |
| | 0 | 145 | | var dbContext = await _dbContextFactory.CreateDbContextAsync().ConfigureAwait(false); |
| | 0 | 146 | | await using (dbContext.ConfigureAwait(false)) |
| | | 147 | | { |
| | 0 | 148 | | var historyRepository = dbContext.GetService<IHistoryRepository>(); |
| | 0 | 149 | | var appliedMigrations = await dbContext.Database.GetAppliedMigrationsAsync().ConfigureAwait(fals |
| | 0 | 150 | | var lastOldAppliedMigration = Migrations |
| | 0 | 151 | | .SelectMany(e => e.Where(e => e.Metadata.Key is not null)) // only consider migrations that |
| | 0 | 152 | | .Where(e => migrationOptions.Applied.Any(f => f.Id.Equals(e.Metadata.Key!.Value))) |
| | 0 | 153 | | .Where(e => !appliedMigrations.Contains(e.BuildCodeMigrationId())) |
| | 0 | 154 | | .OrderBy(e => e.BuildCodeMigrationId()) |
| | 0 | 155 | | .Last(); // this is the latest migration applied in the old migration.xml |
| | | 156 | | |
| | 0 | 157 | | IReadOnlyList<CodeMigration> oldMigrations = [ |
| | 0 | 158 | | .. Migrations |
| | 0 | 159 | | .SelectMany(e => e) |
| | 0 | 160 | | .OrderBy(e => e.BuildCodeMigrationId()) |
| | 0 | 161 | | .TakeWhile(e => e.BuildCodeMigrationId() != lastOldAppliedMigration.BuildCodeMigrationId()), |
| | 0 | 162 | | lastOldAppliedMigration |
| | 0 | 163 | | ]; |
| | | 164 | | // those are all migrations that had to run in the old migration system, even if not noted in th |
| | | 165 | | |
| | 0 | 166 | | var startupScripts = oldMigrations.Select(e => (Migration: e.Metadata, Script: historyRepository |
| | 0 | 167 | | foreach (var item in startupScripts) |
| | | 168 | | { |
| | 0 | 169 | | logger.LogInformation("Migrate migration {Key}-{Name}.", item.Migration.Key, item.Migration. |
| | 0 | 170 | | await dbContext.Database.ExecuteSqlRawAsync(item.Script).ConfigureAwait(false); |
| | | 171 | | } |
| | | 172 | | |
| | 0 | 173 | | logger.LogInformation("Rename old migration.xml to migration.xml.backup"); |
| | 0 | 174 | | File.Move(migrationConfigPath, Path.ChangeExtension(migrationConfigPath, ".xml.backup"), true); |
| | 0 | 175 | | } |
| | 0 | 176 | | } |
| | 0 | 177 | | catch (Exception ex) |
| | | 178 | | { |
| | 0 | 179 | | logger.LogCritical(ex, "Failed to apply migrations"); |
| | 0 | 180 | | throw; |
| | | 181 | | } |
| | | 182 | | } |
| | 0 | 183 | | } |
| | 22 | 184 | | } |
| | | 185 | | |
| | | 186 | | public async Task MigrateStepAsync(JellyfinMigrationStageTypes stage, IServiceProvider? serviceProvider) |
| | | 187 | | { |
| | 66 | 188 | | var logger = _startupLogger.With(_loggerFactory.CreateLogger<JellyfinMigrationService>()).BeginGroup($"Migrate s |
| | 66 | 189 | | ICollection<CodeMigration> migrationStage = (Migrations.FirstOrDefault(e => e.Stage == stage) as ICollection<Cod |
| | | 190 | | |
| | 66 | 191 | | var dbContext = await _dbContextFactory.CreateDbContextAsync().ConfigureAwait(false); |
| | 66 | 192 | | await using (dbContext.ConfigureAwait(false)) |
| | | 193 | | { |
| | 66 | 194 | | var historyRepository = dbContext.GetService<IHistoryRepository>(); |
| | 66 | 195 | | var migrationsAssembly = dbContext.GetService<IMigrationsAssembly>(); |
| | 66 | 196 | | var completedMigrations = 0; |
| | 66 | 197 | | string? lastMigrationKey = null; |
| | | 198 | | |
| | 1276 | 199 | | while (true) |
| | | 200 | | { |
| | | 201 | | // A single migration can change which migrations still apply: IMigrator.MigrateAsync treats its argumen |
| | | 202 | | // state to end up in, so it reverts everything applied after it, and a reverted migration can take code |
| | | 203 | | // with it (AddNormalizedUsername.Down drops the UpdateNormalizedUsername history row). Anything compute |
| | | 204 | | // that point is stale, so only ever run the next migration and then work out the pending set again. |
| | 1342 | 205 | | var appliedMigrations = await historyRepository.GetAppliedMigrationsAsync().ConfigureAwait(false); |
| | 1342 | 206 | | var pendingCodeMigrations = migrationStage |
| | 1342 | 207 | | .Where(e => appliedMigrations.All(f => f.MigrationId != e.BuildCodeMigrationId())) |
| | 1342 | 208 | | .Select(e => (Key: e.BuildCodeMigrationId(), Migration: new InternalCodeMigration(e, serviceProvider |
| | 1342 | 209 | | .ToArray(); |
| | | 210 | | |
| | 1342 | 211 | | (string Key, InternalDatabaseMigration Migration)[] pendingDatabaseMigrations = []; |
| | 1342 | 212 | | if (stage is JellyfinMigrationStageTypes.CoreInitialisation) |
| | | 213 | | { |
| | 1188 | 214 | | pendingDatabaseMigrations = migrationsAssembly.Migrations.Where(f => appliedMigrations.All(e => e.Mi |
| | 1188 | 215 | | .Select(e => (Key: e.Key, Migration: new InternalDatabaseMigration(e, dbContext))) |
| | 1188 | 216 | | .ToArray(); |
| | | 217 | | } |
| | | 218 | | |
| | 1342 | 219 | | (string Key, IInternalMigration Migration)[] pendingMigrations = [.. pendingCodeMigrations, .. pendingDa |
| | 1342 | 220 | | if (pendingMigrations.Length == 0) |
| | | 221 | | { |
| | | 222 | | break; |
| | | 223 | | } |
| | | 224 | | |
| | 1276 | 225 | | if (completedMigrations == 0) |
| | | 226 | | { |
| | 44 | 227 | | logger.LogInformation("There are {Pending} migrations for stage {Stage}.", pendingMigrations.Length, |
| | | 228 | | } |
| | | 229 | | |
| | 1276 | 230 | | var item = pendingMigrations.OrderBy(e => e.Key, StringComparer.Ordinal).First(); |
| | 1276 | 231 | | if (string.Equals(item.Key, lastMigrationKey, StringComparison.Ordinal)) |
| | | 232 | | { |
| | 0 | 233 | | throw new InvalidOperationException($"Migration {item.Key} ran but did not record itself as applied |
| | | 234 | | } |
| | | 235 | | |
| | 1276 | 236 | | lastMigrationKey = item.Key; |
| | | 237 | | |
| | | 238 | | // Surface generic "Running migration X of Y" progress in the always-visible startup UI header. |
| | 1276 | 239 | | SetupServer.ReportActivity(StartupActivity.Migration(completedMigrations + 1, completedMigrations + pend |
| | 1276 | 240 | | var migrationLogger = logger.With(_loggerFactory.CreateLogger(item.Migration.GetType().Name)).BeginGroup |
| | | 241 | | try |
| | | 242 | | { |
| | 1276 | 243 | | migrationLogger.LogInformation("Perform migration {Name}", item.Key); |
| | 1276 | 244 | | await item.Migration.PerformAsync(migrationLogger).ConfigureAwait(false); |
| | 1276 | 245 | | migrationLogger.LogInformation("Migration {Name} was successfully applied", item.Key); |
| | 1276 | 246 | | } |
| | 0 | 247 | | catch (Exception ex) |
| | | 248 | | { |
| | 0 | 249 | | migrationLogger.LogCritical("Error: {Error}", ex.Message); |
| | 0 | 250 | | migrationLogger.LogError(ex, "Migration {Name} failed", item.Key); |
| | | 251 | | |
| | 0 | 252 | | if (_backupKey != default && _backupService is not null && _jellyfinDatabaseProvider is not null) |
| | | 253 | | { |
| | 0 | 254 | | if (_backupKey.LibraryDb is not null) |
| | | 255 | | { |
| | 0 | 256 | | migrationLogger.LogInformation("Attempt to rollback librarydb."); |
| | | 257 | | try |
| | | 258 | | { |
| | 0 | 259 | | var libraryDbPath = Path.Combine(_applicationPaths.DataPath, DbFilename); |
| | 0 | 260 | | File.Move(_backupKey.LibraryDb, libraryDbPath, true); |
| | 0 | 261 | | } |
| | 0 | 262 | | catch (Exception inner) |
| | | 263 | | { |
| | 0 | 264 | | migrationLogger.LogCritical(inner, "Could not rollback {LibraryPath}. Manual interventio |
| | 0 | 265 | | } |
| | | 266 | | } |
| | | 267 | | |
| | 0 | 268 | | if (_backupKey.JellyfinDb is not null) |
| | | 269 | | { |
| | 0 | 270 | | migrationLogger.LogInformation("Attempt to rollback JellyfinDb."); |
| | | 271 | | try |
| | | 272 | | { |
| | 0 | 273 | | await _jellyfinDatabaseProvider.RestoreBackupFast(_backupKey.JellyfinDb, CancellationTok |
| | 0 | 274 | | } |
| | 0 | 275 | | catch (Exception inner) |
| | | 276 | | { |
| | 0 | 277 | | migrationLogger.LogCritical(inner, "Could not rollback {LibraryPath}. Manual interventio |
| | 0 | 278 | | } |
| | | 279 | | } |
| | | 280 | | |
| | 0 | 281 | | if (_backupKey.FullBackup is not null) |
| | | 282 | | { |
| | 0 | 283 | | migrationLogger.LogInformation("Attempt to rollback from backup."); |
| | | 284 | | try |
| | | 285 | | { |
| | 0 | 286 | | await _backupService.RestoreBackupAsync(_backupKey.FullBackup.Path).ConfigureAwait(false |
| | 0 | 287 | | } |
| | 0 | 288 | | catch (Exception inner) |
| | | 289 | | { |
| | 0 | 290 | | migrationLogger.LogCritical(inner, "Could not rollback from backup {Backup}. Manual inte |
| | 0 | 291 | | } |
| | | 292 | | } |
| | | 293 | | } |
| | | 294 | | |
| | 0 | 295 | | throw; |
| | | 296 | | } |
| | | 297 | | |
| | 1276 | 298 | | completedMigrations++; |
| | 1276 | 299 | | } |
| | 66 | 300 | | } |
| | 66 | 301 | | } |
| | | 302 | | |
| | | 303 | | private static string GetJellyfinVersion() |
| | | 304 | | { |
| | 946 | 305 | | return Assembly.GetEntryAssembly()!.GetName().Version!.ToString(); |
| | | 306 | | } |
| | | 307 | | |
| | | 308 | | public async Task CleanupSystemAfterMigration(ILogger logger) |
| | | 309 | | { |
| | 0 | 310 | | if (_backupKey != default) |
| | | 311 | | { |
| | 0 | 312 | | if (_backupKey.LibraryDb is not null) |
| | | 313 | | { |
| | 0 | 314 | | logger.LogInformation("Attempt to cleanup librarydb backup."); |
| | | 315 | | try |
| | | 316 | | { |
| | 0 | 317 | | File.Delete(_backupKey.LibraryDb); |
| | 0 | 318 | | } |
| | 0 | 319 | | catch (Exception inner) |
| | | 320 | | { |
| | 0 | 321 | | logger.LogCritical(inner, "Could not cleanup {LibraryPath}.", _backupKey.LibraryDb); |
| | 0 | 322 | | } |
| | | 323 | | } |
| | | 324 | | |
| | 0 | 325 | | if (_backupKey.JellyfinDb is not null && _jellyfinDatabaseProvider is not null) |
| | | 326 | | { |
| | 0 | 327 | | logger.LogInformation("Attempt to cleanup JellyfinDb backup."); |
| | | 328 | | try |
| | | 329 | | { |
| | 0 | 330 | | await _jellyfinDatabaseProvider.DeleteBackup(_backupKey.JellyfinDb).ConfigureAwait(false); |
| | 0 | 331 | | } |
| | 0 | 332 | | catch (Exception inner) |
| | | 333 | | { |
| | 0 | 334 | | logger.LogCritical(inner, "Could not cleanup {LibraryPath}.", _backupKey.JellyfinDb); |
| | 0 | 335 | | } |
| | | 336 | | } |
| | | 337 | | |
| | 0 | 338 | | if (_backupKey.FullBackup is not null) |
| | | 339 | | { |
| | 0 | 340 | | logger.LogInformation("Attempt to cleanup from migration backup."); |
| | | 341 | | try |
| | | 342 | | { |
| | 0 | 343 | | File.Delete(_backupKey.FullBackup.Path); |
| | 0 | 344 | | } |
| | 0 | 345 | | catch (Exception inner) |
| | | 346 | | { |
| | 0 | 347 | | logger.LogCritical(inner, "Could not cleanup backup {Backup}.", _backupKey.FullBackup.Path); |
| | 0 | 348 | | } |
| | | 349 | | } |
| | | 350 | | } |
| | 0 | 351 | | } |
| | | 352 | | |
| | | 353 | | public async Task PrepareSystemForMigration(ILogger logger) |
| | | 354 | | { |
| | 0 | 355 | | logger.LogInformation("Prepare system for possible migrations"); |
| | | 356 | | JellyfinMigrationBackupAttribute backupInstruction; |
| | | 357 | | IReadOnlyList<HistoryRow> appliedMigrations; |
| | 0 | 358 | | var dbContext = await _dbContextFactory.CreateDbContextAsync().ConfigureAwait(false); |
| | 0 | 359 | | await using (dbContext.ConfigureAwait(false)) |
| | | 360 | | { |
| | 0 | 361 | | var historyRepository = dbContext.GetService<IHistoryRepository>(); |
| | 0 | 362 | | var migrationsAssembly = dbContext.GetService<IMigrationsAssembly>(); |
| | 0 | 363 | | appliedMigrations = await historyRepository.GetAppliedMigrationsAsync().ConfigureAwait(false); |
| | 0 | 364 | | backupInstruction = new JellyfinMigrationBackupAttribute() |
| | 0 | 365 | | { |
| | 0 | 366 | | JellyfinDb = migrationsAssembly.Migrations.Any(f => appliedMigrations.All(e => e.MigrationId != f.Key)) |
| | 0 | 367 | | }; |
| | 0 | 368 | | } |
| | | 369 | | |
| | 0 | 370 | | backupInstruction = Migrations.SelectMany(e => e) |
| | 0 | 371 | | .Where(e => appliedMigrations.All(f => f.MigrationId != e.BuildCodeMigrationId())) |
| | 0 | 372 | | .Select(e => e.BackupRequirements) |
| | 0 | 373 | | .Where(e => e is not null) |
| | 0 | 374 | | .Aggregate(backupInstruction, MergeBackupAttributes!); |
| | | 375 | | |
| | 0 | 376 | | if (backupInstruction.LegacyLibraryDb) |
| | | 377 | | { |
| | 0 | 378 | | logger.LogInformation("A migration will attempt to modify the library.db, will attempt to backup the file no |
| | | 379 | | // for legacy migrations that still operates on the library.db |
| | 0 | 380 | | var libraryDbPath = Path.Combine(_applicationPaths.DataPath, DbFilename); |
| | 0 | 381 | | if (File.Exists(libraryDbPath)) |
| | | 382 | | { |
| | 0 | 383 | | for (int i = 1; ; i++) |
| | | 384 | | { |
| | 0 | 385 | | var bakPath = string.Format(CultureInfo.InvariantCulture, "{0}.bak{1}", libraryDbPath, i); |
| | 0 | 386 | | if (!File.Exists(bakPath)) |
| | | 387 | | { |
| | | 388 | | try |
| | | 389 | | { |
| | 0 | 390 | | logger.LogInformation("Backing up {Library} to {BackupPath}", DbFilename, bakPath); |
| | 0 | 391 | | File.Copy(libraryDbPath, bakPath); |
| | 0 | 392 | | _backupKey = (bakPath, _backupKey.JellyfinDb, _backupKey.FullBackup); |
| | 0 | 393 | | logger.LogInformation("{Library} backed up to {BackupPath}", DbFilename, bakPath); |
| | 0 | 394 | | break; |
| | | 395 | | } |
| | 0 | 396 | | catch (Exception ex) |
| | | 397 | | { |
| | 0 | 398 | | logger.LogError(ex, "Cannot make a backup of {Library} at path {BackupPath}", DbFilename, ba |
| | 0 | 399 | | throw; |
| | | 400 | | } |
| | | 401 | | } |
| | | 402 | | } |
| | | 403 | | |
| | 0 | 404 | | logger.LogInformation("{Library} has been backed up as {BackupPath}", DbFilename, _backupKey.LibraryDb); |
| | | 405 | | } |
| | | 406 | | else |
| | | 407 | | { |
| | 0 | 408 | | logger.LogError("Cannot make a backup of {Library} at path {BackupPath} because file could not be found |
| | | 409 | | } |
| | | 410 | | } |
| | | 411 | | |
| | 0 | 412 | | if (backupInstruction.JellyfinDb && _jellyfinDatabaseProvider is not null) |
| | | 413 | | { |
| | 0 | 414 | | logger.LogInformation("A migration will attempt to modify the jellyfin.db, will attempt to backup the file n |
| | 0 | 415 | | _backupKey = (_backupKey.LibraryDb, await _jellyfinDatabaseProvider.MigrationBackupFast(CancellationToken.No |
| | 0 | 416 | | logger.LogInformation("Jellyfin database has been backed up as {BackupPath}", _backupKey.JellyfinDb); |
| | | 417 | | } |
| | | 418 | | |
| | 0 | 419 | | if (_backupService is not null && (backupInstruction.Metadata || backupInstruction.Subtitles || backupInstructio |
| | | 420 | | { |
| | 0 | 421 | | logger.LogInformation("A migration will attempt to modify system resources. Will attempt to create backup no |
| | 0 | 422 | | _backupKey = (_backupKey.LibraryDb, _backupKey.JellyfinDb, await _backupService.CreateBackupAsync(new Backup |
| | 0 | 423 | | { |
| | 0 | 424 | | Metadata = backupInstruction.Metadata, |
| | 0 | 425 | | Subtitles = backupInstruction.Subtitles, |
| | 0 | 426 | | Trickplay = backupInstruction.Trickplay, |
| | 0 | 427 | | Database = false // database backups are explicitly handled by the provider itself as the backup service |
| | 0 | 428 | | }).ConfigureAwait(false)); |
| | 0 | 429 | | logger.LogInformation("Pre-Migration backup successfully created as {BackupKey}", _backupKey.FullBackup.Path |
| | | 430 | | } |
| | 0 | 431 | | } |
| | | 432 | | |
| | | 433 | | private static JellyfinMigrationBackupAttribute MergeBackupAttributes(JellyfinMigrationBackupAttribute left, Jellyfi |
| | | 434 | | { |
| | 0 | 435 | | return new JellyfinMigrationBackupAttribute() |
| | 0 | 436 | | { |
| | 0 | 437 | | JellyfinDb = left!.JellyfinDb || right!.JellyfinDb, |
| | 0 | 438 | | LegacyLibraryDb = left.LegacyLibraryDb || right!.LegacyLibraryDb, |
| | 0 | 439 | | Metadata = left.Metadata || right!.Metadata, |
| | 0 | 440 | | Subtitles = left.Subtitles || right!.Subtitles, |
| | 0 | 441 | | Trickplay = left.Trickplay || right!.Trickplay |
| | 0 | 442 | | }; |
| | | 443 | | } |
| | | 444 | | |
| | | 445 | | private class InternalCodeMigration : IInternalMigration |
| | | 446 | | { |
| | | 447 | | private readonly CodeMigration _codeMigration; |
| | | 448 | | private readonly IServiceProvider? _serviceProvider; |
| | | 449 | | private JellyfinDbContext _dbContext; |
| | | 450 | | |
| | | 451 | | public InternalCodeMigration(CodeMigration codeMigration, IServiceProvider? serviceProvider, JellyfinDbContext d |
| | | 452 | | { |
| | 330 | 453 | | _codeMigration = codeMigration; |
| | 330 | 454 | | _serviceProvider = serviceProvider; |
| | 330 | 455 | | _dbContext = dbContext; |
| | 330 | 456 | | } |
| | | 457 | | |
| | | 458 | | public async Task PerformAsync(IStartupLogger logger) |
| | | 459 | | { |
| | 110 | 460 | | await _codeMigration.Perform(_serviceProvider, logger, CancellationToken.None).ConfigureAwait(false); |
| | | 461 | | |
| | 110 | 462 | | var historyRepository = _dbContext.GetService<IHistoryRepository>(); |
| | 110 | 463 | | var createScript = historyRepository.GetInsertScript(new HistoryRow(_codeMigration.BuildCodeMigrationId(), G |
| | 110 | 464 | | await _dbContext.Database.ExecuteSqlRawAsync(createScript).ConfigureAwait(false); |
| | 110 | 465 | | } |
| | | 466 | | } |
| | | 467 | | |
| | | 468 | | private class InternalDatabaseMigration : IInternalMigration |
| | | 469 | | { |
| | | 470 | | private readonly JellyfinDbContext _jellyfinDbContext; |
| | | 471 | | private KeyValuePair<string, TypeInfo> _databaseMigrationInfo; |
| | | 472 | | |
| | | 473 | | public InternalDatabaseMigration(KeyValuePair<string, TypeInfo> databaseMigrationInfo, JellyfinDbContext jellyfi |
| | | 474 | | { |
| | 31482 | 475 | | _databaseMigrationInfo = databaseMigrationInfo; |
| | 31482 | 476 | | _jellyfinDbContext = jellyfinDbContext; |
| | 31482 | 477 | | } |
| | | 478 | | |
| | | 479 | | public async Task PerformAsync(IStartupLogger logger) |
| | | 480 | | { |
| | 1166 | 481 | | var migrator = _jellyfinDbContext.GetService<IMigrator>(); |
| | 1166 | 482 | | await migrator.MigrateAsync(_databaseMigrationInfo.Key).ConfigureAwait(false); |
| | 1166 | 483 | | } |
| | | 484 | | } |
| | | 485 | | } |