Any more thoughts on the LIMIT/extra SQL issue?

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

Has anyone thought any more about the limiting issue?

Tony, I like Todd's idea best:

quote:
Have modules register a "search_handler" which _do_search() can then
pass the various fragments of the SQL to ("SELECT * FROM", "WHERE
.."), along with the $search_opts hash.  The search handlers modify
the fragments and pass them back.  Search goes down the chain until
all registered search_handlers are done.

This would allow for CDBI::Plugin modules to add features to search(),
as well as specific DB subclasses and CDBI could ignore everything in
$search_opts it doesn't know about.  Or maybe have the classes remove
items from $search_opts that they deal with and throw an exception if
there's any left at the end of the chain.
end quote

Would let you keep C::DBI cleaner and let us all subclass to our 
weird-sql-heart's content.  :)


-jason scott gessner
     jason@xxxxxxxx.xxx