public async Task TestCRUD()
{
// Arrange
var item = new Country
{
Name = "United States of America",
ISOCode = "USA"
};
/****** INSERT *******/
// Act
var insertedId = await _dataModel.InsertAsync(item).ConfigureAwait(true);
// Assert
var insertedItem = await _dataModel.FindAsync(insertedId).ConfigureAwait(true);
Assert.AreEqual(item.Name, insertedItem.Name);
Assert.AreEqual(item.ISOCode, insertedItem.ISOCode);
/****** UPDATE *******/
// Act
insertedItem.Name = "testName_1";
var result = await _dataModel.UpdateAsync(insertedItem).ConfigureAwait(true);
// Assert
item = await _dataModel.FindAsync(insertedItem.Id).ConfigureAwait(true);
Assert.AreEqual(1, result);
Assert.AreEqual(item.Name, "testName_1");
Assert.AreEqual(item.ISOCode, insertedItem.ISOCode);
/****** DELETE *******/
// Act
await _dataModel.DeleteAsync(insertedItem.Id).ConfigureAwait(true);
// Assert
var items = await _dataModel.FindAllAsync().ConfigureAwait(true);
Assert.AreEqual(0, items.Count);
}
public async Task TestCRUDWithCountriesTable()
{
// Arrange
var countryITA = new Country {
Name = "Italy", ISOCode = "ITA"
};
// to get autoincrement id
await _countriesDataModel.InsertAsync(countryITA);
countryITA = (await _countriesDataModel.FindAllAsync()).First();
var item = new Contact
{
Name = "testName",
Surname = "testSurname",
PhoneNumber = "123124",
Country = countryITA
};
/****** INSERT *******/
// Act
var insertedId = await _dataModel.InsertAsync(item).ConfigureAwait(true);
// Assert
var insertedItem = await _dataModel.FindAsync(insertedId).ConfigureAwait(true);
Assert.AreEqual(item.Name, insertedItem.Name);
Assert.AreEqual(item.Surname, insertedItem.Surname);
Assert.AreEqual(item.PhoneNumber, insertedItem.PhoneNumber);
Assert.AreEqual(item.Country, insertedItem.Country);
///****** UPDATE *******/
// Act
await _countriesDataModel.InsertAsync(new Country { Name = "United States of America", ISOCode = "USA" });
var countryUSA = (await _countriesDataModel.FindAllAsync()).First(x => x.ISOCode.Equals("USA"));
insertedItem.Name = "testName_1";
insertedItem.Country = countryUSA;
var result = await _dataModel.UpdateAsync(insertedItem).ConfigureAwait(true);
// Assert
item = await _dataModel.FindAsync(insertedItem.Id).ConfigureAwait(true);
Assert.AreEqual(1, result);
Assert.AreEqual(item.Name, "testName_1");
Assert.AreEqual(item.Surname, insertedItem.Surname);
Assert.AreEqual(item.Country, insertedItem.Country);
Assert.AreEqual(item.PhoneNumber, insertedItem.PhoneNumber);
/****** DELETE *******/
// Act
await _dataModel.DeleteAsync(insertedItem.Id).ConfigureAwait(true);
// Assert
var items = await _dataModel.FindAllAsync().ConfigureAwait(true);
Assert.AreEqual(0, items.Count);
}
