[Dbix-class] Multi-table search - how to?

[Will Hawes]

On 08/05/07, RA Jones <ra.jones at dpw.clara.co.uk> wrote:
> Hi folks,
>
> I have a large application with many db tables (nothing unusual there).
> One of the requirements is to retrieve data across multiple tables. As
> there is no obvious 'main' table to base the query on, I tried to create
> a new schema (GetAll) not based on any table, along the lines described
> in a patch to the DBIC Manual Cookbook (Arbitrary SQL through a custom
> ResultSource - http://dev.catalyst.perl.org/trac/bast/changeset/3263).
> It failed: Couldn't instantiate component "MyApp::Model::Schema",
> "Cannot load schema class 'Schema': DBIx::Class::Schema::load_classes():
> Can't locate object method "result_source_instance" via package
> "Schema::GetAll" at line .... etc.
>
> I haven't shown my code as I don't think this is the right way to go
> about it. Basically I want the DBIC equivalent of:
>
> select var1, var2, var3, var101, etc
> from table1 a
>    left join table2 b on a.id = b.id
>    left join table3 c on a.id = c.id
>    etc
> where a.var1 = 'foo' and c.var10 = 'bar'
>
> It's probably easier than I imagine....

Should be as easy as this:

http://search.cpan.org/dist/DBIx-Class/lib/DBIx/Class/Manual/Cookbook.pod#Using_joins_and_prefetch