> -----Original Message-----
> From: Shane McEwan [mailto:[EMAIL PROTECTED]
> Sent: Tuesday, October 31, 2006 12:33 AM
> To: [email protected]
> Subject: Re: [Dbix-class] Use of ->resultset mandatory?
>
> On Mon, 2006-10-30 at 21:43 +0000, Steven Mackenzie wrote:
> > In my quest to avoid typing resultset(''), is there a reason why I
> can't
> > have source_name create accessors in the $shema object, eg,
> > $schema->MyBest->search;
>
> I'm also new to DBIx::Class after using CDBI for a couple of years and I
> had the exact same question.
>
> I saved myself some typing by doing:
>
> my $MyBest = $schema->resultset('MyBest');
> $MyBest->search();
>
> It seems to work but I've only done very basic stuff so far. Please let
> me know if what I'm doing is stupid and will break when I try to do
> something more complicated.
>
> I still haven't got my head around exactly what a result set is and what
> I can do with it. I subscribed to the mailing list to hopefully see some
> examples of what other people are doing. So far this is the first
> question I've been able to understand. :-)
>
> As I learn more I may be tempted to write a CDBI to DBIC transition
> guide.
>
> Shane.
ResultSets are the most brilliant idea ever ;-)
A ResultSet as an object which creates sql queries for you and returns the data.
The advantage is that the sql isn neither generated nor executed when you
create a rs but not until you fetch data with ->next, ->all or by using it list
context (e.g. @cds = $rs_favorite_cds;).
This makes it possible to generate a resultset and extend it as often as you
like to prefetch additional relationships, change the search criteria and so on.
For example you can use dbic in catalyst and filter on different things:
url: /requests/mine/open:
in requests: create a resultset with all requests and store it in the
stash
in mine: extend it to filter only the requests of the logged in user
in open: extend it again to filter on only open requests
I'm pretty sure this works wonderful together with ChainedActions, but it
wasn't born when I coded my last cat app.
-Alex
*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*
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.
*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*
_______________________________________________
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/[email protected]/
