Forum Discussion

chsekhar's avatar
chsekhar
New Contributor
6 years ago

Validate multiple values from Database.

Hi all, I have a bit of a challenge. I am new to soap UI and Groovy scripting. I am comparing few values from my output to the database values. So my test case contains: 1. DataSource which will retu...
Assertions
Data-Driven Testing
SOAP
  • HimanshuTayal's avatar
    HimanshuTayal
    6 years ago

    You can use if condition and setting desired values at your script level.

     

    for ex: if DB return 1 then 

     

    def dbVal = "YOUR DB QUERY"

    if(dbVal == "1"){

    dbVal = "true"

    }

    else{

    dbVal = "false"

    }

     

richie's avatar
richie
Community Hero

Hi chsekhar 

 

If I understand correctly - to verify certain attributes have multiple values I think you could use a script assertion (script assertion on the test step) - something like the following:

 

//courtesy of Rao
def object = new JsonSlurper().parseText(response.text)
assert object.Parents.firstName == ['XYZ', 'XYZ1', "XYZ2"]

or perhaps something like the following:

 

//courtesy of Rao
def json = new groovy.json.JsonSlurper().parseText(context.response)
assert json.Parents.firstName.every{it == 'XYZ' || 'XYZ1' || 'XYZ2'}

Hope this helps,

 

cheers,

 

rich

chsekhar's avatar
chsekhar
New Contributor
6 years ago

richie Thanks for your reply, I will try it out and see how it goes. Also my 2nd question was  isPrimaryContact value is 1 or 0 in DataBase, where 1 would return true and 0 would be false in Json output. How do I convert them to match the content?