Forum Discussion

martonjurak's avatar
martonjurak
Occasional Contributor
6 years ago

JDBC script assertion

Hi, I have a jdbc request where the result is the following: <Results>    <ResultSet fetchSize="10">       <Row rowNumber="1">          <STATUS_ID/>       </Row>       <Row rowNumber="2">  ...
Assertions
Scripting
  • nmrao's avatar
    nmrao
    6 years ago

    Below script assertion should help you:

     

    /**
* Script Assertion for the JDBC Request Test step
**/
    assert context.response, 'Response is empty or null'
def xml = new XmlSlurper().parseText(context.response)
def validList = ['20', '']
def statusIds = xml.'**'.findAll {'STATUS_ID' == it.name() }*.text()


assert statusIds.every{ it in validList}, 'Invalid values present in the response for Status Ids'
nmrao's avatar
nmrao
Champion Level 3
6 years ago

Below script assertion should help you:

 

/**
* Script Assertion for the JDBC Request Test step
**/
assert context.response, 'Response is empty or null'
def xml = new XmlSlurper().parseText(context.response)
def validList = ['20', '']
def statusIds = xml.'**'.findAll {'STATUS_ID' == it.name() }*.text()


assert statusIds.every{ it in validList}, 'Invalid values present in the response for Status Ids'
    • martonjurak's avatar
      martonjurak
      Occasional Contributor
      6 years ago

      Hi Rao,

       

      Thank you for the answer.

      Actually I changed my SQL query to get any results only when it is not 20 or null, so in that case I will assert the exists result.

      I am sure I will need your assertion in the next weeks so I will try it.

       

      Br

      Marton

      • nmrao's avatar
        nmrao
        Champion Level 3
        6 years ago
        No worries. Keep in mind that people are spending time on the questions.