iterate over sql results

classic Classic list List threaded Threaded
3 messages Options
Reply | Threaded
Open this post in threaded view
|

iterate over sql results

mlybarger
i'm looking for a way to iterate over a sql result set.  any tips would be most appreciated.
Reply | Threaded
Open this post in threaded view
|

Re: iterate over sql results

mlybarger
i was able to put the results into a session variable and get them out as an arraylist to work with.  
Reply | Threaded
Open this post in threaded view
|

Re: iterate over sql results

Christoph Deppisch
Administrator
The usual SQL result set validation mechanism in Citrus should support multiple rows in result set. So you can just add multiple expected SQL result set rows.

If that does not fit your need you could also add a custom com.consol.citrus.validation.script.sql.SqlResultSetScriptValidator

That validator is provided with the raw SQL result set as a List of Maps. You can add custom validation logic here very easy with iterations on the complete result set.