I have googled for this, as far as I can tell DBIx::Class does not support
complex joins. An example of which is below.

select star.id,star.name,body.id,body.name,building.class,empire.name
from star
LEFT JOIN probes
  ON star.id = probes.star_id
  AND probes.alliance_id=26
LEFT JOIN body
  ON star.id = body.star_id
  AND probes.id is not null
LEFT JOIN empire
  ON body.empire_id = empire.id
LEFT JOIN building
  ON body.id = building.body_id
  AND building.class='Lacuna::DB::Result::Building::Permanent::Ravine'
WHERE star.x > -10
AND star.x < 10
AND star.y > -10
AND star.y < 10
group by body.id

Is there any way that this could be implemented in DBIx::Class or do I have
to drop down to SQL and implement a custom ResultSource?

(and in case you are wondering, this is to do with the open source project
at https://github.com/plainblack/Lacuna-Server-Open )

-- 
Kind Regards
Iain
_______________________________________________
List: http://lists.scsys.co.uk/cgi-bin/mailman/listinfo/dbix-class
IRC: irc.perl.org#dbix-class
SVN: http://dev.catalyst.perl.org/repos/bast/DBIx-Class/
Searchable Archive: http://www.grokbase.com/group/dbix-class@lists.scsys.co.uk

Reply via email to