From 42deac1dce1303a54d89c85aec54ed1a26112063 Mon Sep 17 00:00:00 2001
From: Luke Pulverenti <luke.pulverenti@gmail.com>
Date: Mon, 21 Oct 2013 10:38:48 -0400
Subject: prioritize tmdb images ahead of fanart, but with min resolution
 settings

---
 .../Persistence/SqliteUserDataRepository.cs        |   7 -
 .../Persistence/UserDataMigration.cs               | 144 ---------------------
 2 files changed, 151 deletions(-)
 delete mode 100644 MediaBrowser.Server.Implementations/Persistence/UserDataMigration.cs

(limited to 'MediaBrowser.Server.Implementations/Persistence')

diff --git a/MediaBrowser.Server.Implementations/Persistence/SqliteUserDataRepository.cs b/MediaBrowser.Server.Implementations/Persistence/SqliteUserDataRepository.cs
index fa8e69b9bb..7fabe6a903 100644
--- a/MediaBrowser.Server.Implementations/Persistence/SqliteUserDataRepository.cs
+++ b/MediaBrowser.Server.Implementations/Persistence/SqliteUserDataRepository.cs
@@ -86,13 +86,6 @@ namespace MediaBrowser.Server.Implementations.Persistence
                                };
 
             _connection.RunQueries(queries, _logger);
-
-            var oldFile = Path.Combine(_appPaths.DataPath, "userdata.db");
-
-            if (File.Exists(oldFile))
-            {
-                await UserDataMigration.Migrate(oldFile, _connection, _logger, _jsonSerializer).ConfigureAwait(false);
-            }
         }
 
         /// <summary>
diff --git a/MediaBrowser.Server.Implementations/Persistence/UserDataMigration.cs b/MediaBrowser.Server.Implementations/Persistence/UserDataMigration.cs
deleted file mode 100644
index 51436f94b2..0000000000
--- a/MediaBrowser.Server.Implementations/Persistence/UserDataMigration.cs
+++ /dev/null
@@ -1,144 +0,0 @@
-using MediaBrowser.Controller.Entities;
-using MediaBrowser.Model.Logging;
-using MediaBrowser.Model.Serialization;
-using System;
-using System.Collections.Generic;
-using System.Data;
-using System.IO;
-using System.Linq;
-using System.Threading.Tasks;
-
-namespace MediaBrowser.Server.Implementations.Persistence
-{
-    public static class UserDataMigration
-    {
-        /// <summary>
-        /// Migrates the specified old file.
-        /// </summary>
-        /// <param name="oldFile">The old file.</param>
-        /// <param name="newDatabase">The new database.</param>
-        /// <param name="logger">The logger.</param>
-        /// <param name="json">The json.</param>
-        /// <returns>Task.</returns>
-        public static async Task Migrate(string oldFile, IDbConnection newDatabase, ILogger logger, IJsonSerializer json)
-        {
-            var oldDb = await SqliteExtensions.ConnectToDb(oldFile).ConfigureAwait(false);
-
-            using (oldDb)
-            {
-                IDbTransaction transaction = null;
-
-                var data = GetAllUserData(oldDb, json).ToList();
-
-                try
-                {
-                    transaction = newDatabase.BeginTransaction();
-
-                    foreach (var userdata in data)
-                    {
-                        PersistUserData(userdata, newDatabase, transaction);
-                    }
-
-                    transaction.Commit();
-                }
-                catch (OperationCanceledException)
-                {
-                    if (transaction != null)
-                    {
-                        transaction.Rollback();
-                    }
-
-                    throw;
-                }
-                catch (Exception e)
-                {
-                    logger.ErrorException("Failed to save user data:", e);
-
-                    if (transaction != null)
-                    {
-                        transaction.Rollback();
-                    }
-
-                    throw;
-                }
-                finally
-                {
-                    if (transaction != null)
-                    {
-                        transaction.Dispose();
-                    }
-                }
-            }
-
-            var backupFile = Path.Combine(Path.GetDirectoryName(oldFile), "userdata_v1.db.bak");
-
-            if (File.Exists(backupFile))
-            {
-                File.Delete(backupFile);
-            }
-
-            File.Move(oldFile, backupFile);
-        }
-
-        /// <summary>
-        /// Gets all user data.
-        /// </summary>
-        /// <param name="oldDatabase">The old database.</param>
-        /// <param name="jsonSerializer">The json serializer.</param>
-        /// <returns>IEnumerable{UserItemData}.</returns>
-        private static IEnumerable<UserItemData> GetAllUserData(IDbConnection oldDatabase, IJsonSerializer jsonSerializer)
-        {
-            using (var cmd = oldDatabase.CreateCommand())
-            {
-                cmd.CommandText = "select userId,key,data from userdata";
-
-                using (var reader = cmd.ExecuteReader(CommandBehavior.SequentialAccess | CommandBehavior.SingleResult))
-                {
-                    while (reader.Read())
-                    {
-                        var userId = reader.GetGuid(0);
-                        var key = reader.GetString(1);
-
-                        using (var stream = reader.GetMemoryStream(2))
-                        {
-                            var userData = jsonSerializer.DeserializeFromStream<UserItemData>(stream);
-
-                            userData.UserId = userId;
-                            userData.Key = key;
-
-                            yield return userData;
-                        }
-                    }
-                }
-            }
-        }
-
-        /// <summary>
-        /// Persists the user data.
-        /// </summary>
-        /// <param name="userData">The user data.</param>
-        /// <param name="database">The database.</param>
-        /// <param name="transaction">The transaction.</param>
-        private static void PersistUserData(UserItemData userData, IDbConnection database, IDbTransaction transaction)
-        {
-            using (var cmd = database.CreateCommand())
-            {
-                cmd.CommandText = "replace into userdata (key, userId, rating,played,playCount,isFavorite,playbackPositionTicks,lastPlayedDate) values (@key, @userId, @rating,@played,@playCount,@isFavorite,@playbackPositionTicks,@lastPlayedDate)";
-
-                cmd.Parameters.Add(cmd, "@key", DbType.String).Value = userData.Key;
-                cmd.Parameters.Add(cmd, "@userId", DbType.Guid).Value = userData.UserId;
-                cmd.Parameters.Add(cmd, "@rating", DbType.Double).Value = userData.Rating;
-                cmd.Parameters.Add(cmd, "@played", DbType.Boolean).Value = userData.Played;
-                cmd.Parameters.Add(cmd, "@playCount", DbType.Int32).Value = userData.PlayCount;
-                cmd.Parameters.Add(cmd, "@isFavorite", DbType.Boolean).Value = userData.IsFavorite;
-                cmd.Parameters.Add(cmd, "@playbackPositionTicks", DbType.Int64).Value = userData.PlaybackPositionTicks;
-                cmd.Parameters.Add(cmd, "@lastPlayedDate", DbType.DateTime).Value = userData.LastPlayedDate;
-
-                cmd.Transaction = transaction;
-
-                cmd.ExecuteNonQuery();
-            }
-        }
-
-    }
-}
-- 
cgit v1.2.3