Matt S Trout wrote:
> SELECT my.a, my.b FROM my_table my WHERE spork = 1
>
> and that would become
>
> {
> select => [ [ -name, 'my', 'a' ], [ -name, 'my', 'b' ] ],
> from => [ [ -alias, 'my_table', 'my' ] ],
> where => [ [ -op, '=', [ -name, 'spork' ], [ -bind, 1 ] ] ],
> }
>
> which is ... spectacularly ugly, but I -think- explicit enough.
[snip]
No kidding thats ugly. Would there be shortcuts for common operations
(maybe just in DBIC, not SQL::A itself) such as just `select these
cols'? such as:
{ select => [qw/a b/], ... }
Ash
_______________________________________________
List: http://lists.rawmode.org/cgi-bin/mailman/listinfo/dbix-class
Wiki: http://dbix-class.shadowcatsystems.co.uk/
IRC: irc.perl.org#dbix-class
SVN: http://dev.catalyst.perl.org/repos/bast/trunk/DBIx-Class/
Searchable Archive: http://www.mail-archive.com/[email protected]/
