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"

    }

     

HimanshuTayal's avatar
HimanshuTayal
Community Hero

chsekhar ,

 

As far as i know, you can't verify this via content assertion, for this to validate you need to write some groovy code.

 

1. First you just check size of parent array

2. then iterate and assert through each node you want to validate.

 

Olga_T's avatar
Olga_T
SmartBear Alumni (Retired)
6 years ago

Hi all,

 

chsekhar, were the above replies helpful? If so, could you please click the button below the appropriate reply to accept it as a solution?

Otherwise, please provide us with updates.

Thank you in advance.