public void Test4()
{
var indexToUpdate = "1";
var elementToUpdate = new DbModel("NewCustomerName", "NewContactName", "NewAddress", "NewCity", "NewPostalCode", "NewCountry");
elementToUpdate.AddProperty("CustomerID", indexToUpdate);
executeSQL("UPDATE Customers "
+ "SET CustomerName = '" + elementToUpdate.CustomerName
+ "', ContactName = '" + elementToUpdate.ContactName
+ "', Address = '" + elementToUpdate.Address
+ "', City = '" + elementToUpdate.City
+ "', PostalCode = '" + elementToUpdate.PostalCode
+ "', Country = '" + elementToUpdate.Country
+ "' WHERE CustomerId = " + indexToUpdate);
waitDbUpdateFinished();
executeSQL("SELECT * FROM Customers WHERE CustomerID = " + indexToUpdate);
var updatedRecord = getSqlResult()[0];
Assert.AreEqual(elementToUpdate, updatedRecord);
}
public void Test3()
{
var elementToInsert = new DbModel("NewCustomerName", "NewContactName", "NewAddress", "NewCity", "NewPostalCode", "NewCountry");
// get number of records before INSERT
executeSQL("SELECT * FROM Customers");
var recordsNumberBefore = getSqlResultCount();
insertRecordToDb(elementToInsert);
// get number of records after INSERT
executeSQL("SELECT * FROM Customers");
var recordsNumberAfter = getSqlResultCount();
Assert.AreEqual(recordsNumberBefore + 1, recordsNumberAfter);
executeSQL("SELECT * FROM Customers WHERE CustomerID = " + recordsNumberAfter.ToString());
var insertedRecord = getSqlResult()[0];
elementToInsert.AddProperty("CustomerID", recordsNumberAfter.ToString());
Assert.AreEqual(elementToInsert, insertedRecord);
}
