Skip Menu |

This queue is for tickets about the Maypole CPAN distribution.

Report information
The Basics
Id: 6482
Status: new
Priority: 0/
Queue: Maypole
People
Owner: Nobody in particular
Requestors: jester [...] panix.com
Cc:
AdminCc:
Bug Information
Severity: Wishlist
Broken in: (no value)
Fixed in: (no value)

History Show all quoted text
  Wed Jun 02 11:35:13 2004 JESTER [...] cpan.org - Ticket created
Subject: More flexible searching
Currently the search mechanism in CDBI.pm simply maps search terms with "LIKE". More flexible searches should be possible, using different search operators, presumably using Class::DBI::AbstractSearch. This is perhaps not crucial, as anyone needing a really custom search could override the search() method, but it would be nice if an alternative were available for common search needs.
  Thu Nov 10 19:55:44 2005 peterspeltz [...] cafes.net - Correspondence added
From: peterspeltz [...] gmail.com
[JESTER - Wed Jun 2 11:35:13 2004]: Some helper methods for writing sql would be nice. For example if you want to do a join search , One thing you need is the Essential columns list prefixed with an alias. Example : Search for Beer at a Brewery. Beer essential cols are (id , name, brewery ). Whatever any other cirucmstances , we will need this : "Select beer.id, beer.name, beer.brewery FROM . . ." So a nice CDBI helper method may be : sub cols_to_select { my ($self) = @_; my $moniker = return join ( ', ', map { cheers