Appending 2 xml test results

monalisha · 2020-05-18T09:01:21.000Z

Hi ,

I have 2 xmls and it has the test results in it. So i want a final xml which captures the test1.xml and test2.xml. Below are my xmls

$parentString = @"

"@

$childString = @"

"@

and Final XML should look like this

I tried this below code but i am not able to sum up the tests and totaltime …Please help!!!

$parent = [xml] (Get-Content ‘.\Result.xml’)
$parentnode = $parent.testsuite.testcase
$child = [xml] (Get-Content ‘.\Results.xml’)
$xpath = ‘testsuite/testcase’
$childnode = $child.SelectSingleNode($xpath)
Write-Host(“So the child is $($childnode.OuterXML)”)
$importedNode = $parent.ImportNode($childNode,$true)
Write-Host(“And after importing: $($importedNode.OuterXML)”)
$parentnode.InsertAfter($importednode, $parentnode.LastChild)
Write-Host(“To finally yield: $($parent.OuterXML)”)
$parent.Save(“.\Final.xml”)

Neally · 2020-05-18T13:03:58.000Z

If you post code, please use the ‘Insert Code’ button. Please and thank you!

PLEASE READ BEFORE POSTING! Read if you're new to the PowerShell forum! Programming & Development

Hi, and welcome to the PowerShell forum! Don’t apologize for being a “noob” or “newbie” or “n00b.” There’s just no need – nobody will think you’re stupid, and the forums are all about asking questions. Just ask! Use a descriptive subject. Don’t say “Need help” or “PowerShell Help”, actually summarize what the problem is. It helps the rest of us keep track of which problem is which. Don’t post massive scripts. We’re all volunteers and we don’t have time to read all that, nor will we copy…

monalisha · 2020-05-18T14:21:33.000Z

$parentString = @"
<testsuite name="Norma_Batch" file="Norma_Batch" tests="1" failures="0" time="45.79">
  <testcase classname="Norma_Batch" name="D:\Jenkins\jobs\Batch_QA_Norma_Daily\workspaceDev\o9Tests\o9MpowerTests\SSIS\Norma\01_Checksum Before Batch" time="45.79">
  </testcase>
</testsuite>

"@

$childString = @"
<testsuite name="Norma_Batch" file="Norma_Batch" tests="1" failures="0" time="45.79">
  <testcase classname="Norma_Batch" name="D:\Jenkins\jobs\Batch_QA_Norma_Daily\workspaceDev\o9Tests\o9MpowerTests\SSIS\Norma\02_Checksum After Batch" time="45.30">
  </testcase>
</testsuite>

"@

$parent = [xml] (Get-Content '.\Result.xml')
$parentnode = $parent.testsuite.testcase
$child = [xml] (Get-Content '.\Results.xml')
$xpath = 'testsuite/testcase'
$childnode = $child.SelectSingleNode($xpath)
--Write-Host("So the child is $($childnode.OuterXML)")
$importedNode = $parent.ImportNode($childNode,$true)
--Write-Host("And after importing: $($importedNode.OuterXML)")
$parentnode.InsertAfter($importednode, $parentnode.LastChild)
--Write-Host("To finally yield: $($parent.OuterXML)")
$parent.Save(".\Final.xml")

Neally · 2020-05-18T15:41:01.000Z

ok so the final.xml you have is not correct or where is the issue?

the idea looks right, read both in, then drill down to get the value?

monalisha · 2020-05-18T15:50:24.000Z

In the final.xml, the testsuite -time and tests is not updating .Ideally it shld sum up both the test time and total no.of. Test in the testsuite. @Neally

Neally · 2020-05-18T16:07:34.000Z

Monalisha:

In the final.xml, the testsuite -time and tests is not updating .Ideally it shld sum up both the test time and total no.of. Test in the testsuite. @Neally

and there are always only 2 ? parent and child?

Neally · 2020-05-18T16:15:29.000Z

something like so?
or do you need it more dynamic?

$parentString = @"
<testsuite name="Norma_Batch" file="Norma_Batch" tests="1" failures="0" time="45.79">
  <testcase classname="Norma_Batch" name="D:\Jenkins\jobs\Batch_QA_Norma_Daily\workspaceDev\o9Tests\o9MpowerTests\SSIS\Norma\01_Checksum Before Batch" time="45.79">
  </testcase>
</testsuite>
"@

$childString = @"
<testsuite name="Norma_Batch" file="Norma_Batch" tests="1" failures="0" time="45.79">
  <testcase classname="Norma_Batch" name="D:\Jenkins\jobs\Batch_QA_Norma_Daily\workspaceDev\o9Tests\o9MpowerTests\SSIS\Norma\02_Checksum After Batch" time="45.30">
  </testcase>
</testsuite>
"@

$parent = [xml] $parentString
$child  = [xml] $childString

#region - Variables
$tests    = [int]$parent.testsuite.tests + [int]$child.testsuite.tests
$failures = [int]$parent.testsuite.failures + [int]$child.testsuite.failures
$time     = [math]::round([float]$parent.testsuite.time + [float]$child.testsuite.time,2)

#endregion - Variables

$final =
@"
<testsuite name="Norma_Batch" file="Norma_Batch" tests="$tests" failures="$failures" time="$time"> 
<testcase classname="Norma_Batch" name="D:\Jenkins\jobs\Batch_QA_Norma_Daily\workspaceDev\Tests\MpowerTests\SSIS\Norma\01_Checksum Before Batch" time="45.79"> </testcase>
<testcase classname="Norma_Batch" name="D:\Jenkins\jobs\Batch_QA_Norma_Daily\workspaceDev\Tests\MpowerTests\SSIS\Norma\02_Checksum After Batch" time="45.30"> </testcase>
</testsuite>
"@

$finalxml = [xml]$final
$finalxml.testsuite

monalisha · 2020-05-19T01:38:36.000Z

@alexw Yahhh I have just provided an example and I need more dynamic so that if at all i keep on adding more and more tests main header gives me a summary.

As in the current code which you shared, over there $final is harcoded .The inside tests time will vary everytime…

Thanks in advance!!!

Neally · 2020-05-19T03:56:55.000Z

Well look at the example I gave you and see if you get it dynamic. You can tell it to take the parent and child value. Post what you’ve tried and we’ll try to help.

monalisha · 2020-05-19T06:32:31.000Z

Hey @alexw I tried just the way you said and it worked and now its working absolutely perfect…

Thanks a lott!!!..