<font size=2 face="sans-serif">I have gone through all that, tried a bunch
of different ways of going at it and still can't get the results I need.
If these docs had actual explanations of what it is doing and why and how
I would have a much better time of it. There are so many huge areas where
they just drop code on the page and walk away expecting that you already
understand what they were thinking when they wrote it. While the correlated
subqueries section seems to be on the right track, the example doesn't
do what I need and there is no real expansion of the idea/methodology.
It amazes me that nobody has ever needed a total of rows in one table based
on a key from another table. It is very simple in raw sql, but I cannot
even get that to work in DBIx::Class. </font>
<br>
<br>
<br>
<table width=100%>
<tr valign=top>
<td><font size=1 color=#5f5f5f face="sans-serif">From:</font>
<td><font size=1 face="sans-serif">"Daniel J. Luke" <dluke@geeklair.net></font>
<tr valign=top>
<td><font size=1 color=#5f5f5f face="sans-serif">To:</font>
<td><font size=1 face="sans-serif">"DBIx::Class user and developer
list" <dbix-class@lists.scsys.co.uk></font>
<tr valign=top>
<td><font size=1 color=#5f5f5f face="sans-serif">Date:</font>
<td><font size=1 face="sans-serif">05/14/2012 02:14 PM</font>
<tr valign=top>
<td><font size=1 color=#5f5f5f face="sans-serif">Subject:</font>
<td><font size=1 face="sans-serif">Re: [Dbix-class] Query problem</font></table>
<br>
<hr noshade>
<br>
<br>
<br><tt><font size=2>On May 14, 2012, at 2:21 PM, Kenneth S Mclane wrote:<br>
> <br>
> my $rs = $c->model('ORANGES::Account')->search_rs(undef,
{ <br>
> join =>
{ servers => 'subs' }, <br>
> select =>
[ { count => 'subsystem_id' } ], <br>
> as => [
qw/ num_subs / ], <br>
> group_by =>
[ qw/ account_code subs.server_id server_name server_type os_name
/ ], <br>
> rows =>
15, <br>
> page =>
$page, <br>
> order_by =>
['account_code', 'server_name'], <br>
> }); <br>
> <br>
> But the SQL looks like it is getting closer to what I need: <br>
> <br>
> SELECT <br>
> s.server_id,
<br>
> a.account_code, <br>
> s.server_name, <br>
> s.server_type, <br>
> s.os_name, <br>
> (select count(*) from
server ss, subsserystem sb <br>
>
where ss.server_id = sb.server_id <br>
>
and ss.server_id = s.server_id) as num_subsystems
<br>
> FROM <br>
> account a, <br>
> server s <br>
> WHERE <br>
> and a.account_id = s.account_id
<br>
> order by a.account_code,
s.server_name" <br>
> <br>
> I have exhausted all the docs I can find<br>
<br>
Does this help?<br>
<br>
</font></tt><a href="http://search.cpan.org/dist/DBIx-Class/lib/DBIx/Class/Manual/Cookbook.pod#Subqueries"><tt><font size=2>http://search.cpan.org/dist/DBIx-Class/lib/DBIx/Class/Manual/Cookbook.pod#Subqueries</font></tt></a><tt><font size=2><br>
<br>
I also found reading through the actual DBIx::Class (and SQL::Abstract)
code illuminating when first looking at using DBIx::Class for some stuff.<br>
<br>
> and if I can't get this count of subsystems relater to servers to
work I will have to dump this as a feasible development platform.<br>
<br>
you know you can use strait SQL with DBIx::Class too if you need to (although
it's better if you don't):<br>
<br>
</font></tt><a href="http://search.cpan.org/dist/DBIx-Class/lib/DBIx/Class/Manual/Cookbook.pod#Arbitrary_SQL_through_a_custom_ResultSource"><tt><font size=2>http://search.cpan.org/dist/DBIx-Class/lib/DBIx/Class/Manual/Cookbook.pod#Arbitrary_SQL_through_a_custom_ResultSource</font></tt></a><tt><font size=2><br>
<br>
> I'm really hoping someone can come up with a concrete answer to do
this. This is one of those things never addressed directly in any of the
docs. If I had a example to work with I could figure it out, but I'm flying
blind here.<br>
<br>
There's not always an easy example that just shows you what you need to
do - sometimes you have to understand how things work instead of just copy+paste+modify...<br>
<br>
--<br>
Daniel J. Luke
<br>
+========================================================+
<br>
| *---------------- dluke@geeklair.net ----------------* |
<br>
| *-------------- </font></tt><a href=http://www.geeklair.net/><tt><font size=2>http://www.geeklair.net</font></tt></a><tt><font size=2>
-------------* |
<br>
+========================================================+
<br>
| Opinions expressed are mine and do not necessarily |
<br>
| reflect the opinions of my employer.
|
<br>
+========================================================+<br>
<br>
<br>
<br>
<br>
_______________________________________________<br>
List: </font></tt><a href="http://lists.scsys.co.uk/cgi-bin/mailman/listinfo/dbix-class"><tt><font size=2>http://lists.scsys.co.uk/cgi-bin/mailman/listinfo/dbix-class</font></tt></a><tt><font size=2><br>
IRC: irc.perl.org#dbix-class<br>
SVN: </font></tt><a href="http://dev.catalyst.perl.org/repos/bast/DBIx-Class/"><tt><font size=2>http://dev.catalyst.perl.org/repos/bast/DBIx-Class/</font></tt></a><tt><font size=2><br>
Searchable Archive: </font></tt><a href="http://www.grokbase.com/group/dbix-class@lists.scsys.co.uk"><tt><font size=2>http://www.grokbase.com/group/dbix-class@lists.scsys.co.uk</font></tt></a><tt><font size=2><br>
<br>
</font></tt>
<br>
<br>