[CDBI] Make CDBI go fast

Jay Strauss me at heyjay.com
Thu Feb 15 09:20:27 GMT 2007


<Not a speed wish>

I always thought it would be nice to have a syntax for using database
specific functions within the generic CDBI syntax, instead of having
to litter my code with set_sql statements.

For example (oracle) :
set_sql(expiration_dates=>qq{
        select distinct(to_char(expirationtms,'yyyy/mm/dd')) expirationtms
          from security
          where underlyingsecurityid = ?
          and expirationtms >= sysdate});

I'd love to be able to use "to_char", "to_date", "sysdate" within CDBI

my 2 cents
Jay



More information about the ClassDBI mailing list