Project

General

Profile

« Previous | Next » 

Revision 9333

Added by Aaron Marcuse-Kubitza about 11 years ago

lib/sh/db.sh: mk_select: constructed queries: support WHERE clause using $filter

View differences:

db.sh
19 19 
alias mk_table_esc='declare table_esc; mk_esc_name table'
20 20 

  		




  21
  21
  
    
alias mk_select='mk_table_esc


  		




  22
  
  
    
declare query="${query:-SELECT * FROM $table_esc}${limit:+ LIMIT $limit}"'


  		




  
  22
  
    
declare query="$(rtrim "${query:-SELECT * FROM $table_esc${filter:+


  		




  
  23
  
    
WHERE $filter


  		




  
  24
  
    
}}${limit:+


  		




  
  25
  
    
LIMIT $limit}")"


  		




  
  26
  
    
'


  		




  23
  27
  
    

  		




  24
  28
  
    
fi # load new aliases


  		




  25
  29
  
    
if self_being_included; then


  		












Also available in:  Unified diff