public JObject GetItemData(JObject request)
{
ISyncableItemInfo requestedItemInfo = SyncUtil.SyncableItemInfoFromJson(request["item"]);
var json = new JObject();
JObject builder = SyncUtil.JsonItemFromSyncableItemInfo(requestedItemInfo);
_store.BuildItemData(requestedItemInfo, builder);
json.Add(new JProperty("item", builder));
return(json);
}
public static void ReplaceAllItemRefs(IDbConnection connection, ISyncableStore store,
ISyncableItemInfo remoteItemInfo, ISyncableItemInfo changedItemInfo)
{
// update *all* the itemData.item refs in all rows from remoteItemInfo to changedItemInfo
var selectItemDataCommand = connection.CreateCommand();
selectItemDataCommand.CommandText = String.Format("SELECT ItemID, ItemData FROM SyncItems");
using (var reader = selectItemDataCommand.ExecuteReader())
{
while (reader != null && reader.Read())
{
JObject itemData = JObject.Parse((string)reader["ItemData"]);
bool needToUpdate = false;
foreach (var itemRefJson in itemData["item"]["itemRefs"])
{
ISyncableItemInfo referencedItemInfo = SyncUtil.SyncableItemInfoFromJson(itemRefJson);
if (referencedItemInfo.ItemType == remoteItemInfo.ItemType &&
referencedItemInfo.Created.ReplicaId == remoteItemInfo.Created.ReplicaId &&
referencedItemInfo.Created.ReplicaTickCount == remoteItemInfo.Created.ReplicaTickCount &&
referencedItemInfo.Modified.ReplicaId == remoteItemInfo.Modified.ReplicaId &&
referencedItemInfo.Modified.ReplicaTickCount == remoteItemInfo.Modified.ReplicaTickCount
)
{
itemRefJson["creationReplicaID"] = changedItemInfo.Created.ReplicaId;
itemRefJson["creationReplicaTickCount"] = changedItemInfo.Created.ReplicaTickCount;
itemRefJson["modificationReplicaID"] = changedItemInfo.Modified.ReplicaId;
itemRefJson["modificationReplicaTickCount"] = changedItemInfo.Modified.ReplicaTickCount;
needToUpdate = true;
}
}
if (needToUpdate)
{
IDbCommand updateCommand = connection.CreateCommand();
updateCommand.CommandText =
"UPDATE SyncItems SET ItemData=@ItemData, GlobalModifiedReplica=@ModifiedReplica, ModifiedTickCount=@TickCount WHERE ItemID=@ItemID";
updateCommand.AddParameter("@ItemID", reader["ItemID"]);
updateCommand.AddParameter("@ItemData", itemData.ToString());
updateCommand.AddParameter("@TickCount", store.IncrementLocalRepilcaTickCount());
updateCommand.AddParameter("@ModifiedReplica", store.GetLocalReplicaId());
updateCommand.ExecuteNonQuery();
}
}
}
}
public JObject PutItemDataBatch(JObject request)
{
IDbCommand command = _connection.CreateCommand();
command.CommandText = "BEGIN";
command.ExecuteNonQuery();
try
{
var batch = (JArray)request["batch"];
foreach (JToken item in batch)
{
var remoteSyncableItemInfo = SyncUtil.SyncableItemInfoFromJson(item["item"]);
var itemData = new JObject {
{ "item", item["item"] }
};
var remoteKnowledge = SessionDbHelper.LoadRemoteKnowledge(_connection);
var localSyncableItemInfo = _store.LocateCurrentItemInfo(remoteSyncableItemInfo);
var status = SyncUtil.CalculateSyncStatus(remoteSyncableItemInfo, localSyncableItemInfo, remoteKnowledge);
SessionDbHelper.SaveItemData(_connection, remoteSyncableItemInfo, status, itemData);
}
command.CommandText = "COMMIT";
command.ExecuteNonQuery();
}
catch (Exception)
{
command.CommandText = "ROLLBACK";
command.ExecuteNonQuery();
throw;
}
var json = new JObject();
return(json);
}
