From 7f5a4c2d4e3d8e1881dae0403367e35ad5699eaf Mon Sep 17 00:00:00 2001
From: Luke Pulverenti <luke.pulverenti@gmail.com>
Date: Sat, 8 Feb 2014 17:38:02 -0500
Subject: added item type to refresh info

---
 .../Persistence/SqliteProviderInfoRepository.cs    | 37 +++++++++++++---------
 1 file changed, 22 insertions(+), 15 deletions(-)

(limited to 'MediaBrowser.Server.Implementations')

diff --git a/MediaBrowser.Server.Implementations/Persistence/SqliteProviderInfoRepository.cs b/MediaBrowser.Server.Implementations/Persistence/SqliteProviderInfoRepository.cs
index eb6e142c1..b99a84c5c 100644
--- a/MediaBrowser.Server.Implementations/Persistence/SqliteProviderInfoRepository.cs
+++ b/MediaBrowser.Server.Implementations/Persistence/SqliteProviderInfoRepository.cs
@@ -51,7 +51,7 @@ namespace MediaBrowser.Server.Implementations.Persistence
 
             string[] queries = {
 
-                                "create table if not exists MetadataStatus (ItemId GUID PRIMARY KEY, ItemName TEXT, SeriesName TEXT, DateLastMetadataRefresh datetime, DateLastImagesRefresh datetime, LastStatus TEXT, LastErrorMessage TEXT, MetadataProvidersRefreshed TEXT, ImageProvidersRefreshed TEXT)",
+                                "create table if not exists MetadataStatus (ItemId GUID PRIMARY KEY, ItemName TEXT, ItemType TEXT, SeriesName TEXT, DateLastMetadataRefresh datetime, DateLastImagesRefresh datetime, LastStatus TEXT, LastErrorMessage TEXT, MetadataProvidersRefreshed TEXT, ImageProvidersRefreshed TEXT)",
                                 "create index if not exists idx_MetadataStatus on MetadataStatus(ItemId)",
 
                                 //pragmas
@@ -71,6 +71,7 @@ namespace MediaBrowser.Server.Implementations.Persistence
         {
             "ItemId",
             "ItemName",
+            "ItemType",
             "SeriesName",
             "DateLastMetadataRefresh",
             "DateLastImagesRefresh",
@@ -144,37 +145,42 @@ namespace MediaBrowser.Server.Implementations.Persistence
 
             if (!reader.IsDBNull(2))
             {
-                result.SeriesName = reader.GetString(2);
+                result.ItemName = reader.GetString(2);
             }
 
             if (!reader.IsDBNull(3))
             {
-                result.DateLastMetadataRefresh = reader.GetDateTime(3).ToUniversalTime();
+                result.SeriesName = reader.GetString(3);
             }
 
             if (!reader.IsDBNull(4))
             {
-                result.DateLastImagesRefresh = reader.GetDateTime(4).ToUniversalTime();
+                result.DateLastMetadataRefresh = reader.GetDateTime(4).ToUniversalTime();
             }
 
             if (!reader.IsDBNull(5))
             {
-                result.LastStatus = (ProviderRefreshStatus)Enum.Parse(typeof(ProviderRefreshStatus), reader.GetString(5), true);
+                result.DateLastImagesRefresh = reader.GetDateTime(5).ToUniversalTime();
             }
 
             if (!reader.IsDBNull(6))
             {
-                result.LastErrorMessage = reader.GetString(6);
+                result.LastStatus = (ProviderRefreshStatus)Enum.Parse(typeof(ProviderRefreshStatus), reader.GetString(6), true);
             }
 
             if (!reader.IsDBNull(7))
             {
-                result.MetadataProvidersRefreshed = reader.GetString(7).Split('|').Where(i => !string.IsNullOrEmpty(i)).Select(i => new Guid(i)).ToList();
+                result.LastErrorMessage = reader.GetString(7);
             }
 
             if (!reader.IsDBNull(8))
             {
-                result.ImageProvidersRefreshed = reader.GetString(8).Split('|').Where(i => !string.IsNullOrEmpty(i)).Select(i => new Guid(i)).ToList();
+                result.MetadataProvidersRefreshed = reader.GetString(8).Split('|').Where(i => !string.IsNullOrEmpty(i)).Select(i => new Guid(i)).ToList();
+            }
+
+            if (!reader.IsDBNull(9))
+            {
+                result.ImageProvidersRefreshed = reader.GetString(9).Split('|').Where(i => !string.IsNullOrEmpty(i)).Select(i => new Guid(i)).ToList();
             }
 
             return result;
@@ -199,13 +205,14 @@ namespace MediaBrowser.Server.Implementations.Persistence
                 
                 _saveStatusCommand.GetParameter(0).Value = status.ItemId;
                 _saveStatusCommand.GetParameter(1).Value = status.ItemName;
-                _saveStatusCommand.GetParameter(2).Value = status.SeriesName;
-                _saveStatusCommand.GetParameter(3).Value = status.DateLastMetadataRefresh;
-                _saveStatusCommand.GetParameter(4).Value = status.DateLastImagesRefresh;
-                _saveStatusCommand.GetParameter(5).Value = status.LastStatus.ToString();
-                _saveStatusCommand.GetParameter(6).Value = status.LastErrorMessage;
-                _saveStatusCommand.GetParameter(7).Value = string.Join("|", status.MetadataProvidersRefreshed.ToArray());
-                _saveStatusCommand.GetParameter(8).Value = string.Join("|", status.ImageProvidersRefreshed.ToArray());
+                _saveStatusCommand.GetParameter(2).Value = status.ItemType;
+                _saveStatusCommand.GetParameter(3).Value = status.SeriesName;
+                _saveStatusCommand.GetParameter(4).Value = status.DateLastMetadataRefresh;
+                _saveStatusCommand.GetParameter(5).Value = status.DateLastImagesRefresh;
+                _saveStatusCommand.GetParameter(6).Value = status.LastStatus.ToString();
+                _saveStatusCommand.GetParameter(7).Value = status.LastErrorMessage;
+                _saveStatusCommand.GetParameter(8).Value = string.Join("|", status.MetadataProvidersRefreshed.ToArray());
+                _saveStatusCommand.GetParameter(9).Value = string.Join("|", status.ImageProvidersRefreshed.ToArray());
 
                 _saveStatusCommand.Transaction = transaction;
 
-- 
cgit v1.2.3