Forum Discussion

keanesean's avatar
keanesean
Occasional Contributor
11 years ago

Sorting XML response before assertion

Hi,    I have a web service response that I want to compare to a JDBC response. I can modify the SQL query to ensure the JDBC response is sorted, but the web service response is not sorted alphabet...
nmrao's avatar
nmrao
Community Hero
11 years ago
Hmm., it may really depends on what data exactly you wanted to compare from jdbc response.

For example, you get AccountServices is a list. So you can get the AccountServices if ServiceCode is GTEL and get the same data from jdbc and then compare. Then loop thru the AccountServices, that should solve the issue unless you want to compare both of the entire xmls.
kondasamy's avatar
kondasamy
Regular Contributor
11 years ago

Additional option using code  -  here is a Groovy snippet which sorts the XML nodes based on our need using XmlSlurper which sorts the <book> nodes using its 'id' attribute,

 

import groovy.xml.MarkupBuilder

String xml = '''
				<catalog>
				   <book id="bk101">
					  <author>Gambardella, Matthew</author>
					  <title>XML Developer's Guide</title>
					  <genre>Computer</genre>
					  <price>44.95</price>
					  <publish_date>2000-10-01</publish_date>
					  <description>An in-depth look at creating applications 
					  with XML.</description>
				   </book>
				   <book id="bk119">
					  <author>Ralls, Kim</author>
					  <title>Midnight Rain</title>
					  <genre>Fantasy</genre>
					  <price>5.95</price>
					  <publish_date>2000-12-16</publish_date>
					  <description>A former architect battles corporate zombies, 
					  an evil sorceress, and her own childhood to become queen 
					  of the world.</description>
				   </book>
				   <book id="bk103">
					  <author>Corets, Eva</author>
					  <title>Maeve Ascendant</title>
					  <genre>Fantasy</genre>
					  <price>5.95</price>
					  <publish_date>2000-11-17</publish_date>
					  <description>After the collapse of a nanotechnology 
					  society in England, the young survivors lay the 
					  foundation for a new society.</description>
				   </book>
				   <book id="bk104">
					  <author>Corets, Eva</author>
					  <title>Oberon's Legacy</title>
					  <genre>Fantasy</genre>
					  <price>5.95</price>
					  <publish_date>2001-03-10</publish_date>
					  <description>In post-apocalypse England, the mysterious 
					  agent known only as Oberon helps to create a new life 
					  for the inhabitants of London. Sequel to Maeve 
					  Ascendant.</description>
				   </book>
				   <book id="bk105">
					  <author>Corets, Eva</author>
					  <title>The Sundered Grail</title>
					  <genre>Fantasy</genre>
					  <price>5.95</price>
					  <publish_date>2001-09-10</publish_date>
					  <description>The two daughters of Maeve, half-sisters, 
					  battle one another for control of England. Sequel to 
					  Oberon's Legacy.</description>
				   </book>
				   <book id="bk23">
					  <author>Randall, Cynthia</author>
					  <title>Lover Birds</title>
					  <genre>Romance</genre>
					  <price>4.95</price>
					  <publish_date>2000-09-02</publish_date>
					  <description>When Carla meets Paul at an ornithology 
					  conference, tempers fly as feathers get ruffled.</description>
				   </book>
				</catalog>
				'''
def rootNode = new XmlParser().parseText(xml)
rootNode.children().sort(true) {it.attribute('id')}
new XmlNodePrinter().print(rootNode)

 

Then you could compare this output to the output XML of JDBC Teststep.

 

Thanks,

Samy