Forum Discussion

RobinOng's avatar
RobinOng
Occasional Contributor
10 years ago

Looping a Datasource in Groovy script (Always starts at last row)

Hi,   I have been trying to build a datasource loop in Groovy Script. For testing purposes I can't use the DataSourceLoop step. Below is the case.   I have a Datasource (JDBC) with 4 rows in it ...
  • RobinOng's avatar
    RobinOng
    10 years ago

    Hi all,

     

    I posted too soon. I figured it out. You can call repositionAtStartRow to reset the source to the first row.

     

    TSDS1.repositionAtStartRow( testRunner, context)

RobinOng's avatar
RobinOng
Occasional Contributor

Hi all,

 

I posted too soon. I figured it out. You can call repositionAtStartRow to reset the source to the first row.

 

TSDS1.repositionAtStartRow( testRunner, context)

punjprakash's avatar
punjprakash
New Contributor
8 years ago

I am not able to go to next row, methods next( testRunner,context) is not working

 

context.testCase.getTestStepByName("PNRDataSource").setStartRow("0")
context.testCase.getTestStepByName("PNRDataSource").repositionAtStartRow( testRunner, context)
currentRow = context.testCase.getTestStepByName("PNRDataSource").getCurrentRow()
log.info "currentRow First is --" + currentRow
def rowCount = context.testCase.getTestStepByName("PNRDataSource").rowCount
log.info "rowCount-- " + rowCount
for (def i = 0; i < rowCount ; i++) {
//castToString= Integer.toString(i)
//log.info "castToString---" + castToString
//context.testCase.getTestStepByName("PNRDataSource").setStartRow(castToString)
currentRow = context.testCase.getTestStepByName("PNRDataSource").getCurrentRow()
log.info "currentRowSecond is --" + currentRow
execute = context.testCase.getTestStepByName("PNRDataSource").getPropertyValue("Execute")
log.info "execute is --" + execute
log.info context.testCase.getTestStepByName("PNRDataSource").next(testRunner,context)
currentRow = context.testCase.getTestStepByName("PNRDataSource").getCurrentRow()
log.info "currentRowThird is --" + currentRow
}

 

Fri Jul 28 14:32:49 CDT 2017:INFO:currentRow First is --0
Fri Jul 28 14:32:49 CDT 2017:INFO:rowCount-- 6
Fri Jul 28 14:32:49 CDT 2017:INFO:currentRowSecond is --0
Fri Jul 28 14:32:49 CDT 2017:INFO:execute is --N
Fri Jul 28 14:32:49 CDT 2017:INFO:false
Fri Jul 28 14:32:49 CDT 2017:INFO:currentRowThird is --0
Fri Jul 28 14:32:49 CDT 2017:INFO:currentRowSecond is --0
Fri Jul 28 14:32:49 CDT 2017:INFO:execute is --N
Fri Jul 28 14:32:49 CDT 2017:INFO:false
Fri Jul 28 14:32:49 CDT 2017:INFO:currentRowThird is --0
Fri Jul 28 14:32:49 CDT 2017:INFO:currentRowSecond is --0
Fri Jul 28 14:32:49 CDT 2017:INFO:execute is --N
Fri Jul 28 14:32:49 CDT 2017:INFO:false
Fri Jul 28 14:32:49 CDT 2017:INFO:currentRowThird is --0
Fri Jul 28 14:32:49 CDT 2017:INFO:currentRowSecond is --0
Fri Jul 28 14:32:49 CDT 2017:INFO:execute is --N
Fri Jul 28 14:32:49 CDT 2017:INFO:false
Fri Jul 28 14:32:49 CDT 2017:INFO:currentRowThird is --0
Fri Jul 28 14:32:49 CDT 2017:INFO:currentRowSecond is --0
Fri Jul 28 14:32:49 CDT 2017:INFO:execute is --N
Fri Jul 28 14:32:49 CDT 2017:INFO:false
Fri Jul 28 14:32:49 CDT 2017:INFO:currentRowThird is --0
Fri Jul 28 14:32:49 CDT 2017:INFO:currentRowSecond is --0
Fri Jul 28 14:32:49 CDT 2017:INFO:execute is --N
Fri Jul 28 14:32:49 CDT 2017:INFO:false
Fri Jul 28 14:32:49 CDT 2017:INFO:currentRowThird is --0

  • groovyguy's avatar
    groovyguy
    Community Hero
    8 years ago

    punjprakash: You are replying to a thread that was already solved over two years ago. You may want to consider starting a new thread for your own issues next time.

     

    That being said, the " next( testRunner,context)" method works for me, but only when actively running a test case (or test suite) as a test. It does not work if I run a stand-alone test. Maybe that'll help.