aboutsummaryrefslogtreecommitdiff
path: root/Emby.Server.Implementations/Data/SqliteUserDataRepository.cs
diff options
context:
space:
mode:
authorLuke Pulverenti <luke.pulverenti@gmail.com>2016-12-12 00:49:19 -0500
committerLuke Pulverenti <luke.pulverenti@gmail.com>2016-12-12 00:49:19 -0500
commit1aff48b93b72fe7d418b4798f504bd0d145f44e8 (patch)
tree5557717b3ecbf79d7fbb6f531102f5bceafd4fa5 /Emby.Server.Implementations/Data/SqliteUserDataRepository.cs
parenta8d9a3440d0143aa7cf564f21aff2eadc4b88e6a (diff)
move book support into the core
Diffstat (limited to 'Emby.Server.Implementations/Data/SqliteUserDataRepository.cs')
-rw-r--r--Emby.Server.Implementations/Data/SqliteUserDataRepository.cs24
1 files changed, 15 insertions, 9 deletions
diff --git a/Emby.Server.Implementations/Data/SqliteUserDataRepository.cs b/Emby.Server.Implementations/Data/SqliteUserDataRepository.cs
index be59d71b3..7afb5720e 100644
--- a/Emby.Server.Implementations/Data/SqliteUserDataRepository.cs
+++ b/Emby.Server.Implementations/Data/SqliteUserDataRepository.cs
@@ -300,20 +300,26 @@ namespace Emby.Server.Implementations.Data
{
using (var connection = CreateConnection(true))
{
- using (var statement = connection.PrepareStatement("select key,userid,rating,played,playCount,isFavorite,playbackPositionTicks,lastPlayedDate,AudioStreamIndex,SubtitleStreamIndex from userdata where key =@Key and userId=@UserId"))
- {
- statement.TryBind("@UserId", userId.ToGuidParamValue());
- statement.TryBind("@Key", key);
+ UserItemData result = null;
- foreach (var row in statement.ExecuteQuery())
+ connection.RunInTransaction(db =>
+ {
+ using (var statement = db.PrepareStatement("select key,userid,rating,played,playCount,isFavorite,playbackPositionTicks,lastPlayedDate,AudioStreamIndex,SubtitleStreamIndex from userdata where key =@Key and userId=@UserId"))
{
- return ReadRow(row);
+ statement.TryBind("@UserId", userId.ToGuidParamValue());
+ statement.TryBind("@Key", key);
+
+ foreach (var row in statement.ExecuteQuery())
+ {
+ result = ReadRow(row);
+ break;
+ }
}
- }
+ }, ReadTransactionMode);
+
+ return result;
}
}
-
- return null;
}
public UserItemData GetUserData(Guid userId, List<string> keys)