| | | 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 | | public class MigrateAuthenticationDb : IMigrationRoutine |
| | | 19 | | { |
| | | 20 | | private const string DbFilename = "authentication.db"; |
| | | 21 | | |
| | | 22 | | private readonly ILogger<MigrateAuthenticationDb> _logger; |
| | | 23 | | private readonly IDbContextFactory<JellyfinDbContext> _dbProvider; |
| | | 24 | | private readonly IServerApplicationPaths _appPaths; |
| | | 25 | | private readonly IUserManager _userManager; |
| | | 26 | | |
| | | 27 | | /// <summary> |
| | | 28 | | /// Initializes a new instance of the <see cref="MigrateAuthenticationDb"/> class. |
| | | 29 | | /// </summary> |
| | | 30 | | /// <param name="logger">The logger.</param> |
| | | 31 | | /// <param name="dbProvider">The database provider.</param> |
| | | 32 | | /// <param name="appPaths">The server application paths.</param> |
| | | 33 | | /// <param name="userManager">The user manager.</param> |
| | | 34 | | public MigrateAuthenticationDb( |
| | | 35 | | ILogger<MigrateAuthenticationDb> logger, |
| | | 36 | | IDbContextFactory<JellyfinDbContext> dbProvider, |
| | | 37 | | IServerApplicationPaths appPaths, |
| | | 38 | | IUserManager userManager) |
| | | 39 | | { |
| | 0 | 40 | | _logger = logger; |
| | 0 | 41 | | _dbProvider = dbProvider; |
| | 0 | 42 | | _appPaths = appPaths; |
| | 0 | 43 | | _userManager = userManager; |
| | 0 | 44 | | } |
| | | 45 | | |
| | | 46 | | /// <inheritdoc /> |
| | 0 | 47 | | public Guid Id => Guid.Parse("5BD72F41-E6F3-4F60-90AA-09869ABE0E22"); |
| | | 48 | | |
| | | 49 | | /// <inheritdoc /> |
| | 0 | 50 | | public string Name => "MigrateAuthenticationDatabase"; |
| | | 51 | | |
| | | 52 | | /// <inheritdoc /> |
| | 0 | 53 | | public bool PerformOnNewInstall => false; |
| | | 54 | | |
| | | 55 | | /// <inheritdoc /> |
| | | 56 | | public void Perform() |
| | | 57 | | { |
| | 0 | 58 | | var dataPath = _appPaths.DataPath; |
| | 0 | 59 | | using (var connection = new SqliteConnection($"Filename={Path.Combine(dataPath, DbFilename)}")) |
| | | 60 | | { |
| | 0 | 61 | | connection.Open(); |
| | 0 | 62 | | using var dbContext = _dbProvider.CreateDbContext(); |
| | | 63 | | |
| | 0 | 64 | | var authenticatedDevices = connection.Query("SELECT * FROM Tokens"); |
| | | 65 | | |
| | 0 | 66 | | foreach (var row in authenticatedDevices) |
| | | 67 | | { |
| | 0 | 68 | | var dateCreatedStr = row.GetString(9); |
| | 0 | 69 | | _ = DateTime.TryParse(dateCreatedStr, out var dateCreated); |
| | 0 | 70 | | var dateLastActivityStr = row.GetString(10); |
| | 0 | 71 | | _ = DateTime.TryParse(dateLastActivityStr, out var dateLastActivity); |
| | | 72 | | |
| | 0 | 73 | | if (row.IsDBNull(6)) |
| | | 74 | | { |
| | 0 | 75 | | dbContext.ApiKeys.Add(new ApiKey(row.GetString(3)) |
| | 0 | 76 | | { |
| | 0 | 77 | | AccessToken = row.GetString(1), |
| | 0 | 78 | | DateCreated = dateCreated, |
| | 0 | 79 | | DateLastActivity = dateLastActivity |
| | 0 | 80 | | }); |
| | | 81 | | } |
| | | 82 | | else |
| | | 83 | | { |
| | 0 | 84 | | var userId = row.GetGuid(6); |
| | 0 | 85 | | var user = _userManager.GetUserById(userId); |
| | 0 | 86 | | if (user is null) |
| | | 87 | | { |
| | | 88 | | // User doesn't exist, don't bring over the device. |
| | | 89 | | continue; |
| | | 90 | | } |
| | | 91 | | |
| | 0 | 92 | | dbContext.Devices.Add(new Device( |
| | 0 | 93 | | userId, |
| | 0 | 94 | | row.GetString(3), |
| | 0 | 95 | | row.GetString(4), |
| | 0 | 96 | | row.GetString(5), |
| | 0 | 97 | | row.GetString(2)) |
| | 0 | 98 | | { |
| | 0 | 99 | | AccessToken = row.GetString(1), |
| | 0 | 100 | | IsActive = row.GetBoolean(8), |
| | 0 | 101 | | DateCreated = dateCreated, |
| | 0 | 102 | | DateLastActivity = dateLastActivity |
| | 0 | 103 | | }); |
| | | 104 | | } |
| | | 105 | | } |
| | | 106 | | |
| | 0 | 107 | | var deviceOptions = connection.Query("SELECT * FROM Devices"); |
| | 0 | 108 | | var deviceIds = new HashSet<string>(); |
| | 0 | 109 | | foreach (var row in deviceOptions) |
| | | 110 | | { |
| | 0 | 111 | | if (row.IsDBNull(2)) |
| | | 112 | | { |
| | | 113 | | continue; |
| | | 114 | | } |
| | | 115 | | |
| | 0 | 116 | | var deviceId = row.GetString(2); |
| | 0 | 117 | | if (deviceIds.Contains(deviceId)) |
| | | 118 | | { |
| | | 119 | | continue; |
| | | 120 | | } |
| | | 121 | | |
| | 0 | 122 | | deviceIds.Add(deviceId); |
| | | 123 | | |
| | 0 | 124 | | dbContext.DeviceOptions.Add(new DeviceOptions(deviceId) |
| | 0 | 125 | | { |
| | 0 | 126 | | CustomName = row.IsDBNull(1) ? null : row.GetString(1) |
| | 0 | 127 | | }); |
| | | 128 | | } |
| | | 129 | | |
| | 0 | 130 | | dbContext.SaveChanges(); |
| | | 131 | | } |
| | | 132 | | |
| | | 133 | | try |
| | | 134 | | { |
| | 0 | 135 | | File.Move(Path.Combine(dataPath, DbFilename), Path.Combine(dataPath, DbFilename + ".old")); |
| | | 136 | | |
| | 0 | 137 | | var journalPath = Path.Combine(dataPath, DbFilename + "-journal"); |
| | 0 | 138 | | if (File.Exists(journalPath)) |
| | | 139 | | { |
| | 0 | 140 | | File.Move(journalPath, Path.Combine(dataPath, DbFilename + ".old-journal")); |
| | | 141 | | } |
| | 0 | 142 | | } |
| | 0 | 143 | | catch (IOException e) |
| | | 144 | | { |
| | 0 | 145 | | _logger.LogError(e, "Error renaming legacy activity log database to 'authentication.db.old'"); |
| | 0 | 146 | | } |
| | 0 | 147 | | } |
| | | 148 | | } |
| | | 149 | | } |