private void AddNewColumns(IDbConnection con) { con.AlterTable("EmbyContent", "ADD", "AddedAt", true, "VARCHAR(50)"); con.AlterTable("EmbyEpisodes", "ADD", "AddedAt", true, "VARCHAR(50)"); con.AlterTable("PlexContent", "ADD", "ItemId", true, "VARCHAR(100)"); con.AlterTable("PlexContent", "ADD", "AddedAt", true, "VARCHAR(100)"); }
private void UpdateDb(IDbConnection con) { try { // Create the two new columns con.AlterTable("Users", "ADD", "Permissions", true, "INTEGER"); con.AlterTable("Users", "ADD", "Features", true, "INTEGER"); con.AlterTable("PlexUsers", "ADD", "Permissions", true, "INTEGER"); con.AlterTable("PlexUsers", "ADD", "Features", true, "INTEGER"); con.AlterTable("PlexUsers", "ADD", "Username", true, "VARCHAR(100)"); con.AlterTable("PlexUsers", "ADD", "EmailAddress", true, "VARCHAR(100)"); con.AlterTable("PlexUsers", "ADD", "LoginId", true, "VARCHAR(100)"); //https://image.tmdb.org/t/p/w150/https://image.tmdb.org/t/p/w150//aqhAqttDq7zgsTaBHtCD8wmTk6k.jpg // UI = https://image.tmdb.org/t/p/w150/{{posterPath}} // Update old invalid posters var allRequests = RequestService.GetAll(); if (allRequests == null) { return; } var requestedModels = allRequests.ToList(); foreach (var req in requestedModels) { if (string.IsNullOrEmpty(req.PosterPath)) { continue; } if (req.PosterPath.Contains("https://image.tmdb.org/t/p/w150/")) { var newImg = req.PosterPath.Replace("https://image.tmdb.org/t/p/w150/", string.Empty); req.PosterPath = newImg; } } RequestService.BatchUpdate(requestedModels); } catch (Exception e) { Logger.Fatal("Exception when migrating Version 1.10.0 (UpdateDb)"); Logger.Fatal(e); } }