[Dbix-class] me and foreign join prefixes

Matt S Trout dbix-class at trout.me.uk
Thu Sep 21 20:04:56 CEST 2006


Robert Dobbs wrote:
> Was there some discussion way back when about changing the "SELECT table 
> AS me/foreign" queries to the name of the relationship?  If the table 
> selections could be named "fromentity_torelname" it might be easier to 
> figure out deeper joins.  Well, I tried this for a bit in my own 
> muddlings but ran into character limits in MySQL pretty fast, FWIW, 
> especially in some kind of double-join against >=3 level relationships 
> via two paths with different properties.

Which I ran into already in the join code for Class::DBI::Sweet, which is why 
DBIx::Class Doesn't Do It Like That :)

-- 
      Matt S Trout       Offering custom development, consultancy and support
   Technical Director    contracts for Catalyst, DBIx::Class and BAST. Contact
Shadowcat Systems Ltd.  mst (at) shadowcatsystems.co.uk for more information

+ Help us build a better perl ORM: http://dbix-class.shadowcatsystems.co.uk/ +



More information about the Dbix-class mailing list