in reply to Re^2: Iterating through DBIx resultset
in thread Iterating through DBIx::Class resultset

It's a bit of a bear, and the docs are definitely a jungle, but that cookbook is a great starting place. Jump on #dbix-class on irc.perl.org and you'll get a lot of good help figuring out things that aren't immediately intuitive.

Three thousand years of beautiful tradition, from Moses to Sandy Koufax, you're god damn right I'm living in the fucking past

Replies are listed 'Best First'.
Re^4: Iterating through DBIx resultset
by PerlSufi (Friar) on Jul 02, 2014 at 17:39 UTC
    I just changed it to this instead. Do you think I still need to iterate to last page? : 
    my $max_records = '';

GetOptions("max_records=i" => \$max_records)
    or die ("Error in command line arguments\n");

my @results = My::App::Schema->schema->resultset('MyTable')->search(
     undef,
        {
            page => 1,
            rows => $max_records,
        }
    );

for my $result ( @results ) {
### Processing Domain ID: ($result->id)
      print $result."\n";
}

    [download]
    Also, is irc.perl.org on freenode?
[reply]
[d/l]

      I think you need to call ->all: 

      my @results = My::App::Schema->schema->resultset('MyTable')->search(
     undef,
        {
            page => 1,
            rows => $max_records,
        }
    )->all;

      [download]

      irc.perl.org is the IRC server. So you'd connect to it like you would connect to freenode and /join the #dbix-class channel.

      Three thousand years of beautiful tradition, from Moses to Sandy Koufax, you're god damn right I'm living in the fucking past

[reply]
[d/l]
[select]
        I think that worked without using  ->all but I did use 'all' for another part of my script..
        And thanks for the irc reference :)
[reply]
[d/l]

In Section Seekers of Perl Wisdom