[Dbix-class] clear prefetch in resultset.

[luke saunders]

On 7/6/07, brett gardner <brett at clientcomm.com.au> wrote:
>
> Any pointers / examples on how to write a test file?


I just added a test to t/88result_set_column.t in SVN to illustrate your
problem. It was a bit messy since SQLite doesn't actually barf, but it
should be okay. What DB are you using?

So you are saying that you cannot undo the prefetch?
>
> If I do the following
>
> ---------------------
> my $rs =3D $app->get_rs_with_prefetch();
>
> $rs =3D $rs->search(undef,{prefetch=3D>undef});
>
> my $item =3D $rs->next;
> ---------------------
>
> Calling $rs->next still includes the prefetch columns.


That would simply merge undef with whatever the old prefetch clause was. To
clear prefetch entirely you would have to do $rs->{attrs}->{prefetch} =3D
undef, but you probably don't want to be doing that.

Fortunately, you shouldn't need to worry about it now since I've fixed the
problem. It'll be on CPAN with the next point release but it would be useful
if you could grab the latest version from SVN now and check to see if your
problem persists. You can get it like so:

svn co http://dev.catalystframework.org/repos/bast/trunk/DBIx-Class


> Matt S Trout wrote:
> > On Thu, Jul 05, 2007 at 12:49:38PM +1000, brett gardner wrote:
> >
> >> Is there anyway to set prefetch to empty on a resultset that is created
> >> elsewhere?
> >>
> >> I have a method in my app that returns a resultset and 99% of the time
> I
> >> want a particular relationship to be prefetched. But in one particular
> >> instance I do not.
> >>
> >> I am trying to call $rs->get_column('timestamp_entered')->min. But the
> >> query is barfing because it adds the prefetched relationship fields to
> >> the query.
> >>
> >
> > That's a bug in the way get_column is implemented, then. If you could
> put
> > together a test file for us, I can get it fixed for the next point
> release.
> >
> >
>
> _______________________________________________
> List: http://lists.rawmode.org/cgi-bin/mailman/listinfo/dbix-class
> Wiki: http://dbix-class.shadowcatsystems.co.uk/
> IRC: irc.perl.org#dbix-class
> SVN: http://dev.catalyst.perl.org/repos/bast/trunk/DBIx-Class/
> Searchable Archive:
> http://www.mail-archive.com/dbix-class@lists.rawmode.org/
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.scsys.co.uk/pipermail/dbix-class/attachments/20070709/c7f=
3f14f/attachment.htm