Hello,
Maybe you should try this... You should know what page your user wants
because they've clicked on a link to display a certain page (or just
default to the first page if parameter doesn't exist which DBIx::Class
will do). So your action should have access to what page to display via
$c->req->params('page'). Then in the controller you get all of the
photo objects for that particular page (notice the ->all method at the
end of the search) and put that in your stash for TT.
my $page = $c->req->params('page') || '';
$c->stash->{photos} = [$c->model('CatapultDB::Photos')->search(
{
'gallery.id' => $selected_gallery
},
{
join => [qw/ gallery /],
prefetch => [qw/ gallery /],
rows => 2,
page => $page,
}
)->all];
Then in TT code just like you wrote:
[% FOREACH photo IN photos -%]
[% photo.gallery.name %]
[% END -%]
I hope this might help?
Leandro
________________________________
From: Dennis Daupert [mailto:[EMAIL PROTECTED]
Sent: Friday, December 29, 2006 22:38
To: [email protected]
Subject: Re: [Catalyst] DBIx::Class/TT Pager Question
Leandro:
> you don't need to use Data::Page directly
yes, you are quite right, I took out the
explicit call to Data::Page; I set rows => 2,
and my query gets 2 thumbs. Cool.
>you are setting $c->stash->{photos} to an
>array reference when you do
>$c->stash->{photos} = [$c->model( ... ];
>and then you are later trying to make a
>method call ->pager() on that array reference,
>not an object.
With the square brackets, I get an array ref,
and in my template, I do stuff like:
[% FOREACH photo IN photos -%]
[% photo.gallery.name %]
[% END -%]
When I take the square brackets out of the
query, my template doesn't display anything
anymore.
>See the "Paged Results" section of the
>DBIx::Class::Manual::Cookbook POD on
>CPAN.
which of course I'd been trying to beat
into my forehead. Cookbook says:
"you can return a Data::Page object for the resultset
(suitable for use in e.g. a template)
using the pager method:
return $rs->pager();"
So I'm trying to call the pager method from the
resultset. But translating from the cookbook
example (which is non-Catalyst centric) to
Cat code, falls the shadow.
Chisel:
>$c->stash->{pager} => $c->stash->{photos}->pager();
>shouldn't this be an assignment rather than a fat-comma?
Good eyeballs! Yes.
>I think you need to lose the square brackets,
>and you will probably find you then have a
>DBIx::Class::ResultSet, which does have the
>pager() method.
When I do, I get this error:
Caught exception in
Catapult::Controller::Photo::Gallery->display
"DBIx::Class::ResultSet::pager(): Can't create pager for non-paged rs
Going back to the DBIx::Class Cookbook example,
which is pretty simple (no joins or anything), do I
have the joins and the row settings in the right place?
I tried a few combos, and the one that at least doesn't
throw cat down the stairs is the one I have been using:
$c->stash->{photos} =
[$c->model('CatapultDB::Photos')->search(
{
'gallery.id' => $selected_gallery
},
{
join => [qw/ gallery /],
prefetch => [qw/ gallery /],
rows => 2,
}
)];
Much less hair now,
/dennis
_______________________________________________
List: [email protected]
Listinfo: http://lists.rawmode.org/mailman/listinfo/catalyst
Searchable archive: http://www.mail-archive.com/[email protected]/
Dev site: http://dev.catalyst.perl.org/
