Re: Issues with DBIx::Class

Besides the module Your Mother suggested, you can use an idiom like:

for my $result_as_href ( map { $_->get_columns } $rs->all ) {
    # do something with the hash ref
}
[download]

I use this in debugging all the time.

Hope this helps!

,bR>

The way forward always starts with a minimal test.

Comment on Re: Issues with DBIx::Class Download Code

Replies are listed 'Best First'.
Re^2: Issues with DBIx::Class by NERDVANA (Priest) on Mar 24, 2022 at 02:25 UTC
map syntax is wrong, it should be `map +{ $_->get_columns }, $rs->all`	[reply] [d/l]
Re^2: Issues with DBIx::Class by LittleJack (Beadle) on Mar 24, 2022 at 00:37 UTC
Thanks for your help. I'm doing exactly what you said and not getting individual hashrefs in Data::Dumper output. Instead I get each column by itself, one line per loop: `$VAR1 = 'id'; $VAR1 = 99; $VAR1 = 'some_thing'; $VAR1 = 'bar';` [download] Is there some missing step in your method, or am I missing something again?	[reply] [d/l]
Re^3: Issues with DBIx::Class by 1nickt (Canon) on Mar 24, 2022 at 11:28 UTC
Sorry, I missed a curly brace pair. `for my $result_as_href ( map { { $_->get_columns } } $rs->all ) { # do something with the hash ref }` [download] The way forward always starts with a minimal test.	[reply] [d/l]
Re^4: Issues with DBIx::Class by LittleJack (Beadle) on Mar 25, 2022 at 03:26 UTC
Thanks for following up! I still find it a little strange that DBIxC doesn't have a built-in method which returns a hash but I guess it's all about being very low level, and if I want an `as_hashref()` method or any other method like that, I can write my own in a `ResultSet.pm`	[reply] [d/l] [select]