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); }