Forum Discussion

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 return few rows. 2. Rest request which will return the json nodes. I am using content assertion to compare values, if the DataSource returns single row my assertion works fine but when there are multiple rows it will only compare 1st row not the other rows. Is there any option to compare multiple rows that are returned?

Example:

My JSON output is something like this:

 "parents": [
      {
        "personalTitlePrefix": null,
        "firstName": "XYZ",
        "middleName": null,
        "lastName": "ABC",
        "generationCodeSuffix": null,
        "maidenName": null,
        "gender": "U",
        "relationship": null,
        "isPrimaryContact": false
      },
      {
        "personalTitlePrefix": null,
        "firstName": "XYZ1",
        "middleName": null,
        "lastName": "ABC1",
        "generationCodeSuffix": null,
        "maidenName": null,
        "gender": "U",
        "relationship": null,
        "isPrimaryContact": true
      },
      {
        "personalTitlePrefix": null,
        "firstName": "XYZ2",
        "middleName": null,
        "lastName": "ABC2",
        "generationCodeSuffix": null,
        "maidenName": null,
        "gender": "U",
        "relationship": null,
        "isPrimaryContact": true
      }
    ],

I need to compare FirstName, LastName,Gender and PrimaryContact values from the database.

Another question is 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?

Assertions

Data-Driven Testing

SOAP

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
Community Hero
6 years ago
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
  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?
HimanshuTayal
Community Hero
6 years ago
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
  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.
- chsekhar
  New Contributor
  6 years ago
  HimanshuTayal Thanks for the reply. Do you have any idea how do I convert the values so I can match 1 to true and 0 to false
  
  isPrimaryContact value is 1 or 0 in DataBase, where 1 would return true and 0 would be false in Json output.
  - HimanshuTayal
    Community Hero
    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"
    
    }