Re: Extending Class::DBI's search abilities

[prev] [thread] [next] [Date index for 2004/07/26]

On Mon, Jul 26, 2004 at 09:58:23AM +0100, Jack Challen wrote:
> 
> Hi,
> 
> I'm trying to make Class::DBI's searches a little more powerful (I want to 
> add regex-based searches with MySQL, and also to allow multiple 
> constraints on the same column - e.g. "Find me all foo where bar > 3 and 
> bar < 5").

Have you tried Class::DBI::AbstractSearch?

> Anyway, where does the sql_Retrieve method get defined? I've grep'd my 
> tree of installed Perl modules, and I can't see it anywhere.
> I'm not quite sure what it does, and therefore whether I need to use it.

Its auto-generated.  It gets defined in Class::DBI like this :

__PACKAGE__->set_sql(Retrieve => <<'');
SELECT __ESSENTIAL__
FROM   __TABLE__
WHERE  %s

Colm