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}"
}
Thank you so much for your reply nmrao. Can't I do the same thing without groovy? as I have above 50 rest requests.
By the way your code is not working for me, giving error 'No such Property: caseID for class:Model' , could you please tell me whats is wrong with this code?
@groovy.transform.Canonical
import groovy.json.JsonSlurper
import groovy.util.XmlSlurper
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#ResponseAsXml}')
def restResponse = context.expand('${Cases#Response}')
//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 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"Thanks,
Geeta
