Thanks for reply nmrao, I have updated your code as per my case.
@groovy.transform.Canonical
import groovy.json.JsonSlurper
class Model {
def caseID
def name
def description
def createdOn
def buildJdbcData(row) {
row.with {
caseID = CaseID
name = Name
description = Description
createdOn = CreatedOn
}
}
def buildJsonData(Root){
caseID = CaseID
name = Name
description = Description
createdOn = CreatedOn
}
}
def jdbcResponse = context.expand('${JDBC Request#Response}')
def restResponse = context.expand('${Cases#Response}')
//Parsing the jdbc and build the jdbc model object list
def results = new JsonSlurper().parseText(jdbcResponse)
def jdbcDataObjects = []
results.ResultSet.Row.each { row ->
jdbcDataObjects.add(new Model().buildJdbcData(row))
}
//Parsing the json and build the json model object list
def json = new JsonSlurper().parseText(restResponse)
def jsonDataObjects = []
json.Root.each { Root ->
jsonDataObjects.add(new Model().buildJsonData(Root))
}
if (jdbcDataObjects.size() != jsonDataObjects.size()) {
System.err.println("Jdbc resultset size is : ${jdbcDataObjects.size()} and Json result size is : ${jsonDataObjects.size()}")
}
assert jdbcDataObjects == jsonDataObjects, "Comparison of Jdbc and Json data is failed"But I'm getting an error, Text must not be null .
Thanks,
Geeta
Now getting an error "Premature end of file error" . I'm getting correct values from db and json from below given code as in log.info correct values are displaying but unable to compare them, please help
//imports
import groovy.json.JsonSlurper
//grab the response
def ResponseMessage = messageExchange.response.responseContent
//define a JsonSlurper
def json = new JsonSlurper().parseText(ResponseMessage)
def nodes = json.Root
// iterate over each element in the array
for (i = 0; i < nodes.size(); i++) {
def db = context.expand( '${JDBC Request#ResponseAsXml#//Results[1]/ResultSet[1]/Row[' + i + ' + 1 ]/CaseID[1]}' )
log.info nodes[i].CaseID
log.info db
//assert nodes[i].CaseID == db
assert nodes[i].CaseID.equals(db), "CaseID was not ${db}"
}
nmrao Your code works for me , groovy is new to me that's why understanding issue but finally :)
@groovy.transform.Canonical
class Model {
def caseid
def name
def buildJdbcData(row) {
row.with {
caseid = CASEID
name = NAME
}
}
def buildJsonData(root){
root.with {
caseid = CaseID
name = Name
}
}
}
def jdbcResponse = context.expand('${cases JDBC#ResponseAsXml}')
def jsonResponse = context.expand('${cases#ResponseAsXml}')
//Parsing the jdbc and build the jdbc model object list
def results = new XmlSlurper().parseText(jdbcResponse)
def jdbcDataObjects = []
results.ResultSet.Row.each { row ->
jdbcDataObjects.add(new Model().buildJdbcData(row))
}
//Parsing the json and build the json model object list
def Response = new XmlSlurper().parseText(jsonResponse)
def jsonDataObjects = []
Response.Root.e.each { root ->
jsonDataObjects.add(new Model().buildJsonData(root))
}
if (jdbcDataObjects.size() != jsonDataObjects.size()) {
log.info ("Jdbc resultset size is : ${jdbcDataObjects.size()} and Json result size is : ${jsonDataObjects.size()}")
}
assert jdbcDataObjects == jsonDataObjects, "Comparison of Jdbc and Json data is failed"
