chutney-testing/chutney-legacy

๐Ÿš€ | Add utiliy method on sql Records

nbrouand opened this issue ยท 2 comments

Describe your use case

Add utiliy method on sql Records.

Describe the solution you'd like

Currently:
"bestMoviesTitles" to "records.stream().map(row -> row.get("TITLE").value).collect(T(java.util.stream.Collectors).toList())".spEL()

Wanted:
"bestMoviesTitles" to "records.rows().get("TITLE")".spEL()
"bestMoviesTitles" to "records.row(12).get("TITLE")".spEL()

"bestMoviesTitles" to "records.rows().get("TITLE")".spEL()
-> could be "rows.get("TITLE")".spEL() if we set a Rows class holding a List attribut in output

"bestMoviesTitles" to "records.row(12).get("TITLE")".spEL()
-> could then be "rows.get(12).get("TITLE")".spEL()

We could also have an alias for the first row only, so add rows.get(0) in the output