public void DeleteFileByWildCardTest() { var step = new CreateStep(); step.CreationPath = @"..\..\TestData\DeleteTest_FileToBeDeleted1.wildCardTestxml"; var dl = new FileDataLoader(); dl.FilePath = @"..\..\TestData\PurchaseOrder001.xml"; step.DataSource = dl; step.Execute(new Context()); step.CreationPath = @"..\..\TestData\DeleteTest_FileToBeDeleted2.wildCardTestxml"; step.Execute(new Context()); var deleteStep = new DeleteStep(); deleteStep.FilePathsToDelete.Add(@"..\..\TestData\*.wildCardTestxml"); deleteStep.Execute(new Context()); try { var deletedFile = System.IO.File.Open(@"..\..\TestData\DeleteTest_FileToBeDeleted.wildCardTestxml", FileMode.Open, FileAccess.Read); } catch (System.IO.FileNotFoundException) { ; // Expected! } }
public void DeleteFileTest() { var step = new CreateStep { CreationPath = @"..\..\..\..\Test\BizUnit.TestSteps.Tests\TestData\DeleteTest_FileToBeDeleted.xml" }; var dl = new FileDataLoader { FilePath = @"..\..\..\..\Test\BizUnit.TestSteps.Tests\TestData\PurchaseOrder001.xml" }; step.DataSource = dl; step.Execute(new Context()); var deleteStep = new DeleteStep(); deleteStep.FilePathsToDelete.Add( @"..\..\..\..\Test\BizUnit.TestSteps.Tests\TestData\DeleteTest_FileToBeDeleted.xml"); deleteStep.Execute(new Context()); try { var deletedFile = System.IO.File.Open( @"..\..\..\..\Test\BizUnit.TestSteps.Tests\TestData\DeleteTest_FileToBeDeleted.xml", FileMode.Open, FileAccess.Read); } catch (FileNotFoundException) { // Expected! } }
public void DeleteFileTest() { var step = new CreateStep(); step.CreationPath = Path.Combine(TestContext.CurrentContext.TestDirectory, @"TestData\DeleteTest_FileToBeDeleted.xml"); var dl = new FileDataLoader(); dl.FilePath = Path.Combine(TestContext.CurrentContext.TestDirectory, @"TestData\PurchaseOrder001.xml"); step.DataSource = dl; step.Execute(new Context()); var deleteStep = new DeleteStep(); deleteStep.FilePathsToDelete.Add(Path.Combine(TestContext.CurrentContext.TestDirectory, @"TestData\DeleteTest_FileToBeDeleted.xml")); deleteStep.Execute(new Context()); try { var deletedFile = System.IO.File.Open(Path.Combine(TestContext.CurrentContext.TestDirectory, @"TestData\DeleteTest_FileToBeDeleted.xml"), FileMode.Open, FileAccess.Read); } catch (System.IO.FileNotFoundException) { ; // Expected! } }
private List <IPlanStep> GetDeleteSteps(DeleteStatement statement) { var result = new List <IPlanStep>(); var step = new DeleteStep(); step.DatabaseName = statement.DatabaseName; step.TableName = statement.Tables.First(); if (statement.HasWhereClause) { // need to delete only the rows in the where clause step.InputStep = QueryPlanGeneratorUtility.GetMaxStep(_plan.Steps); step.Level = step.InputStep.Level++; var rows = step.InputStep.GetResult(_process, statement.DatabaseName).Rows; step.DeletedRows = rows; } else { // delete everything step.ShouldDeleteAllRows = true; } result.Add(step); return(result); }
public void SampleTestCase() { var sourceDirectory = Path.Combine(TestContext.CurrentContext.TestDirectory, "TestData"); var sourceFilePath = Path.Combine(sourceDirectory, "PurchaseOrder001.xml"); var targetDirectory = Path.Combine(TestContext.CurrentContext.TestDirectory, "TestArea"); var targetFilePath = Path.Combine(targetDirectory, "FileCreateStepTest.xml"); var fds = new DeleteStep(); fds.FilePathsToDelete.Add(targetFilePath); var fcs = new CreateStep(); fcs.CreationPath = targetFilePath; var dl = new FileDataLoader(); dl.FilePath = sourceFilePath; fcs.DataSource = dl; var frs = new FileReadStep(); frs.DirectoryPath = targetDirectory; frs.SearchPattern = "*.xml"; frs.Timeout = 3000; frs.DeleteFile = true; var tc = new TestCase(); tc.SetupSteps.Add(fds); tc.ExecutionSteps.Add(fcs); tc.ExecutionSteps.Add(frs); tc.CleanupSteps.Add(fds); var testRunner = new TestRunner(tc); testRunner.Run(); TestCase.SaveToFile( tc, Path.Combine( TestContext.CurrentContext.TestDirectory, @"..\..\", "TestCases", "SampleTest.xaml"), true); }
public void Upgrade_Eligible_Test_FILE() { var testCase = new TestCase(); testCase.Name = "Upgrade_Eligible_Test_FILE"; testCase.Purpose = "Test successful upgrade"; testCase.Description = "Test upgrade succeeds for passenger/flight eligible for upgrade"; testCase.Category = "BizUnit SDK: BVT"; testCase.Reference = "Use case: 10.3.4"; testCase.ExpectedResults = "Upgrade succeeds"; testCase.Preconditions = "Solution should be deployed, bound and started"; // First ensure the target directory is empty... var delFiles = new DeleteStep(); delFiles.FilePathsToDelete = new Collection <string> { @"C:\Temp\BizTalk\BizUnitSdkOut\*.xml" }; testCase.SetupSteps.Add(delFiles); // Then execute the main scenario. var testStep = new CreateStep(); // Where are we going to create the file. testStep.CreationPath = @"C:\Temp\BizTalk\BizUnitSdkIn\Request.xml"; var dataLoader = new FileDataLoader(); // Where are we getting the original file from? dataLoader.FilePath = @"..\..\Data\Request.xml"; testStep.DataSource = dataLoader; testCase.ExecutionSteps.Add(testStep); // Add validation.... var validation = new XmlValidationStep(); var schemaResultType = new SchemaDefinition { XmlSchemaPath = @"..\..\..\..\Src\FlightUpgrade\ResponseMsg.xsd", XmlSchemaNameSpace = "http://bizUnit.sdk.flightUpgrade/upgradeResponse" }; validation.XmlSchemas.Add(schemaResultType); var responseXpath = new XPathDefinition(); responseXpath.Description = "GetProducts_RS/Result/result"; responseXpath.XPath = "/*[local-name()='UpgradeResponse' and namespace-uri()='http://bizUnit.sdk.flightUpgrade/upgradeResponse']/*[local-name()='UpgradeResult' and namespace-uri()='']/*[local-name()='Result' and namespace-uri()='']"; responseXpath.Value = "true"; validation.XPathValidations.Add(responseXpath); // Check that an output file has been created. var finalFileReadStep = new FileReadMultipleStep(); finalFileReadStep.DirectoryPath = @"C:\Temp\BizTalk\BizUnitSdkOut"; finalFileReadStep.SearchPattern = "*.xml"; finalFileReadStep.ExpectedNumberOfFiles = 1; finalFileReadStep.Timeout = 5000; finalFileReadStep.DeleteFiles = false; finalFileReadStep.SubSteps.Add(validation); testCase.ExecutionSteps.Add(finalFileReadStep); var bizUnit = new BizUnit(testCase); bizUnit.RunTest(); TestCase.SaveToFile(testCase, System.String.Format("Upgrade_Eligible_Test_File_{0}.xml", System.String.Format("{0:yyyy-MM-dd-hh_mm_ss}", System.DateTime.Now))); }
public void Upgrade_Elligable_Test() { var testCase = new TestCase(); testCase.Name = "Upgrade_Elligable_Test"; testCase.Purpose = "Test successful upgrade"; testCase.Description = "Test upgrade succeeds for passenger/flight not elligable for upgrade"; testCase.Category = "BizUnit SDK: BVT"; testCase.Reference = "Use case: 10.3.4"; testCase.ExpectedResults = "Upgrade succeeds"; testCase.Preconditions = "Solution should be deployed, bound and started"; // First ensure the target directory is empty... var delFiles = new DeleteStep(); delFiles.FilePathsToDelete = new Collection <string> { @"C:\Temp\BizTalk\BizUnitSdkOut\*.xml" }; testCase.SetupSteps.Add(delFiles); // Then execute the main scenario, execute a response-response web set step which is executed concurrently. // i.e. whilst this step is waiting for the response the next step, FileReadMultipleStep and then CreateStep // will be executed. var wsStep = new WebServiceStep(); wsStep.Action = "Upgrade"; wsStep.ServiceUrl = "http://localhost/BizUnit.Sdk.FlightUpgrade/BizUnit_Sdk_FlightUpgrade_ProcessRequest_UpgradePort.svc"; wsStep.RequestBody = new FileDataLoader { FilePath = @"..\..\..\Tests\FlightUpgrade.Tests\Data\Request.xml" }; wsStep.RunConcurrently = true; // Add validation.... var validation = new XmlValidationStep(); var schemaResultType = new SchemaDefinition { XmlSchemaPath = @"..\..\..\Src\FlightUpgrade\ResponseMsg.xsd", XmlSchemaNameSpace = "http://bizUnit.sdk.flightUpgrade/upgradeResponse" }; validation.XmlSchemas.Add(schemaResultType); var responseXpath = new XPathDefinition(); responseXpath.Description = "GetProducts_RS/Result/result"; responseXpath.XPath = "/*[local-name()='UpgradeResponse' and namespace-uri()='http://bizUnit.sdk.flightUpgrade/upgradeResponse']/*[local-name()='UpgradeResult' and namespace-uri()='']/*[local-name()='Result' and namespace-uri()='']"; responseXpath.Value = "true"; validation.XPathValidations.Add(responseXpath); var fileReadStep = new FileReadMultipleStep(); fileReadStep.DirectoryPath = @"C:\Temp\BizTalk\BizUnitSdkOut"; fileReadStep.SearchPattern = "*.xml"; fileReadStep.ExpectedNumberOfFiles = 1; fileReadStep.Timeout = 5000; fileReadStep.DeleteFiles = true; var createFileStep = new CreateStep(); createFileStep.CreationPath = @"..\..\..\Data\In\UpgradeResponse.xml"; createFileStep.DataSource = new FileDataLoader { FilePath = @"..\..\..\Tests\FlightUpgrade.Tests\Data\Response.xml" }; testCase.ExecutionSteps.Add(wsStep); testCase.ExecutionSteps.Add(fileReadStep); testCase.ExecutionSteps.Add(createFileStep); var bizUnit = new BizUnit(testCase); bizUnit.RunTest(); TestCase.SaveToFile(testCase, "Upgrade_Elligable_Test.xml"); }
public void Integration_Test() { #region Variable Intialization var sourceFilePath = @"C:\Users\amigupta7\Desktop\Amit\Project\POC\Timewave.BizUnit.Sample\Testing\OrderSample.xml"; var targetFilePath = @"C:\Users\amigupta7\Desktop\Amit\Project\POC\Timewave.BizUnit.Sample\Testing\Order\OrderSample.xml"; var DestinationDirSummary = @"C:\Users\amigupta7\Desktop\Amit\Project\POC\Timewave.BizUnit.Sample\Testing\Summary"; #endregion #region Initial CleanUp Step //Get rid of any files that are already there var deleteStep = new DeleteStep(); deleteStep.FilePathsToDelete.Add(targetFilePath); #endregion #region Create step //Create the test step var createStep = new CreateStep(); createStep.CreationPath = targetFilePath; //Where are we going to create the file var dataLoader = new FileDataLoader(); //Where are we getting the file from? dataLoader.FilePath = sourceFilePath; createStep.DataSource = dataLoader; #endregion #region Execution steps #region File Validation Step //Create a validating read step //We should only have one file in the directory var ValidateFileStep = new FileReadMultipleStep(); ValidateFileStep.DirectoryPath = DestinationDirSummary; ValidateFileStep.SearchPattern = "*.xml"; ValidateFileStep.Timeout = 60000; ValidateFileStep.ExpectedNumberOfFiles = 1; ValidateFileStep.DeleteFiles = true; #endregion #region #SubSteps - Schema and node value Validation Step //Create an XML Validation step //This will check the result against the XSD for the document var summarySchemaValidationStep = new XmlValidationStep(); var schemaSummary = new SchemaDefinition(); schemaSummary.XmlSchemaPath = @"C:\Users\amigupta7\Desktop\Amit\Project\POC\Timewave.BizUnit.Sample\Timewave.BizUnit.Sample\Timewave.BizUnit.Sample\Schemas\SummarySchema.xsd"; schemaSummary.XmlSchemaNameSpace = "http://Timewave.BizTalkUnit.Sample.DestinationSchema"; summarySchemaValidationStep.XmlSchemas.Add(schemaSummary); //Create an XPath Validation. This will check a value in the output. //The Xpath for the node can be grabbed from the Instance XPath property on the XSD. var xpathProductId = new XPathDefinition(); xpathProductId.Description = "ItemsOrdered"; xpathProductId.XPath = "/*[local-name()='CustomerSummary' and namespace-uri()='http://Timewave.BizTalkUnit.Sample.DestinationSchema']/*[local-name()='ItemsOrdered' and namespace-uri()='']"; xpathProductId.Value = "1"; summarySchemaValidationStep.XPathValidations.Add(xpathProductId); ValidateFileStep.SubSteps.Add(summarySchemaValidationStep); #endregion #endregion #region Test Case Execution var testCase = new TestCase(); testCase.SetupSteps.Add(deleteStep); testCase.ExecutionSteps.Add(createStep); testCase.ExecutionSteps.Add(ValidateFileStep); testCase.CleanupSteps.Add(deleteStep); var testRunner = new TestRunner(testCase); testRunner.Run(); #endregion }
public void SummaryTest() { //var totalItemsTest = new TestCase { Name = "Total Items is 3" }; var sourceFilePath = @"C:\Users\amigupta7\Desktop\Amit\Project\POC\Timewave.BizUnit.Sample\Testing\OrderSample.xml"; //var targetDirectory = @"C:\Users\amigupta7\Desktop\Amit\Project\POC\Timewave.BizUnit.Sample\Testing\Order"; var targetFilePath = @"C:\Users\amigupta7\Desktop\Amit\Project\POC\Timewave.BizUnit.Sample\Testing\Order\OrderSample.xml"; var DestinationDirSummary = @"C:\Users\amigupta7\Desktop\Amit\Project\POC\Timewave.BizUnit.Sample\Testing\Summary"; //Get rid of any files that are already there var deleteStep = new DeleteStep(); deleteStep.FilePathsToDelete.Add(targetFilePath); //Create the test step var createStep = new CreateStep(); createStep.CreationPath = targetFilePath; //Where are we going to create the file var dataLoader = new FileDataLoader(); //Where are we getting the file from? dataLoader.FilePath = sourceFilePath; createStep.DataSource = dataLoader; //Create a validating read step //We should only have one file in the directory var ValidateFileStep = new FileReadMultipleStep(); ValidateFileStep.DirectoryPath = DestinationDirSummary; ValidateFileStep.SearchPattern = "*.xml"; ValidateFileStep.Timeout = 3000; ValidateFileStep.ExpectedNumberOfFiles = 1; ValidateFileStep.DeleteFiles = true; //Create an XML Validation step //This will check the result against the XSD for the document var summarySchemaValidationStep = new XmlValidationStep(); var schemaSummary = new SchemaDefinition(); schemaSummary.XmlSchemaPath = @"C:\Users\amigupta7\Desktop\Amit\Project\POC\Timewave.BizUnit.Sample\Timewave.BizUnit.Sample\Timewave.BizUnit.Sample\Schemas\SummarySchema.xsd"; schemaSummary.XmlSchemaNameSpace = "http://Timewave.BizTalkUnit.Sample.DestinationSchema"; summarySchemaValidationStep.XmlSchemas.Add(schemaSummary); //Create an XPath Validation. This will check a value in the output. //The Xpath for the node can be grabbed from the Instance XPath property on the XSD. var xpathProductId = new XPathDefinition(); xpathProductId.Description = "ItemsOrdered"; xpathProductId.XPath = "/*[local-name()='CustomerSummary' and namespace-uri()='http://Timewave.BizTalkUnit.Sample.DestinationSchema']/*[local-name()='ItemsOrdered' and namespace-uri()='']"; xpathProductId.Value = "2"; summarySchemaValidationStep.XPathValidations.Add(xpathProductId); ValidateFileStep.SubSteps.Add(summarySchemaValidationStep); var testCase = new TestCase(); testCase.SetupSteps.Add(deleteStep); testCase.ExecutionSteps.Add(createStep); testCase.ExecutionSteps.Add(ValidateFileStep); testCase.CleanupSteps.Add(deleteStep); var testRunner = new TestRunner(testCase); try { testRunner.Run(); } catch (Exception ex) { string filePath = @"C:\Users\amigupta7\Desktop\Amit\Project\POC\Timewave.BizUnit.Sample\TestResult\Error.txt"; using (StreamWriter writer = new StreamWriter(filePath, true)) { writer.WriteLine("-----------------------------------------------------------------------------"); writer.WriteLine("Date : " + DateTime.Now.ToString()); writer.WriteLine(); while (ex != null) { writer.WriteLine(ex.GetType().FullName); writer.WriteLine("Message : " + ex.Message); writer.WriteLine("StackTrace : " + ex.StackTrace); ex = ex.InnerException; } } } finally { TestCase.SaveToFile( testCase, @"C:\Users\amigupta7\Desktop\Amit\Project\POC\Timewave.BizUnit.Sample\TestResult\SampleTest.xaml", true); } }