I just noticed that QueryBuilder accepts multiple OR's
Then i tested other fields, and noticed the same thing.
I saw nothing about this in the docs to confirm this functionality
outright, though it is used in examples
ie:
$results= $class->get_items(
query=> [
id=> $kw_args{'id'},
id=> 100,
or=> [
'id'=> { ne => $kw_args{'c'} },
'id'=> undef,
],
or=> [
'id'=> 5,
]
],
);
i also realized a query builder behavior that didn't come through on
the docs...
or=> [
'id'=> { ne => $kw_args{'c'} },
'id'=> undef,
],
is functionally the same as
id=> {
eq=> undef ,
ne => $kw_args{'c'} }
}
in fact, the Tutorial uses this example ( under fetch objects )
or =>
[
price => 5.00,
price => { lt => 10.00 },
],
which creates the same sql as
price => {
eq => 5.00,
lt=> 5.00
}
In any event, it basically means that at some point, field=>
{ stuff } was set as an OR condition.
Which is fine - it makes perfect sense ( although it would have also
made sense to be AND conditions )
I couldn't find anything in the docs that states this though, so I
was hoping some big bold letters could say something like
field => [VALUES]
field => {CONDITIONS}
Will always create an OR join for the values and conditions.
To have a field match multiple conditions, you must use multiple
"field=>" statements
another thing i noticed, is that
id => { eq=> [ 1,2,3] }
creates
( id= 1 OR id= 2 OR id=3 )
while
id => [ 1,2,3],
creates
id IN ( 1, 2,3 )
of course they're both functionally the same... but that caught my eye
-------------------------------------------------------------------------
Using Tomcat but need to do more? Need to support web services, security?
Get stuff done quickly with pre-integrated technology to make your job easier
Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo
http://sel.as-us.falkag.net/sel?cmd=lnk&kid=120709&bid=263057&dat=121642
_______________________________________________
Rose-db-object mailing list
Rose-db-object@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/rose-db-object
