Forum Discussion

US_20's avatar
US_20
Occasional Contributor
6 years ago

Assertions with conditions

Hi, I am new to SOAP UI, I have a JDBC request which is a select query and it returns an XML response.  JDBC request (say Request B)==> In response, there is a field, Order total which returns 0 ...
Assertions
  • groovyguy's avatar
    groovyguy
    6 years ago

    I mocked up a rest request with the response you provided, but I ran into a problem mocking out a JDBC request since I don't have ready access to a database. Still, I was able to put together a groovy script that will compare a value returned by the rest request in the morphOnlyNetAmount in the response against a REFUNDABLE_AMOUNT if the latter is a postive integer. You'll need to adjust the script to your own uses, but it should be a good start.

     

    package json
import com.eviware.soapui.support.XmlHolder
import groovy.json.*


// Cna use the right-click Get-Data menu here to get the rest request response.
def restResponse = context.expand( '${REST Request#Response}' )

log.info(restResponse);

def r = new JsonSlurper().parseText(restResponse)

// Gets the morphOnlyNetAmount from response and converts to float.
def restValue = r.morphOnlyNetAmount.toFloat();

// You need to use the right-click Get-Data menu here to ensure it works as expected. Without a fully formed JDBC response, I cannot fully mock this out. 
def jdbcResponse = context.expand( '${JDBC Requests#Response#//REFUNDABLE_AMOUNT[1]}' ).toFloat();


if (jdbcResponse > 0)
{
	assert (jdbcResponse == restValue)
}
US_20's avatar
US_20
Occasional Contributor

Hi Richie ,

 

Thanks for looking into my query. So here is my request:

 

1. REST request which will return a field A (+ve or -ve integer) as response

2. JDBC request that will return a response which has Order Total field (field B)-- can be 0 or +ve integer

 

Now I need to make sure if field B value and field A value are equal only if field B returns a +ve integer(>0)

 

Can you pls help me how to assert this?

 

 

groovyguy's avatar
groovyguy
Community Hero
6 years ago

My first thought is that this may have to be done via a groovy script. Can you provide some responses, sample or mocked up, so that we can see exactly what we're dealing with?

  • groovyguy's avatar
    groovyguy
    Community Hero
    6 years ago

    I mocked up a rest request with the response you provided, but I ran into a problem mocking out a JDBC request since I don't have ready access to a database. Still, I was able to put together a groovy script that will compare a value returned by the rest request in the morphOnlyNetAmount in the response against a REFUNDABLE_AMOUNT if the latter is a postive integer. You'll need to adjust the script to your own uses, but it should be a good start.

     

    package json
import com.eviware.soapui.support.XmlHolder
import groovy.json.*


// Cna use the right-click Get-Data menu here to get the rest request response.
def restResponse = context.expand( '${REST Request#Response}' )

log.info(restResponse);

def r = new JsonSlurper().parseText(restResponse)

// Gets the morphOnlyNetAmount from response and converts to float.
def restValue = r.morphOnlyNetAmount.toFloat();

// You need to use the right-click Get-Data menu here to ensure it works as expected. Without a fully formed JDBC response, I cannot fully mock this out. 
def jdbcResponse = context.expand( '${JDBC Requests#Response#//REFUNDABLE_AMOUNT[1]}' ).toFloat();


if (jdbcResponse > 0)
{
	assert (jdbcResponse == restValue)
}
    • US_20's avatar
      US_20
      Occasional Contributor
      6 years ago

      Thanks so much.. it worked!

      • groovyguy's avatar
        groovyguy
        Community Hero
        6 years ago

        You are more than welcome! Glad I was able to help out.

  • US_20's avatar
    US_20
    Occasional Contributor
    6 years ago

    Hi ,

    Here is what my sample response looks like:

     

    Below is the response returned by the REST request

    {
    "morphOnlyNetAmount" : -20.31---- (This value can be a +ve or -ve value)
    }

     

    The JDBC response will return a field <REFUNDABLE_AMOUNT> -- can return 0 or >0.

     

    Now I need to make sure if REFUNDABLE_AMOUNT value and morphOnlyNetAmount value are equal only if  REFUNDABLE_AMOUNT returns a +ve integer(>0)

     

     

     

    So the 

    • groovyguy's avatar
      groovyguy
      Community Hero
      6 years ago

      Okay, that helps a bit! And pardon my potential ignorance, but what is +ve and/or -ve integer? What does that stand for? I am not familiar with that notation.

      • US_20's avatar
        US_20
        Occasional Contributor
        6 years ago

        No worries :) Sorry +ve is positive and -ve is negative.