Re: Mapping GroovyResultSet to POGOs?

> I made a blog post how to do what you want here:
>
> http://reumann.blogspot.com/2009/05/set-pojo-properties-with-groovy-sql-row.html
>
> You just need the call toRowResult()
>
> def getPersons() {
>     def persons = []
>     sql.eachRow("Select * from Person") {
>         persons << new Person( it.toRowResult() )
>     }
>     return persons
> }
>
>
>
> On Wed, Jul 1, 2009 at 12:59 PM, Tom Nichols <tmnichols@...> wrote:
>>
>> I thought it was possible to "map" a GroovyResultset to a POGO like this:
>> class Person {
>>  String name
>>  String address
>> }
>>
>> def sql = Sql.newInstance(...)
>> def people = []
>> sql.eachRow( "select name, address from person" ).eachRow { people <<
>> new Person( it ) }
>>
>> This would be possible if the GroovyResultSet were interpreted as a
>> Map, correct?  i.e. the map would contain named properties that can
>> normally be passed to a constructor in Groovy.  Would this be possible
>> by adding an asType(Map) to GroovyResultset?
>>
>> Thanks.
>> -Tom
>>
>> ---------------------------------------------------------------------
>> To unsubscribe from this list, please visit:
>>
>>    http://xircles.codehaus.org/manage_email
>>
>>
>
>
>
> --
> Rick R
>