[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