diff options
Diffstat (limited to 'MediaBrowser.Server.Implementations/Persistence/SqliteProviderInfoRepository.cs')
| -rw-r--r-- | MediaBrowser.Server.Implementations/Persistence/SqliteProviderInfoRepository.cs | 37 |
1 files changed, 22 insertions, 15 deletions
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; |
