Forum Discussion

richie's avatar
richie
Community Hero
6 years ago

JDBC Step Script Assertion To Pass MULTIPLE Instances of Same Value to Properties Step

Hi,   This is a bit complicated so I'm going to try and be really clear in my query - I apologise if I'm not.   I have a GET REST request that I'm testing that retrieves data from a database ...
  • nmrao's avatar
    nmrao
    6 years ago

    richie 

    That case is obvious.


    If I remember well, this was brought to discussion then. That time, it was given in the way so that you could get it going, but it was not logical because of constraint of single row as result.

    Your entire use case can be done with single groovy script(hope this was too mentioned). But that can take some time and need to be coded accordingly.

    Currently, it is limiting due to the use of Property test step (which I never prefer).

    Even with your current test steps, it should be possible to continue to use.

    1. Store the JDBC test step result (multiple rows) into csv file. Have to write the simple script.
    2. Introduce a DataSource test step right after JDBC step and read above csv file.
    3. Read each row and Assign them into Properties step (which you have already, dealing single row)
      NOTE: But not sure if OTB allows to do this. Otherwise, you may know already how to read a csv file and use those values. If this is case, it may require to adopt these changes in below step.
    4. Groovy script which is dealing with Dynamic parameters and do REST call - no change (if Properties step can hold the data from CSV)
    5. Datasource loop.

    I think you should be ok.

nmrao's avatar
nmrao
Champion Level 3
6 years ago

richie 

That case is obvious.


If I remember well, this was brought to discussion then. That time, it was given in the way so that you could get it going, but it was not logical because of constraint of single row as result.

Your entire use case can be done with single groovy script(hope this was too mentioned). But that can take some time and need to be coded accordingly.

Currently, it is limiting due to the use of Property test step (which I never prefer).

Even with your current test steps, it should be possible to continue to use.

  1. Store the JDBC test step result (multiple rows) into csv file. Have to write the simple script.
  2. Introduce a DataSource test step right after JDBC step and read above csv file.
  3. Read each row and Assign them into Properties step (which you have already, dealing single row)
    NOTE: But not sure if OTB allows to do this. Otherwise, you may know already how to read a csv file and use those values. If this is case, it may require to adopt these changes in below step.
  4. Groovy script which is dealing with Dynamic parameters and do REST call - no change (if Properties step can hold the data from CSV)
  5. Datasource loop.

I think you should be ok.

  • TanyaYatskovska's avatar
    TanyaYatskovska
    SmartBear Alumni (Retired)
    6 years ago

    Hi richie,

     

    Have you come to the solution? Please share it with us.

    • richie's avatar
      richie
      Community Hero
      6 years ago

      Hi TanyaYatskovska & nmrao 

       

      Apologies - I've been side tracked on documentation for the last couple of days.

       

      @Rao - the single record options was EXACTLY what I needed originally - I never needed the complication of multiple records in the resultset.  It was only that there was a late requirement change for a very small use case and one of the ways I considered handling this was to retrieve multiple rows for the initial JDBC data extraction step. 

       

      HOWEVER - they canned the requirement completely - so I don't actually need to bother with this anymore.

       

      I've made a note as to your guidance for future reference however, cos lets face it - I need  all the help I can get!

       

      I'm accepting @Rao's answer without attempting it - if I had more time I'd like to try it out - but I'm maxed at work so no time for playing,

       

      Cheers to both!

       

      richie