Re: Simplifying queries in DBI

What have you tried and how did it (not) work?

CountZero

A program should be light and agile, its subroutines connected like a string of pearls. The spirit and intent of the program should be retained throughout. There should be neither too little or too much, neither needless loops nor useless variables, neither lack of structure nor overwhelming rigidity." - The Tao of Programming, 4.1 - Geoffrey James

My blog: Imperial Deltronics

Comment on Re: Simplifying queries in DBI

Replies are listed 'Best First'.
Re^2: Simplifying queries in DBI by neilwatson (Priest) on Mar 15, 2014 at 15:37 UTC
I was hoping to use place holders, but I don't see any way for the place holders to also contain the text beyond the values. At best I can run a loop to build the string for all the LIKE bits, but it doesn't seem to offer a good gain. Example: `if ( $query{hostname} ) { $query = $query . " AND host_name LIKE '$query{hostname}' ESCAPE +'!'"; } if ( $query{ip_address} ) { $query = $query . " AND ip_address LIKE '$query{ip_address}' ESCA +PE '!'"; } # etc...` [download] Neil Watson watson-wilson.ca	[reply] [d/l]

Replies are listed 'Best First'.

Re^2: Simplifying queries in DBI
by neilwatson (Priest) on Mar 15, 2014 at 15:37 UTC

I was hoping to use place holders, but I don't see any way for the place holders to also contain the text beyond the values. At best I can run a loop to build the string for all the LIKE bits, but it doesn't seem to offer a good gain.

Example:

  if ( $query{hostname} )
  {
     $query = $query . " AND host_name LIKE '$query{hostname}' ESCAPE 
+'!'";
  }
  if ( $query{ip_address} )
  {
     $query = $query . " AND ip_address LIKE '$query{ip_address}' ESCA
+PE '!'";
  }
# etc...
[download]

Neil Watson
watson-wilson.ca

[reply]
[d/l]