public void MultiAddtionTest()
{
var image = Path.Combine(Paths.ProgramFolder, "Resources", "Images", "applogo.png");
var path = Path.Combine(Playnite.PlayniteTests.TempPath, "filemulti.db");
FileSystem.DeleteFile(path);
var db = new GameDatabase(null);
using (db.OpenDatabase(path))
{
db.AddFile("test.png", "test.png", File.ReadAllBytes(image));
var id = db.AddFileNoDuplicate("test2.png", "test2.png", File.ReadAllBytes(image));
Assert.AreEqual("test.png", id);
Assert.AreEqual(1, db.Database.FileStorage.FindAll().Count());
}
FileSystem.DeleteFile(path);
db = new GameDatabase(null);
using (db.OpenDatabase(path))
{
db.AddFileNoDuplicate("test.png", "test.png", File.ReadAllBytes(image));
var id = db.AddFileNoDuplicate("test2.png", "test2.png", File.ReadAllBytes(image));
Assert.AreEqual("test.png", id);
Assert.AreEqual(1, db.Database.FileStorage.FindAll().Count());
}
FileSystem.DeleteFile(path);
db = new GameDatabase(null);
using (db.OpenDatabase(path))
{
db.AddFileNoDuplicate("test.png", "test.png", File.ReadAllBytes(image));
db.AddFile("test2.png", "test2.png", File.ReadAllBytes(image));
Assert.AreEqual(2, db.Database.FileStorage.FindAll().Count());
}
}
public void MultiAddtionTest()
{
var image = Path.Combine(Paths.ProgramFolder, "Resources", "Images", "applogo.png");
var db = new GameDatabase(null);
using (db.OpenDatabase(new MemoryStream()))
{
db.AddFile("test.png", "test.png", File.ReadAllBytes(image));
var id = db.AddFileNoDuplicate("test2.png", "test2.png", File.ReadAllBytes(image));
Assert.AreEqual("test.png", id);
Assert.AreEqual(1, db.Database.FileStorage.FindAll().Count());
}
db = new GameDatabase(null);
using (db.OpenDatabase(new MemoryStream()))
{
db.AddFileNoDuplicate("test.png", "test.png", File.ReadAllBytes(image));
var id = db.AddFileNoDuplicate("test2.png", "test2.png", File.ReadAllBytes(image));
Assert.AreEqual("test.png", id);
Assert.AreEqual(1, db.Database.FileStorage.FindAll().Count());
}
db = new GameDatabase(null);
using (db.OpenDatabase(new MemoryStream()))
{
db.AddFileNoDuplicate("test.png", "test.png", File.ReadAllBytes(image));
db.AddFile("test2.png", "test2.png", File.ReadAllBytes(image));
Assert.AreEqual(2, db.Database.FileStorage.FindAll().Count());
}
}
public string AddFile(string id, string path)
{
if (!File.Exists(path))
{
throw new Exception("Cannot add file to db, file not found.");
}
return(database.AddFileNoDuplicate(id, Path.GetFileName(path), File.ReadAllBytes(path)));
}
public async Task DownloadMetadataAsync(
List <Game> games,
GameDatabase database,
MetadataDownloaderSettings settings,
Action <Game, int, int> processCallback,
CancellationTokenSource cancelToken)
{
await Task.Run(() =>
{
if (games == null || games.Count == 0)
{
return;
}
for (int i = 0; i < games.Count; i++)
{
if (cancelToken?.IsCancellationRequested == true)
{
return;
}
GameMetadata storeData = null;
GameMetadata igdbData = null;
GameMetadata gameData = null;
// We need to get new instance from DB in case game got edited or deleted.
// We don't want to block game editing while metadata is downloading for other games.
// TODO: Use Id instead of GameId once we replace LiteDB and have proper autoincrement Id
var game = database.GamesCollection.FindOne(a => a.PluginId == games[i].PluginId && a.GameId == games[i].GameId);
if (game == null)
{
logger.Warn($"Game {game.GameId} no longer in DB, skipping metadata download.");
processCallback?.Invoke(null, i, games.Count);
continue;
}
try
{
logger.Debug($"Downloading metadata for {game.PluginId} game {game.Name}, {game.GameId}");
// Name
if (!game.IsCustomGame && settings.Name.Import)
{
gameData = ProcessField(game, settings.Name, ref storeData, ref igdbData, (a) => a.GameData?.Name);
if (!string.IsNullOrEmpty(gameData?.GameData?.Name))
{
game.Name = StringExtensions.RemoveTrademarks(gameData.GameData.Name);
var sortingName = StringExtensions.ConvertToSortableName(game.Name);
if (sortingName != game.Name)
{
game.SortingName = sortingName;
}
}
}
// Genre
if (settings.Genre.Import)
{
if (!settings.SkipExistingValues || (settings.SkipExistingValues && ListExtensions.IsNullOrEmpty(game.Genres)))
{
gameData = ProcessField(game, settings.Genre, ref storeData, ref igdbData, (a) => a.GameData?.Genres);
game.Genres = ListExtensions.IsNullOrEmpty(gameData?.GameData?.Genres) ? game.Genres : gameData.GameData.Genres;
}
}
// Release Date
if (settings.ReleaseDate.Import)
{
if (!settings.SkipExistingValues || (settings.SkipExistingValues && game.ReleaseDate == null))
{
gameData = ProcessField(game, settings.ReleaseDate, ref storeData, ref igdbData, (a) => a.GameData?.ReleaseDate);
game.ReleaseDate = gameData?.GameData?.ReleaseDate ?? game.ReleaseDate;
}
}
// Developer
if (settings.Developer.Import)
{
if (!settings.SkipExistingValues || (settings.SkipExistingValues && ListExtensions.IsNullOrEmpty(game.Developers)))
{
gameData = ProcessField(game, settings.Developer, ref storeData, ref igdbData, (a) => a.GameData?.Developers);
game.Developers = ListExtensions.IsNullOrEmpty(gameData?.GameData?.Developers) ? game.Developers : gameData.GameData.Developers;
}
}
// Publisher
if (settings.Publisher.Import)
{
if (!settings.SkipExistingValues || (settings.SkipExistingValues && ListExtensions.IsNullOrEmpty(game.Publishers)))
{
gameData = ProcessField(game, settings.Publisher, ref storeData, ref igdbData, (a) => a.GameData?.Publishers);
game.Publishers = ListExtensions.IsNullOrEmpty(gameData?.GameData?.Publishers) ? game.Publishers : gameData.GameData.Publishers;
}
}
// Tags / Features
if (settings.Tag.Import)
{
if (!settings.SkipExistingValues || (settings.SkipExistingValues && ListExtensions.IsNullOrEmpty(game.Tags)))
{
gameData = ProcessField(game, settings.Tag, ref storeData, ref igdbData, (a) => a.GameData?.Tags);
game.Tags = ListExtensions.IsNullOrEmpty(gameData?.GameData?.Tags) ? game.Tags : gameData.GameData.Tags;
}
}
// Description
if (settings.Description.Import)
{
if (!settings.SkipExistingValues || (settings.SkipExistingValues && string.IsNullOrEmpty(game.Description)))
{
gameData = ProcessField(game, settings.Description, ref storeData, ref igdbData, (a) => a.GameData?.Description);
game.Description = string.IsNullOrEmpty(gameData?.GameData?.Description) == true ? game.Description : gameData.GameData.Description;
}
}
// Links
if (settings.Links.Import)
{
if (!settings.SkipExistingValues || (settings.SkipExistingValues && game.Links == null))
{
gameData = ProcessField(game, settings.Links, ref storeData, ref igdbData, (a) => a.GameData?.Links);
game.Links = gameData?.GameData?.Links ?? game.Links;
}
}
// Critic Score
if (settings.CriticScore.Import)
{
if (!settings.SkipExistingValues || (settings.SkipExistingValues && game.CriticScore == null))
{
gameData = ProcessField(game, settings.CriticScore, ref storeData, ref igdbData, (a) => a.GameData?.CriticScore);
game.CriticScore = gameData?.GameData?.CriticScore == null ? game.CriticScore : gameData.GameData.CriticScore;
}
}
// Community Score
if (settings.CommunityScore.Import)
{
if (!settings.SkipExistingValues || (settings.SkipExistingValues && game.CommunityScore == null))
{
gameData = ProcessField(game, settings.CommunityScore, ref storeData, ref igdbData, (a) => a.GameData?.CommunityScore);
game.CommunityScore = gameData?.GameData?.CommunityScore == null ? game.CommunityScore : gameData.GameData.CommunityScore;
}
}
// BackgroundImage
if (settings.BackgroundImage.Import)
{
if (!settings.SkipExistingValues || (settings.SkipExistingValues && string.IsNullOrEmpty(game.BackgroundImage)))
{
gameData = ProcessField(game, settings.BackgroundImage, ref storeData, ref igdbData, (a) => a.BackgroundImage);
game.BackgroundImage = string.IsNullOrEmpty(gameData?.BackgroundImage) ? game.BackgroundImage : gameData.BackgroundImage;
}
}
// Cover
if (settings.CoverImage.Import)
{
if (!settings.SkipExistingValues || (settings.SkipExistingValues && string.IsNullOrEmpty(game.CoverImage)))
{
gameData = ProcessField(game, settings.CoverImage, ref storeData, ref igdbData, (a) => a.Image);
if (gameData?.Image != null)
{
if (!string.IsNullOrEmpty(game.CoverImage))
{
database.DeleteImageSafe(game.CoverImage, game);
}
var imageId = database.AddFileNoDuplicate(gameData.Image);
game.CoverImage = imageId;
}
}
}
// Icon
if (settings.Icon.Import)
{
if (!settings.SkipExistingValues || (settings.SkipExistingValues && string.IsNullOrEmpty(game.Icon)))
{
gameData = ProcessField(game, settings.Icon, ref storeData, ref igdbData, (a) => a.Icon);
if (gameData?.Icon != null)
{
if (!string.IsNullOrEmpty(game.Icon))
{
database.DeleteImageSafe(game.Icon, game);
}
var iconId = database.AddFileNoDuplicate(gameData.Icon);
game.Icon = iconId;
}
}
}
// TODO make this configurable and re-downalodable manually
// Only update them if they don't exist yet
if (game.OtherActions?.Any() != true && storeData != null)
{
if (storeData?.GameData?.OtherActions?.Any() == true)
{
game.OtherActions = new System.Collections.ObjectModel.ObservableCollection <GameAction>();
foreach (var task in storeData.GameData.OtherActions)
{
game.OtherActions.Add(task);
}
}
}
// Just to be sure check if somebody didn't remove game while downloading data
if (database.GamesCollection.FindOne(a => a.GameId == games[i].GameId) != null)
{
database.UpdateGameInDatabase(game);
}
else
{
logger.Warn($"Game {game.GameId} no longer in DB, skipping metadata update in DB.");
}
}
catch (Exception e) when(!PlayniteEnvironment.ThrowAllErrors)
{
logger.Error(e, $"Failed to download metadata for game {game.Name}, {game.GameId}");
}
finally
{
processCallback?.Invoke(game, i, games.Count);
}
}
});
}