Re: [Dbix-class] RE: SQL Generation with SQL::DB

2007-09-12 Thread Matt S Trout
On Mon, Sep 10, 2007 at 01:43:27PM +0100, Jess Robinson wrote: > > On Fri, 7 Sep 2007, Dami Laurent (PJ) wrote: > > >Hi all, > > > >I have followed with interest the discussion on the new SQL::DB module > >by Mark Lawrence, and would like to comment a few points. > > > >First, just to make clear

Re: [Dbix-class] RE: SQL Generation with SQL::DB

2007-09-12 Thread Mark Lawrence
On Tue Sep 11, 2007 at 02:40:03PM +0200, Emanuele Zeppieri wrote: > Supposing you get the usual hash at runtime: > > my $form = { > name => '= Mark', > age=> '<= 30' , > height => '> 180' , > weight => '< 80' > }; > > with SQL::DB (*and* string manipulations) the code would

Re: [Dbix-class] RE: SQL Generation with SQL::DB

2007-09-11 Thread Emanuele Zeppieri
Emanuele Zeppieri wrote: my $expr; eval '$expr = ' . $full_expr_str; It could be just: my $expr = eval $full_expr_str; ___ List: http://lists.rawmode.org/cgi-bin/mailman/listinfo/dbix-class IRC: irc.perl.org#dbix-class SVN: http://dev.catalyst.perl

Re: [Dbix-class] RE: SQL Generation with SQL::DB

2007-09-11 Thread Emanuele Zeppieri
Mark Lawrence wrote: That's why I was talking about string concatenations to build the whole expression *before* evaluating it: though I don't like it in such a situation it's even preferable since it saves you from (pre-)parsing the expression [...] Could you perhaps give an example of the

Re: [Dbix-class] Re: SQL Generation with SQL::DB

2007-09-10 Thread Emanuele Zeppieri
A. Pagaltzis wrote: * Emanuele Zeppieri <[EMAIL PROTECTED]> [2007-09-07 14:20]: 1. If you have both &'s and |'s in your (full) expression, how can you find the correct order to evaluate the various subexpressions? How do you choose between [] and {} and put them in the right order when you bu

Re: [Dbix-class] RE: SQL Generation with SQL::DB

2007-09-10 Thread Jess Robinson
On Fri, 7 Sep 2007, Dami Laurent (PJ) wrote: Hi all, I have followed with interest the discussion on the new SQL::DB module by Mark Lawrence, and would like to comment a few points. First, just to make clear from where I speak, I'm not a user of DBIx::Class, but author of another ORM named DB

[Dbix-class] RE: SQL Generation with SQL::DB

2007-09-07 Thread Darren Duncan
At 11:50 AM +0200 9/7/07, Dami Laurent (PJ) wrote: Matt Trout mentioned a couple of weeks ago in this list a project to improve SQL::Abstract, but as far as I know this hasn't started yet. It's possible that Matt is waiting for me to do something about this, since I promised him the moon and s

[Dbix-class] Re: SQL Generation with SQL::DB

2007-09-07 Thread A. Pagaltzis
* Emanuele Zeppieri <[EMAIL PROTECTED]> [2007-09-07 14:20]: > 1. If you have both &'s and |'s in your (full) expression, how > can you find the correct order to evaluate the various > subexpressions? How do you choose between [] and {} and put them in the right order when you build data structures

Re: [Dbix-class] RE: SQL Generation with SQL::DB

2007-09-07 Thread Mark Lawrence
On Fri Sep 07, 2007 at 02:12:31PM +0200, Emanuele Zeppieri wrote: > Mark Lawrence wrote: > > >foreach my $field ($form->param) { > >my @vals = $form->param($field) or next; > >$expr= $expr & ( @vals > 1 ? $table->$field->in(@vals) > > :

Re: [Dbix-class] RE: SQL Generation with SQL::DB

2007-09-07 Thread Emanuele Zeppieri
Mark Lawrence wrote: foreach my $field ($form->param) { my @vals = $form->param($field) or next; $expr= $expr & ( @vals > 1 ? $table->$field->in(@vals) : $table->$field == $vals[0] ); } Mark, this is more or less what I was ask

Re: [Dbix-class] RE: SQL Generation with SQL::DB

2007-09-07 Thread Mark Lawrence
On Fri Sep 07, 2007 at 11:50:46AM +0200, Dami Laurent (PJ) wrote: > somewhere else ... but so far, this is where people debate about ORM > design, so let's stay here for the moment and thank the DBIC list for > hosting this thread. I should also say thanks to all for putting up with the noise. I

[Dbix-class] RE: SQL Generation with SQL::DB

2007-09-07 Thread Dami Laurent (PJ)
Hi all, I have followed with interest the discussion on the new SQL::DB module by Mark Lawrence, and would like to comment a few points. First, just to make clear from where I speak, I'm not a user of DBIx::Class, but author of another ORM named DBIx::DataModel, that also relies on SQL::Abstract