问如何获取带条件返回的结果并断言正确的值

EN

//SQL statement
String dbQuery2 = /SELECT * FROM public.test where testId = 'default'/


//Connect to PostgresSQL, global variable is stored at profile
List results = CustomKeywords.'test.database.getPostgresSQLResults'(GlobalVariable.dbConnString2 , GlobalVariable.dbUsername2 , GlobalVariable.dbPassword2 ,GlobalVariable.dbDriver2 ,dbQuery2 )
println(results)


//print the "test_info" column
String test_info = results.get(0).get('test_info')
println(test_info)

//convert to json format and verify result
def test_infojson = new JsonSlurper().parseText(new String(test_info))
println('Database test_info response text: \n' + JsonOutput.prettyPrint(JsonOutput.toJson(test_infojson)))

{
    "testId": "default",
    "testLines": [
        {
            "testId": "TC-1",
            "name": "a",
            "isDeleted": true
        },
        {
            "testId": "TC-1",
            "name": "b",
            "isDeleted": false
        },
                {
            "testId": "TC-2",
            "name": "c",
            "isDeleted": true
        },
        {
            "testId": "TC-2",
            "name": "d",
            "isDeleted": false
        }
    ],
}

assertThat(test_infojson.testLines[0].name).isEqualTo("b")