I am using Gatling ver. 2.1.7. I want to iterate IDs which I got from sql query.
Below SQL statement will fetch 100 IDs, I want to iterate those 100 IDs. How do I do that?
here is the code,
val dbStatement = System.getProperty("dbStatement", """SELECT ID_ aID FROM MYTable WHERE ID_ IN(some query) LIMIT 100""")
val dbQuery = jdbcFeeder("jdbc:mysql://" + dbUrl +":3306/test", dbUsername, dbPassword, dbStatement)
val scn = scenario("Get Total assets")
.feed(dbQuery)
.exec(http("Fetching tests using IDs")
.get("""/api/assets/${aID}/test""")
)
Thank you.