diff options
Diffstat (limited to 'MediaBrowser.Server.Implementations/Persistence/SqliteItemRepository.cs')
| -rw-r--r-- | MediaBrowser.Server.Implementations/Persistence/SqliteItemRepository.cs | 39 |
1 files changed, 30 insertions, 9 deletions
diff --git a/MediaBrowser.Server.Implementations/Persistence/SqliteItemRepository.cs b/MediaBrowser.Server.Implementations/Persistence/SqliteItemRepository.cs index ce1a91791..35ef80b32 100644 --- a/MediaBrowser.Server.Implementations/Persistence/SqliteItemRepository.cs +++ b/MediaBrowser.Server.Implementations/Persistence/SqliteItemRepository.cs @@ -72,7 +72,7 @@ namespace MediaBrowser.Server.Implementations.Persistence private IDbCommand _deletePeopleCommand; private IDbCommand _savePersonCommand; - private const int LatestSchemaVersion = 9; + private const int LatestSchemaVersion = 10; /// <summary> /// Initializes a new instance of the <see cref="SqliteItemRepository"/> class. @@ -181,6 +181,9 @@ namespace MediaBrowser.Server.Implementations.Persistence _connection.AddColumn(_logger, "TypedBaseItems", "IsLive", "BIT"); _connection.AddColumn(_logger, "TypedBaseItems", "IsNews", "BIT"); _connection.AddColumn(_logger, "TypedBaseItems", "IsPremiere", "BIT"); + + _connection.AddColumn(_logger, "TypedBaseItems", "EpisodeTitle", "Text"); + _connection.AddColumn(_logger, "TypedBaseItems", "IsRepeat", "BIT"); PrepareStatements(); @@ -208,6 +211,8 @@ namespace MediaBrowser.Server.Implementations.Persistence "IsLive", "IsNews", "IsPremiere", + "EpisodeTitle", + "IsRepeat", "CommunityRating", "CustomRating", "IndexNumber", @@ -235,6 +240,8 @@ namespace MediaBrowser.Server.Implementations.Persistence "IsLive", "IsNews", "IsPremiere", + "EpisodeTitle", + "IsRepeat", "CommunityRating", "CustomRating", "IndexNumber", @@ -386,6 +393,8 @@ namespace MediaBrowser.Server.Implementations.Persistence _saveItemCommand.GetParameter(index++).Value = hasProgramAttributes.IsLive; _saveItemCommand.GetParameter(index++).Value = hasProgramAttributes.IsNews; _saveItemCommand.GetParameter(index++).Value = hasProgramAttributes.IsPremiere; + _saveItemCommand.GetParameter(index++).Value = hasProgramAttributes.EpisodeTitle; + _saveItemCommand.GetParameter(index++).Value = hasProgramAttributes.IsRepeat; } else { @@ -396,6 +405,8 @@ namespace MediaBrowser.Server.Implementations.Persistence _saveItemCommand.GetParameter(index++).Value = null; _saveItemCommand.GetParameter(index++).Value = null; _saveItemCommand.GetParameter(index++).Value = null; + _saveItemCommand.GetParameter(index++).Value = null; + _saveItemCommand.GetParameter(index++).Value = null; } _saveItemCommand.GetParameter(index++).Value = item.CommunityRating; @@ -604,26 +615,36 @@ namespace MediaBrowser.Server.Implementations.Persistence { hasProgramAttributes.IsPremiere = reader.GetBoolean(12); } + + if (!reader.IsDBNull(13)) + { + hasProgramAttributes.EpisodeTitle = reader.GetString(13); + } + + if (!reader.IsDBNull(14)) + { + hasProgramAttributes.IsRepeat = reader.GetBoolean(14); + } } - if (!reader.IsDBNull(13)) + if (!reader.IsDBNull(15)) { - item.CommunityRating = reader.GetFloat(13); + item.CommunityRating = reader.GetFloat(15); } - if (!reader.IsDBNull(14)) + if (!reader.IsDBNull(16)) { - item.CustomRating = reader.GetString(14); + item.CustomRating = reader.GetString(16); } - if (!reader.IsDBNull(15)) + if (!reader.IsDBNull(17)) { - item.IndexNumber = reader.GetInt32(15); + item.IndexNumber = reader.GetInt32(17); } - if (!reader.IsDBNull(16)) + if (!reader.IsDBNull(18)) { - item.IsLocked = reader.GetBoolean(16); + item.IsLocked = reader.GetBoolean(18); } return item; |