使用groovy脚本在SoapUI中比较JDBC响应和REST API响应

import groovy.sql.Sql

def sql = Sql.newInstance("jdbc:mysql://localhost:3306/mydatabase", "username", "password", "com.mysql.jdbc.Driver")
def query = "SELECT * FROM mytable"
def result = sql.rows(query)

return result

import groovy.json.JsonSlurper
import com.eviware.soapui.support.XmlHolder

def response = context.expand('${REST API Request#Response}')
def contentType = context.expand('${REST API Request#Response#ContentType}')

if (contentType.contains("application/json")) {
    def jsonSlurper = new JsonSlurper()
    def result = jsonSlurper.parseText(response)
    return result
} else if (contentType.contains("application/xml")) {
    def xmlHolder = new XmlHolder(response)
    def result = xmlHolder.getNodeValues("//path/to/node")
    return result
} else {
    return response
}

def jdbcResponse = testRunner.testCase.testSteps["JDBC Request"].getPropertyValue("Response")
def restApiResponse = testRunner.testCase.testSteps["REST API Request"].getPropertyValue("Response")

if (jdbcResponse == restApiResponse) {
    log.info("JDBC response and REST API response are the same.")
} else {
    log.error("JDBC response and REST API response are different.")
}