Forum Discussion

MKV's avatar
MKV
Contributor
7 years ago

how to count the number of rows fetched in data source

Hi,   Is it possible to count the number of datas fetched in a data source in readyapi? Can it be stored in a variable to use in the next steps.   Thanks!
  • HimanshuTayal's avatar
    HimanshuTayal
    7 years ago

    Hi MKV

     

    Try below code:

    DSrowCount = testRunner.testCase.testSteps["DataSource"].rowCount
log.info DSrowCount

     

    Do Like/Accept it as Solution if it solves your query.

     

    Thanks,

    Himanshu Tayal

HimanshuTayal's avatar
HimanshuTayal
Community Hero

Hi MKV

 

Try below code:

DSrowCount = testRunner.testCase.testSteps["DataSource"].rowCount
log.info DSrowCount

 

Do Like/Accept it as Solution if it solves your query.

 

Thanks,

Himanshu Tayal

tech321's avatar
tech321
Contributor
6 years ago

The problem is that the rowCount does not return the actual row count, in my case 200. I have to run my data source step manually first to create the rows and then rowCount will return the actual row count. When I try to automate this and I try to use: 

def tst = testRunner.runTestStepByName("myDataSource")

DSrowCount = testRunner.testCase.testSteps["myDataSource"].rowCount
log.info DSrowCount

it does not work. There are 200 rows in the datasource but the rowCount returns 1. Is there any way to make the rowCount return 200 instead of 1?

Thanks 

  • nmrao's avatar
    nmrao
    Champion Level 3
    6 years ago
    tech321,

    Would you mind opening a fresh thread (the previous one was already closed ) with more details of the issue such as what steps does the test case has? Where do you need that row count? What type of data source are you using?