predicate templates

gistfile1.txt

// the query:
// foo amount:15

// first becomes an array of predicate templates

[ "${column} like '%foo%'", "${column} >= 14 and ${column} <= 16" ]

// next, we inspect the model to find which columns to search on
// and repeat each query for each property

[ [ "description like '%foo%'", "memo like '%foo%'" ], [ "amount >= 14 and amount <= 16" ] ]

// the subarrays get OR'd

[ "description like '%foo%' OR memo like '%foo%'", "amount >= 14 and amount <= 16" ]

// then the entire array gets AND'd

"(description like '%foo%' OR memo like '%foo%') AND (amount >= 14 and amount <= 16)"