| | | 1 | | using System; |
| | | 2 | | using System.Collections.Generic; |
| | | 3 | | using System.IO; |
| | | 4 | | using Emby.Server.Implementations.Data; |
| | | 5 | | using Jellyfin.Database.Implementations; |
| | | 6 | | using Jellyfin.Database.Implementations.Entities.Security; |
| | | 7 | | using MediaBrowser.Controller; |
| | | 8 | | using MediaBrowser.Controller.Library; |
| | | 9 | | using Microsoft.Data.Sqlite; |
| | | 10 | | using Microsoft.EntityFrameworkCore; |
| | | 11 | | using Microsoft.Extensions.Logging; |
| | | 12 | | |
| | | 13 | | namespace Jellyfin.Server.Migrations.Routines |
| | | 14 | | { |
| | | 15 | | /// <summary> |
| | | 16 | | /// A migration that moves data from the authentication database into the new schema. |
| | | 17 | | /// </summary> |
| | | 18 | | #pragma warning disable CS0618 // Type or member is obsolete |
| | | 19 | | [JellyfinMigration("2025-04-20T14:00:00", nameof(MigrateAuthenticationDb), "5BD72F41-E6F3-4F60-90AA-09869ABE0E22")] |
| | | 20 | | public class MigrateAuthenticationDb : IMigrationRoutine |
| | | 21 | | #pragma warning restore CS0618 // Type or member is obsolete |
| | | 22 | | { |
| | | 23 | | private const string DbFilename = "authentication.db"; |
| | | 24 | | |
| | | 25 | | private readonly ILogger<MigrateAuthenticationDb> _logger; |
| | | 26 | | private readonly IDbContextFactory<JellyfinDbContext> _dbProvider; |
| | | 27 | | private readonly IServerApplicationPaths _appPaths; |
| | | 28 | | private readonly IUserManager _userManager; |
| | | 29 | | |
| | | 30 | | /// <summary> |
| | | 31 | | /// Initializes a new instance of the <see cref="MigrateAuthenticationDb"/> class. |
| | | 32 | | /// </summary> |
| | | 33 | | /// <param name="logger">The logger.</param> |
| | | 34 | | /// <param name="dbProvider">The database provider.</param> |
| | | 35 | | /// <param name="appPaths">The server application paths.</param> |
| | | 36 | | /// <param name="userManager">The user manager.</param> |
| | | 37 | | public MigrateAuthenticationDb( |
| | | 38 | | ILogger<MigrateAuthenticationDb> logger, |
| | | 39 | | IDbContextFactory<JellyfinDbContext> dbProvider, |
| | | 40 | | IServerApplicationPaths appPaths, |
| | | 41 | | IUserManager userManager) |
| | | 42 | | { |
| | 0 | 43 | | _logger = logger; |
| | 0 | 44 | | _dbProvider = dbProvider; |
| | 0 | 45 | | _appPaths = appPaths; |
| | 0 | 46 | | _userManager = userManager; |
| | 0 | 47 | | } |
| | | 48 | | |
| | | 49 | | /// <inheritdoc /> |
| | | 50 | | public void Perform() |
| | | 51 | | { |
| | 0 | 52 | | var dataPath = _appPaths.DataPath; |
| | 0 | 53 | | using (var connection = new SqliteConnection($"Filename={Path.Combine(dataPath, DbFilename)}")) |
| | | 54 | | { |
| | 0 | 55 | | connection.Open(); |
| | 0 | 56 | | using var dbContext = _dbProvider.CreateDbContext(); |
| | | 57 | | |
| | 0 | 58 | | var authenticatedDevices = connection.Query("SELECT * FROM Tokens"); |
| | | 59 | | |
| | 0 | 60 | | foreach (var row in authenticatedDevices) |
| | | 61 | | { |
| | 0 | 62 | | var dateCreatedStr = row.GetString(9); |
| | 0 | 63 | | _ = DateTime.TryParse(dateCreatedStr, out var dateCreated); |
| | 0 | 64 | | var dateLastActivityStr = row.GetString(10); |
| | 0 | 65 | | _ = DateTime.TryParse(dateLastActivityStr, out var dateLastActivity); |
| | | 66 | | |
| | 0 | 67 | | if (row.IsDBNull(6)) |
| | | 68 | | { |
| | 0 | 69 | | dbContext.ApiKeys.Add(new ApiKey(row.GetString(3)) |
| | 0 | 70 | | { |
| | 0 | 71 | | AccessToken = row.GetString(1), |
| | 0 | 72 | | DateCreated = dateCreated, |
| | 0 | 73 | | DateLastActivity = dateLastActivity |
| | 0 | 74 | | }); |
| | | 75 | | } |
| | | 76 | | else |
| | | 77 | | { |
| | 0 | 78 | | var userId = row.GetGuid(6); |
| | 0 | 79 | | var user = _userManager.GetUserById(userId); |
| | 0 | 80 | | if (user is null) |
| | | 81 | | { |
| | | 82 | | // User doesn't exist, don't bring over the device. |
| | | 83 | | continue; |
| | | 84 | | } |
| | | 85 | | |
| | 0 | 86 | | dbContext.Devices.Add(new Device( |
| | 0 | 87 | | userId, |
| | 0 | 88 | | row.GetString(3), |
| | 0 | 89 | | row.GetString(4), |
| | 0 | 90 | | row.GetString(5), |
| | 0 | 91 | | row.GetString(2)) |
| | 0 | 92 | | { |
| | 0 | 93 | | AccessToken = row.GetString(1), |
| | 0 | 94 | | IsActive = row.GetBoolean(8), |
| | 0 | 95 | | DateCreated = dateCreated, |
| | 0 | 96 | | DateLastActivity = dateLastActivity |
| | 0 | 97 | | }); |
| | | 98 | | } |
| | | 99 | | } |
| | | 100 | | |
| | 0 | 101 | | var deviceOptions = connection.Query("SELECT * FROM Devices"); |
| | 0 | 102 | | var deviceIds = new HashSet<string>(); |
| | 0 | 103 | | foreach (var row in deviceOptions) |
| | | 104 | | { |
| | 0 | 105 | | if (row.IsDBNull(2)) |
| | | 106 | | { |
| | | 107 | | continue; |
| | | 108 | | } |
| | | 109 | | |
| | 0 | 110 | | var deviceId = row.GetString(2); |
| | 0 | 111 | | if (deviceIds.Contains(deviceId)) |
| | | 112 | | { |
| | | 113 | | continue; |
| | | 114 | | } |
| | | 115 | | |
| | 0 | 116 | | deviceIds.Add(deviceId); |
| | | 117 | | |
| | 0 | 118 | | dbContext.DeviceOptions.Add(new DeviceOptions(deviceId) |
| | 0 | 119 | | { |
| | 0 | 120 | | CustomName = row.IsDBNull(1) ? null : row.GetString(1) |
| | 0 | 121 | | }); |
| | | 122 | | } |
| | | 123 | | |
| | 0 | 124 | | dbContext.SaveChanges(); |
| | | 125 | | } |
| | | 126 | | |
| | | 127 | | try |
| | | 128 | | { |
| | 0 | 129 | | File.Move(Path.Combine(dataPath, DbFilename), Path.Combine(dataPath, DbFilename + ".old")); |
| | | 130 | | |
| | 0 | 131 | | var journalPath = Path.Combine(dataPath, DbFilename + "-journal"); |
| | 0 | 132 | | if (File.Exists(journalPath)) |
| | | 133 | | { |
| | 0 | 134 | | File.Move(journalPath, Path.Combine(dataPath, DbFilename + ".old-journal")); |
| | | 135 | | } |
| | 0 | 136 | | } |
| | 0 | 137 | | catch (IOException e) |
| | | 138 | | { |
| | 0 | 139 | | _logger.LogError(e, "Error renaming legacy activity log database to 'authentication.db.old'"); |
| | 0 | 140 | | } |
| | 0 | 141 | | } |
| | | 142 | | } |
| | | 143 | | } |