You say this code is only comparing the date but not the id, but why do you say that? From your screenshot it looks like the end result is an assertion like this:
assert ['20170308','20170330'] == ['20170308','20170330']
And then it is not throwing an assertion error... so isn't it already correct?
Otherwise, can you explain differently what the problem is?
Hi thanks for your response
You are correct, it gives results :
assert ['20170308','20170330'] == ['20170308','20170330']
but it does not display the assertion it has performed for other attribute that is - transaction date.
so does it mean it is internally validating all the attributes and displaying only the latest in the result ?
I checked it by manually changing the value of ID in JDBC XML , it captures it correctly but still at the time of comparing it only compared date and not ID and passed the step.
Hi nmrao,
Thanks for your response. Please find below
JSON Response
{
"customerId": "1234",
"yearMonth": "201703",
"transactions": [
{
"transactionId": "C111.158",
"transactionDate": 20170308,
"storeId": 1123,
"marketingName": "ABC Store",
"storeVisitToCity": "StoreCity",
"transactionChanel": "In-Store",
"transactionValue": 566,
"totalDiscount": -33
},
{
"transactionId": "C123.876",
"transactionDate": 20170330,
"storeId": 1111
"marketingName": "StoreName2",
"storeVisitToCity": "cityStore",
"transactionChanel": "In-Store",
"transactionValue": 117,
"totalDiscount": 0
}
]
}
--------------------------------------------------------
XML JDBC response
<Results>
<ResultSet fetchSize="10">
<Row rowNumber="1">
<TRANSACTION_ID>C111.158</TRANSACTION_ID>
<TRANSACTION_DATE_KEY>20170309</TRANSACTION_DATE_KEY>
<TRANSACTION_VALUE>566</TRANSACTION_VALUE>
<TOTAL_DISCOUNT>-33</TOTAL_DISCOUNT>
<STORE_ID>1123</STORE_ID>
<MARKETING_NAME>ABC Store</MARKETING_NAME>
<VISIT_TO_CITY>StoreCity</VISIT_TO_CITY>
<TRANSACTION_CHANNEL_DESC>In-Store</TRANSACTION_CHANNEL_DESC>
</Row>
<Row rowNumber="2">
<TRANSACTION_ID>C123.876</TRANSACTION_ID>
<TRANSACTION_DATE_KEY>20170330</TRANSACTION_DATE_KEY>
<TRANSACTION_VALUE>117</TRANSACTION_VALUE>
<TOTAL_DISCOUNT/>
<STORE_ID>1111</STORE_ID>
<MARKETING_NAME>StoreName2</MARKETING_NAME>
<VISIT_TO_CITY>cityStore</VISIT_TO_CITY>
<TRANSACTION_CHANNEL_DESC>In-Store</TRANSACTION_CHANNEL_DESC>
</Row>
</ResultSet>
</Results>
Hi,
I tried to use below:
def jdbcResponse = context.expand('${JDBC#ResponseAsXML#(//Results)}')
def results = new XmlSlurper().parseText(jdbcResponse)
.ResultSet.Row.collect{[transactionId: it.TRANSACTION_ID,
transactionDate: it.TRANSACTION_DATE_KEY,
transactionValue: it.TRANSACTION_VALUE,
totalDiscount: (it.TOTAL_DISCOUNT).toString(),
storeId: it.STORE_ID,
] }
log.info "JDBC -> " + results
def restResponse = context.expand('${Request#Response}')
def arrayOfTagInfo = new JsonSlurper().parseText(restResponse)
.transactions.collect{ [transactionId: it.transactionId,
transactionDate: it.transactionDate,
transactionValue: it.transactionValue,
totalDiscount:(it.totalDiscount).toString(),
storeId: it.storeId,
] }
log.info "JSON -> " + arrayOfTagInfo
assert results == arrayOfTagInfo
Now this is not able to compare values of - totalDiscount because in the values are :
JSON
"totalDiscount": -32.4
"totalDiscount": 0
JDBC XML
<TOTAL_DISCOUNT>-32.4</TOTAL_DISCOUNT>
<TOTAL_DISCOUNT/> ---------------------------------------> because from database, value of totaldiscount is null for this particular tag.
Please help!
