RSS Feed

Axe Test Automation Platform

Hi Sam,
I am doing proof of concepts on data base testing and when I try to retrieve data from data base table using scripts I am getting entire data along with xml tags. Is there any option to get comma separated data rather than xml data?
In the object map I used Class=DbQueryResult and when I use class=DbResultNode I only get first record.

Below is the data I am getting when I use Class=DbQueryResult:
<NewDataSet><Table><VERIFICATION_TYPE>1</VERIFICATION_TYPE></Table><Table><VERIFICATION_TYPE>999</VERIFICATION_TYPE></Table><Table><VERIFICATION_TYPE>6</VERIFICATION_TYPE></Table><Table><VERIFICATION_TYPE>2</VERIFICATION_TYPE></Table><Table><VERIFICATION_TYPE>4</VERIFICATION_TYPE></Table><Table><VERIFICATION_TYPE>5</VERIFICATION_TYPE></Table><Table><VERIFICATION_TYPE>3</VERIFICATION_TYPE></Table><Table><VERIFICATION_TYPE>7</VERIFICATION_TYPE></Table><Table><VERIFICATION_TYPE>0</VERIFICATION_TYPE></Table></NewDataSet>
Below is the data I am getting when I use Class= DbResultNode:
1
From the above table what I am trying to get into expected results: 1, 999, 6, 2, 5, 3, 7, 0
Let me know your suggestions.

Cheers,
Narendra.

Hi Narendra,

You need to use xpath queries to map the database fields to Axe objects, via the Axe (Excel) object map.
There are comprehensive examples of how to do this in the HarnessDemo sample project provided with Axe. Specifically, please take a look at DBTests.xml and DemoDB.ObjectMap.xml

Sam

Hi Sam,
Thanks, providing xpath on action I can get the data. Still need to work out how to get data with comma delimiter.

Cheers,
Narendra

Hi Sam,
We got comma separated output by manipulating the query using concatenation instead of working with xpath.

Cheers,
Narendra.