in soapui, have jdbc test step returns following data:
<results> <resultset fetchsize="128"> <row rownumber="1"> <id>1</id> <name>testname1</name> <description/> <type>bool</type> <isproducttag>true</isproducttag> <islocationtag>false</islocationtag> <subsection>default sub section</subsection> <section>default section</section> <subgroup>default sub group</subgroup> <group>default group</group> </row> <row rownumber="2"> <id>2</id> <name>testname2</name> <description/> <type>bool</type> <isproducttag>true</isproducttag> <islocationtag>false</islocationtag> <subsection>default sub section</subsection> <section>default section</section> <subgroup>default sub group</subgroup> <group>default group</group> </row> </row> </resultset> i have rest api xml response contains following data:
<arrayoftaginfo> <taginfo id="1" name="testname1" type="bool" isproducttag="true" islocationtag="false" subsection="default sub section" section="default section" subgroup="default sub group" group="default group"/> <taginfo id="2" name="testname2" type="bool" isproducttag="true" islocationtag="false" subsection="default sub section" section="default section" subgroup="default sub group" group="default group"/> </arrayoftaginfo> i able compare(assert) both database values , response values (response can in xml or json depending on request accept header) using groovy arrays if possible data returned database can large.
can help?
if have soapui-pro, should able accomplish no groovy.
- make rest call retrieve data.
- start datasource step parses xml.
- make jdbc call select correct id of row want verify. make assertions in here.
- loop #2.
Comments
Post a Comment