private async Task DeleteTableObjectsOfTable(int tableId)
{
var getTableResponse = await TablesController.GetTable(tableId);
if (!getTableResponse.Success)
{
return;
}
foreach (var tableObject in getTableResponse.Data.TableObjects)
{
await TableObjectsController.DeleteTableObject(tableObject.Uuid);
}
}
public async Task SyncPushShouldDeleteTableObjectsOnTheServer()
{
// Arrange
Dav.IsLoggedIn = true;
Dav.AccessToken = Constants.testerXTestAppAccessToken;
var firstTableObjectUuid = Guid.NewGuid();
var firstTableObjectTableId = Constants.testAppFirstTestTableId;
var firstTableObjectFirstPropertyName = "page1";
var firstTableObjectFirstPropertyValue = "Hello World";
var firstTableObjectSecondPropertyName = "page2";
var firstTableObjectSecondPropertyValue = "Hallo Welt";
var secondTableObjectUuid = Guid.NewGuid();
var secondTableObjectTableId = Constants.testAppSecondTestTableId;
var secondTableObjectFirstPropertyName = "test1";
var secondTableObjectFirstPropertyValue = "First test";
var secondTableObjectSecondPropertyName = "test2";
var secondTableObjectSecondPropertyValue = "Second test";
await TableObjectsController.CreateTableObject(
firstTableObjectUuid,
firstTableObjectTableId,
false,
new Dictionary <string, string>
{
{ firstTableObjectFirstPropertyName, firstTableObjectFirstPropertyValue },
{ firstTableObjectSecondPropertyName, firstTableObjectSecondPropertyValue }
}
);
await TableObjectsController.CreateTableObject(
secondTableObjectUuid,
secondTableObjectTableId,
false,
new Dictionary <string, string>
{
{ secondTableObjectFirstPropertyName, secondTableObjectFirstPropertyValue },
{ secondTableObjectSecondPropertyName, secondTableObjectSecondPropertyValue }
}
);
await Dav.Database.CreateTableObjectAsync(new TableObject(
firstTableObjectUuid,
firstTableObjectTableId,
new List <Property>
{
new Property(firstTableObjectFirstPropertyName, firstTableObjectFirstPropertyValue),
new Property(firstTableObjectSecondPropertyName, firstTableObjectSecondPropertyValue)
},
TableObjectUploadStatus.Deleted
));
await Dav.Database.CreateTableObjectWithPropertiesAsync(new TableObject(
secondTableObjectUuid,
secondTableObjectTableId,
new List <Property>
{
new Property(secondTableObjectFirstPropertyName, secondTableObjectFirstPropertyValue),
new Property(secondTableObjectSecondPropertyName, secondTableObjectSecondPropertyValue)
},
TableObjectUploadStatus.Deleted
));
// Act
await SyncManager.SyncPush();
// Assert
var firstTableObjectFromDatabase = await Dav.Database.GetTableObjectAsync(firstTableObjectUuid);
Assert.IsNull(firstTableObjectFromDatabase);
var secondTableObjectFromDatabase = await Dav.Database.GetTableObjectAsync(secondTableObjectUuid);
Assert.IsNull(secondTableObjectFromDatabase);
var firstTableObjectFromServerResponse = await TableObjectsController.GetTableObject(firstTableObjectUuid);
Assert.False(firstTableObjectFromServerResponse.Success);
Assert.AreEqual(404, firstTableObjectFromServerResponse.Status);
Assert.AreEqual(ErrorCodes.TableObjectDoesNotExist, firstTableObjectFromServerResponse.Errors[0].Code);
var secondTableObjectFromServerResponse = await TableObjectsController.GetTableObject(secondTableObjectUuid);
Assert.False(secondTableObjectFromServerResponse.Success);
Assert.AreEqual(404, secondTableObjectFromServerResponse.Status);
Assert.AreEqual(ErrorCodes.TableObjectDoesNotExist, secondTableObjectFromServerResponse.Errors[0].Code);
}
public async Task SyncPushShouldUpdateTableObjectsOnTheServer()
{
// Arrange
Dav.IsLoggedIn = true;
Dav.AccessToken = Constants.testerXTestAppAccessToken;
var firstTableObjectUuid = Guid.NewGuid();
var firstTableObjectTableId = Constants.testAppFirstTestTableId;
var firstTableObjectFirstPropertyName = "page1";
var firstTableObjectFirstPropertyValue = "Hello World";
var firstTableObjectSecondPropertyName = "page2";
var firstTableObjectSecondPropertyValue = "Hallo Welt";
var secondTableObjectUuid = Guid.NewGuid();
var secondTableObjectTableId = Constants.testAppSecondTestTableId;
var secondTableObjectFirstPropertyName = "test1";
var secondTableObjectFirstPropertyValue = "First test";
var secondTableObjectSecondPropertyName = "test2";
var secondTableObjectSecondPropertyValue = "Second test";
await TableObjectsController.CreateTableObject(
firstTableObjectUuid,
firstTableObjectTableId,
false,
new Dictionary <string, string>
{
{ firstTableObjectFirstPropertyName, firstTableObjectFirstPropertyValue },
{ firstTableObjectSecondPropertyName, firstTableObjectSecondPropertyValue }
}
);
await TableObjectsController.CreateTableObject(
secondTableObjectUuid,
secondTableObjectTableId,
false,
new Dictionary <string, string>
{
{ secondTableObjectFirstPropertyName, secondTableObjectFirstPropertyValue },
{ secondTableObjectSecondPropertyName, secondTableObjectSecondPropertyValue }
}
);
var firstTableObjectFirstUpdatedPropertyValue = "First updated value";
var firstTableObjectSecondUpdatedPropertyValue = "Erster aktualisierter Wert";
var secondTableObjectFirstUpdatedPropertyValue = "Second updated value";
var secondTableObjectSecondUpdatedPropertyValue = "Zweiter aktualisierter Wert";
await Dav.Database.CreateTableObjectWithPropertiesAsync(new TableObject(
firstTableObjectUuid,
firstTableObjectTableId,
new List <Property>
{
new Property(firstTableObjectFirstPropertyName, firstTableObjectFirstUpdatedPropertyValue),
new Property(firstTableObjectSecondPropertyName, firstTableObjectSecondUpdatedPropertyValue)
},
TableObjectUploadStatus.Updated
));
await Dav.Database.CreateTableObjectWithPropertiesAsync(new TableObject(
secondTableObjectUuid,
secondTableObjectTableId,
new List <Property>
{
new Property(secondTableObjectFirstPropertyName, secondTableObjectFirstUpdatedPropertyValue),
new Property(secondTableObjectSecondPropertyName, secondTableObjectSecondUpdatedPropertyValue)
},
TableObjectUploadStatus.Updated
));
// Act
await SyncManager.SyncPush();
// Assert
var firstTableObjectFromDatabase = await Dav.Database.GetTableObjectAsync(firstTableObjectUuid);
Assert.IsNotNull(firstTableObjectFromDatabase);
Assert.AreEqual(firstTableObjectUuid, firstTableObjectFromDatabase.Uuid);
Assert.AreEqual(firstTableObjectTableId, firstTableObjectFromDatabase.TableId);
Assert.AreEqual(2, firstTableObjectFromDatabase.Properties.Count);
Assert.AreEqual(firstTableObjectFirstUpdatedPropertyValue, firstTableObjectFromDatabase.GetPropertyValue(firstTableObjectFirstPropertyName));
Assert.AreEqual(firstTableObjectSecondUpdatedPropertyValue, firstTableObjectFromDatabase.GetPropertyValue(firstTableObjectSecondPropertyName));
Assert.AreEqual(TableObjectUploadStatus.UpToDate, firstTableObjectFromDatabase.UploadStatus);
var secondTableObjectFromDatabase = await Dav.Database.GetTableObjectAsync(secondTableObjectUuid);
Assert.IsNotNull(secondTableObjectFromDatabase);
Assert.AreEqual(secondTableObjectUuid, secondTableObjectFromDatabase.Uuid);
Assert.AreEqual(secondTableObjectTableId, secondTableObjectFromDatabase.TableId);
Assert.AreEqual(2, secondTableObjectFromDatabase.Properties.Count);
Assert.AreEqual(secondTableObjectFirstUpdatedPropertyValue, secondTableObjectFromDatabase.GetPropertyValue(secondTableObjectFirstPropertyName));
Assert.AreEqual(secondTableObjectSecondUpdatedPropertyValue, secondTableObjectFromDatabase.GetPropertyValue(secondTableObjectSecondPropertyName));
Assert.AreEqual(TableObjectUploadStatus.UpToDate, secondTableObjectFromDatabase.UploadStatus);
var firstTableObjectFromServerResponse = await TableObjectsController.GetTableObject(firstTableObjectUuid);
Assert.True(firstTableObjectFromServerResponse.Success);
var firstTableObjectFromServer = firstTableObjectFromServerResponse.Data.TableObject;
Assert.AreEqual(firstTableObjectUuid, firstTableObjectFromServer.Uuid);
Assert.AreEqual(firstTableObjectTableId, firstTableObjectFromServer.TableId);
Assert.AreEqual(2, firstTableObjectFromServer.Properties.Count);
Assert.AreEqual(firstTableObjectFirstUpdatedPropertyValue, firstTableObjectFromServer.GetPropertyValue(firstTableObjectFirstPropertyName));
Assert.AreEqual(firstTableObjectSecondUpdatedPropertyValue, firstTableObjectFromServer.GetPropertyValue(firstTableObjectSecondPropertyName));
var secondTableObjectFromServerResponse = await TableObjectsController.GetTableObject(secondTableObjectUuid);
Assert.True(secondTableObjectFromServerResponse.Success);
var secondTableObjectFromServer = secondTableObjectFromServerResponse.Data.TableObject;
Assert.AreEqual(secondTableObjectUuid, secondTableObjectFromServer.Uuid);
Assert.AreEqual(secondTableObjectTableId, secondTableObjectFromServer.TableId);
Assert.AreEqual(2, secondTableObjectFromServer.Properties.Count);
Assert.AreEqual(secondTableObjectFirstUpdatedPropertyValue, secondTableObjectFromServer.GetPropertyValue(secondTableObjectFirstPropertyName));
Assert.AreEqual(secondTableObjectSecondUpdatedPropertyValue, secondTableObjectFromServer.GetPropertyValue(secondTableObjectSecondPropertyName));
}
public async Task SyncShouldRemoveTheTableObjectsThatAreNotOnTheServer()
{
// Arrange
Dav.IsLoggedIn = true;
Dav.AccessToken = Constants.testerXTestAppAccessToken;
var firstTableObjectUuid = Guid.NewGuid();
var firstTableObjectTableId = Constants.testAppFirstTestTableId;
var firstTableObjectFirstPropertyName = "page1";
var firstTableObjectFirstPropertyValue = "Hello World";
var firstTableObjectSecondPropertyName = "page2";
var firstTableObjectSecondPropertyValue = "Hallo Welt";
var secondTableObjectUuid = Guid.NewGuid();
var secondTableObjectTableId = Constants.testAppSecondTestTableId;
var secondTableObjectFirstPropertyName = "test1";
var secondTableObjectFirstPropertyValue = "First test";
var secondTableObjectSecondPropertyName = "test2";
var secondTableObjectSecondPropertyValue = "Second test";
var localTableObjectUuid = Guid.NewGuid();
var localTableObjectTableId = Constants.testAppFirstTestTableId;
var localTableObjectFirstPropertyName = "page1";
var localTableObjectFirstPropertyValue = "Guten Tag";
var localTableObjectSecondPropertyName = "page2";
var localTableObjectSecondPropertyValue = "Good day";
await TableObjectsController.CreateTableObject(
firstTableObjectUuid,
firstTableObjectTableId,
false,
new Dictionary <string, string>
{
{ firstTableObjectFirstPropertyName, firstTableObjectFirstPropertyValue },
{ firstTableObjectSecondPropertyName, firstTableObjectSecondPropertyValue }
}
);
await TableObjectsController.CreateTableObject(
secondTableObjectUuid,
secondTableObjectTableId,
false,
new Dictionary <string, string>
{
{ secondTableObjectFirstPropertyName, secondTableObjectFirstPropertyValue },
{ secondTableObjectSecondPropertyName, secondTableObjectSecondPropertyValue }
}
);
await Dav.Database.CreateTableObjectWithPropertiesAsync(new TableObject(
localTableObjectUuid,
localTableObjectTableId,
new List <Property>
{
new Property(0, localTableObjectFirstPropertyName, localTableObjectFirstPropertyValue),
new Property(0, localTableObjectSecondPropertyName, localTableObjectSecondPropertyValue)
},
TableObjectUploadStatus.UpToDate
));
// Act
await SyncManager.Sync();
// Assert
var allTableObjects = await Dav.Database.GetAllTableObjectsAsync(false);
Assert.AreEqual(2, allTableObjects.Count);
var firstTableObjectFromDatabase = await Dav.Database.GetTableObjectAsync(firstTableObjectUuid);
Assert.IsNotNull(firstTableObjectFromDatabase);
Assert.AreEqual(firstTableObjectUuid, firstTableObjectFromDatabase.Uuid);
Assert.AreEqual(firstTableObjectTableId, firstTableObjectFromDatabase.TableId);
Assert.AreEqual(2, firstTableObjectFromDatabase.Properties.Count);
Assert.AreEqual(firstTableObjectFirstPropertyValue, firstTableObjectFromDatabase.GetPropertyValue(firstTableObjectFirstPropertyName));
Assert.AreEqual(firstTableObjectSecondPropertyValue, firstTableObjectFromDatabase.GetPropertyValue(firstTableObjectSecondPropertyName));
var secondTableObjectFromDatabase = await Dav.Database.GetTableObjectAsync(secondTableObjectUuid);
Assert.IsNotNull(secondTableObjectFromDatabase);
Assert.AreEqual(secondTableObjectUuid, secondTableObjectFromDatabase.Uuid);
Assert.AreEqual(secondTableObjectTableId, secondTableObjectFromDatabase.TableId);
Assert.AreEqual(2, secondTableObjectFromDatabase.Properties.Count);
Assert.AreEqual(secondTableObjectFirstPropertyValue, secondTableObjectFromDatabase.GetPropertyValue(secondTableObjectFirstPropertyName));
Assert.AreEqual(secondTableObjectSecondPropertyValue, secondTableObjectFromDatabase.GetPropertyValue(secondTableObjectSecondPropertyName));
}
public async Task SyncShouldDownloadAllTableObjectsFromTheServerAndUpdateThePropertiesOfExistingTableObjects()
{
// Arrange
Dav.IsLoggedIn = true;
Dav.AccessToken = Constants.testerXTestAppAccessToken;
var firstTableObjectUuid = Guid.NewGuid();
var firstTableObjectTableId = Constants.testAppFirstTestTableId;
var firstTableObjectFirstPropertyName = "page1";
var firstTableObjectFirstPropertyValue = "Hello World";
var firstTableObjectSecondPropertyName = "page2";
var firstTableObjectSecondPropertyValue = "Hallo Welt";
var secondTableObjectUuid = Guid.NewGuid();
var secondTableObjectTableId = Constants.testAppSecondTestTableId;
var secondTableObjectFirstPropertyName = "test1";
var secondTableObjectFirstPropertyValue = "First test";
var secondTableObjectSecondPropertyName = "test2";
var secondTableObjectSecondPropertyValue = "Second test";
await TableObjectsController.CreateTableObject(
firstTableObjectUuid,
firstTableObjectTableId,
false,
new Dictionary <string, string>
{
{ firstTableObjectFirstPropertyName, firstTableObjectFirstPropertyValue },
{ firstTableObjectSecondPropertyName, firstTableObjectSecondPropertyValue }
}
);
await TableObjectsController.CreateTableObject(
secondTableObjectUuid,
secondTableObjectTableId,
false,
new Dictionary <string, string>
{
{ secondTableObjectFirstPropertyName, secondTableObjectFirstPropertyValue },
{ secondTableObjectSecondPropertyName, secondTableObjectSecondPropertyValue }
}
);
// Act (1)
await SyncManager.Sync();
// Assert (1)
var allTableObjects = await Dav.Database.GetAllTableObjectsAsync(false);
Assert.AreEqual(2, allTableObjects.Count);
var firstTableObjectFromDatabase = await Dav.Database.GetTableObjectAsync(firstTableObjectUuid);
Assert.IsNotNull(firstTableObjectFromDatabase);
Assert.AreEqual(firstTableObjectUuid, firstTableObjectFromDatabase.Uuid);
Assert.AreEqual(firstTableObjectTableId, firstTableObjectFromDatabase.TableId);
Assert.AreEqual(2, firstTableObjectFromDatabase.Properties.Count);
Assert.AreEqual(firstTableObjectFirstPropertyValue, firstTableObjectFromDatabase.GetPropertyValue(firstTableObjectFirstPropertyName));
Assert.AreEqual(firstTableObjectSecondPropertyValue, firstTableObjectFromDatabase.GetPropertyValue(firstTableObjectSecondPropertyName));
var secondTableObjectFromDatabase = await Dav.Database.GetTableObjectAsync(secondTableObjectUuid);
Assert.IsNotNull(secondTableObjectFromDatabase);
Assert.AreEqual(secondTableObjectUuid, secondTableObjectFromDatabase.Uuid);
Assert.AreEqual(secondTableObjectTableId, secondTableObjectFromDatabase.TableId);
Assert.AreEqual(2, secondTableObjectFromDatabase.Properties.Count);
Assert.AreEqual(secondTableObjectFirstPropertyValue, secondTableObjectFromDatabase.GetPropertyValue(secondTableObjectFirstPropertyName));
Assert.AreEqual(secondTableObjectSecondPropertyValue, secondTableObjectFromDatabase.GetPropertyValue(secondTableObjectSecondPropertyName));
// Arrange (2)
var firstTableObjectFirstUpdatedPropertyValue = "First updated value";
var firstTableObjectSecondUpdatedPropertyValue = "Erster aktualisierter Wert";
var secondTableObjectFirstUpdatedPropertyValue = "Second updated value";
var secondTableObjectSecondUpdatedPropertyValue = "Zweiter aktualisierter Wert";
await TableObjectsController.UpdateTableObject(
firstTableObjectUuid,
new Dictionary <string, string>
{
{ firstTableObjectFirstPropertyName, firstTableObjectFirstUpdatedPropertyValue },
{ firstTableObjectSecondPropertyName, firstTableObjectSecondUpdatedPropertyValue }
}
);
await TableObjectsController.UpdateTableObject(
secondTableObjectUuid,
new Dictionary <string, string>
{
{ secondTableObjectFirstPropertyName, secondTableObjectFirstUpdatedPropertyValue },
{ secondTableObjectSecondPropertyName, secondTableObjectSecondUpdatedPropertyValue }
}
);
// Act (2)
await SyncManager.Sync();
// Assert (2)
allTableObjects = await Dav.Database.GetAllTableObjectsAsync(false);
Assert.AreEqual(2, allTableObjects.Count);
firstTableObjectFromDatabase = await Dav.Database.GetTableObjectAsync(firstTableObjectUuid);
Assert.IsNotNull(firstTableObjectFromDatabase);
Assert.AreEqual(firstTableObjectUuid, firstTableObjectFromDatabase.Uuid);
Assert.AreEqual(firstTableObjectTableId, firstTableObjectFromDatabase.TableId);
Assert.AreEqual(2, firstTableObjectFromDatabase.Properties.Count);
Assert.AreEqual(firstTableObjectFirstUpdatedPropertyValue, firstTableObjectFromDatabase.GetPropertyValue(firstTableObjectFirstPropertyName));
Assert.AreEqual(firstTableObjectSecondUpdatedPropertyValue, firstTableObjectFromDatabase.GetPropertyValue(firstTableObjectSecondPropertyName));
secondTableObjectFromDatabase = await Dav.Database.GetTableObjectAsync(secondTableObjectUuid);
Assert.IsNotNull(secondTableObjectFromDatabase);
Assert.AreEqual(secondTableObjectUuid, secondTableObjectFromDatabase.Uuid);
Assert.AreEqual(secondTableObjectTableId, secondTableObjectFromDatabase.TableId);
Assert.AreEqual(2, secondTableObjectFromDatabase.Properties.Count);
Assert.AreEqual(secondTableObjectFirstUpdatedPropertyValue, secondTableObjectFromDatabase.GetPropertyValue(secondTableObjectFirstPropertyName));
Assert.AreEqual(secondTableObjectSecondUpdatedPropertyValue, secondTableObjectFromDatabase.GetPropertyValue(secondTableObjectSecondPropertyName));
}
