Forum Discussion

LennSar's avatar
LennSar
Contributor
3 years ago

groovy data source loop

Hi there,   typically when using the data source I can set the amount of rows that shall be generated and with that how many times the loop should occur. Now I try to generate a data source using a...
Configuration
Function Tests
REST
Scripting
groovyguy's avatar
groovyguy
Community Hero

The way I handle this is to create a primary data source that is a grid, and I fill it with how many rows of  data that I need to process. It would look something like this:

 

Count Data Source (set with 1 property, X rows, where the data does not matter.)

           Groovy Script Data Source

           Tests using GS data Source

Data Source Loop using Count Data Source as its control, and pointed at GS Data Source for its test step.


This way the Count Data Source will control how many iterations you have.

 

 

LennSar's avatar
LennSar
Contributor
3 years ago

Hi groovyguy,

 

thanks for the tip. I solved various issues with a similar approach but was hoping for some groovy command being able to determine the amount of rows generated. Well, this approach will certainly work as well.

Could you just tell me how you generate several rows in the grid dataSource (which I assume is the dataSource you named GroovyDataSource above?).

I know I can write a single value to a DataSourceProperty with 

result["DataSourceProperty"] = someValue

 

but how do I generate several lines? Can I simply use the index operator like 

 

result["DataSourceProperty"][0] = someValue[0]
result["DataSourceProperty"][1] = someValue[1]
result["DataSourceProperty"][2] = someValue[2]

 

Thanks a lot for the quick help!

 

Cheers,

 

Lennart

  • groovyguy's avatar
    groovyguy
    Community Hero
    3 years ago

    LennSar Not a problem! Always happy to help.

    If I understand your next question, you want to generate 3 rows at once from the Groovy Data Source and access those all at the same time? I am not sure you can do that all at once. I haven't figured out a way, at least.

    You could create a loop within your groovy datasource and triplicate your properties, but even that seems convoluted and messy in the long term.

     

    If I might ask, what is your use case with needing three rows from the data source at once?

    • LennSar's avatar
      LennSar
      Contributor
      3 years ago

      No it would be fine to generate the data one after another. The use case is that I need randomly generate dates but need to make sure that the second date is later than the last.

       

      so if the first date would be 21.2.2022 the second must be at least 22.02.2022 and not 20.02.2022. 

      My initial idea was to generate these dates from a script, write the results to the data source and than loop over the data source. 

      I think based on what I know now I would insert the generation script in the loop and use the setPropertyValue Method to write in the relevant commands (instead of deriving the data from the data source) to make sure the second date is later than the first I would just store current year, month and date in a property so that I can access that on every iteration and count it upwards.

      • richie's avatar
        richie
        Community Hero
        3 years ago
        Hey LennSar,

        Sorry i'm a bit late to posting on this. I was just thinking. Rather than bother struggling with groovy to generate a date, write it to a property, add days to the value, pass value to the payload and then repeat these steps for each request, you could just do your data manipulation in a xls./xlsx (probably the only time i advocate using an xls/xlsx), saving yourself some of the pain?

        I dunno....just a suggestion!

        Cheers,

        Rich