public static void CompareFiles_ReturnsExpectedResults() { var result = Comparer.CompareFiles( "TestFiles\\Microservice-Healthwise-DevBranch-CI-2.json", "TestFiles\\Microservice-Healthwise-DevBranch-CI-1.json" ); Assert.That(result, Is.Not.Null); }
public void SelectCustomersFromLondon_ShouldPass() { const string origFile = _path + "CustomersExpected.csv"; const string outFile = _path + "CustomersActual.csv"; const string query = "select CustomerID, CompanyName, ContactName, ContactTitle, City, Region, PostalCode, Country " + "from Customers where City != 'London' order by ContactTitle"; SQLServerProvider.ExecuteReaderQuery(query, _connectionString, outFile, "CustomerID", "CompanyName", "ContactName", "ContactTitle", "City", "Region", "PostalCode", "Country"); Assert.True(Comparer.CompareFiles(origFile, outFile)); }
public void SelectSuppliersWithIdLessThan25_ShouldFail() { const string origFile = _path + "SuppliersExpected.csv"; const string outFile = _path + "SuppliersActual.csv"; const string query = "select SupplierID, ContactName, ContactTitle, City, Address, PostalCode, Country, Phone " + "from Suppliers where SupplierID < 25 " + "group by ContactTitle, SupplierID, CompanyName, ContactName, City, PostalCode, Country, Phone, Address"; SQLServerProvider.ExecuteReaderQuery(query, _connectionString, outFile, "SupplierID", "ContactName", "ContactTitle", "City", "Address", "PostalCode", "Country", "Phone"); Assert.True(Comparer.CompareFiles(origFile, outFile)); }
public void InsertDataToSuppliers_ShouldPass() { const string origFile = _path + "SuppliersInsert.csv"; const string outFile = _path + "SuppliersActual.csv"; const string query = "insert into Suppliers (CompanyName, ContactName, ContactTitle, City, Address, PostalCode, Country, Phone) " + "values ('Heli Süßwaren GmbH & Co. KG', 'Sarah Rafferty', 'CTO', 'Berlin', 'Kaloadagatan 13', 'M14 SD', 'Germany', '(010) 9984510')"; const string selectStatement = "select SupplierID, ContactName, ContactTitle, City, PostalCode, Country, Phone from Suppliers"; SQLServerProvider.ExecuteManipulativeQuery(query, _connectionString); SQLServerProvider.ExecuteReaderQuery(selectStatement, _connectionString, outFile, "SupplierID", "ContactName", "ContactTitle", "City", "PostalCode", "Country", "Phone"); Assert.False(Comparer.CompareFiles(origFile, outFile)); }