Re: Method Names (was: Stolen Ideas)

[prev] [thread] [next] [Date index for 2004/08/12]

> > Then tackle the whole using database functions like sysdate elegantly in
> > CDBI :)
>
> Syntax, people, give me syntax!

Ok, then how about this:

For using functions upon the left hand side of the "where" clause, for
example
if I want to implement:

select *
  from table
where upper(first_name) = ?;

I do it like:

my $builtin = q[upper(first_name)];
my @rows = $class->search(\$builtin => "BEATLES");

If one of the keys is a reference, pass it to dbi without putting
it in quotes.


For stuff on the right side of the equals sign (for both queries
and updates)

just make the right hand side a reference

i.e.

my $sysdate = q[sysdate];
$row->set(last_modified_date=>\$sysdate);

or for a select or delete

my $str = q[sysdate - 15];
my @rows = $class->search(last_modified_date => \$str);

Otherwise I think you will be faced with doing something like
adding a tag to indicate to CDBI not to mess with the value.  Something
like:

my @rows = $class->search(last_modified_date => q[<PRESERVE>sysdate - 15];

Which I personally think sucks.

Thanks
Jay