[Dbix-class] Per the design of a method

[Alexander Hartmaier]

Am 2011-06-16 19:27, schrieb dorian taylor:
> On Thu, Jun 16, 2011 at 10:17 AM, Peter Rabbitson<rabbit+dbic at rabbit.us>  wrote:
>
>> This won't be wrong - ->count returns how many objects you would receive
>> via ->all/->next. If you want full count of the underlying source with
>> all limits removed - keep the original resultset around. If you do not care
>> about WHERE conditions either - $rs->result_source->resultset->count will
>> do it for you.
> Except it is wrong:
>
> my $rs = $db->resultset('Employee::Job')->search(
>      { period =>  '2010-02-28' },
>      {
>          rows =>  100,
>          offset =>  100,
>      }
> );
>
> print $rs->count; # 100, the number I'm looking for is 2023
>
> So what it looks like I want to do is like you suggested, clone the
> ResultSet and either get the WHERE clause out of the original or
> remove the rows/offset attributes and/or add them in later. I just
> don't see anything in the class's interface that will let me do that.
>
> Thanks,

You've limited the resultset to 100 rows, of course count will return
100 or less!
What Peter told you is to keep an unrestricted resultset around:

my $rs_unrestricted = $db->resultset('Employee::Job')->search_rs({
     period =>  '2010-02-28',
});

my $rs_restricted = $rs_unrestricted->search_rs(undef, {
     rows =>  100,
     offset =>  100,
});

Now you can do $rs_unrestricted->count;


*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*
T-Systems Austria GesmbH   Rennweg 97-99, 1030 Wien
Handelsgericht Wien, FN 79340b
*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*
Notice: This e-mail contains information that is confidential and may be privileged.
If you are not the intended recipient, please notify the sender and then
delete this e-mail immediately.
*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*