[Zope] general queries

[Thomas Weiner]

Marco Guidi schrieb:

[...]

> 2. Depending on how the user fills the form, the where clause may
>    require some different operators (>, <, and or, and so on). is there
>    a way to generalize this (may be the creation of a dictionary
>    in the REQUEST with the where operators needed by the specific form ?).

Well .. I did this using properties for the SQL operators.

In my search folder I defined some token and text properties:

search_fields a list containing the names of the fields of my SQL table
I want to let show up in the search form (all are string - fields).

Critops a list with the operators: like like like = < >

Critbez a list with translations for the operators for showing up in a
select box in the search form:
contains begins_with ends_with is_eqal less_then greater_then

start_op a _text_-property containing wildcards for the sql method (note
that the empty lines are necessary):
%

%



end_op the same as start_op but a little different ;):
%
%




the search_form is a DTML Method where I define a select box for the
fieldnames <!--#in search_fields-->, a second select box with critbez,
an input field for text and an other select box with NONE / AND / OR
values for further search - requests (I put this in a loop collecting
the values in lists)

the SQL - method looks this way:

Arguments: Crit1_Fieldname:list Crit1_search:int:list
Crit1_FieldValue:list Crit1_and_or:list 

select *
from adr
<!--#if Crit1_Fieldname-->
where
                 
 <!--#in "loop_range(max=5)"-->
  <!--#unless "Crit1_Fieldname[_['sequence-index']]=='NONE'"-->
     <!--#var "Crit1_Fieldname[_['sequence-index']]"--> 
     <!--#var "Critops[(Crit1_search[_['sequence-index']])]"--> 
     '<!--#var"start_op[(Crit1_search[_['sequence-index']])]"--><!--#var
"Crit1_FieldValue[_['sequence-index']]"--><!--#var"end_op[(Crit1_search[_['sequence-index']])]"-->'
     <!--#if "Crit1_and_or[_['sequence-index']]<>'NONE'"-->
       <!--#var "Crit1_and_or[_['sequence-index']]"-->
     <!--#/if "Crit1_and_or[_['sequence-index']]<>'NONE'"--> 
  <!--#/unless "Crit1_Fieldname[_['sequence-index']]=='NONE'"-->
 <!--#/in "loop_range(max=5)"-->  
<!--#/if Crit1_Fieldname--> 

loop_range is an external method for a simple loop.

Note that the code in
'<!--#var"start_op[(Crit1_search[_['sequence-index']])]"-->...
<!--#var"end_op[(Crit1_search[_['sequence-index']])]"-->' must be
written in one single line without any blanks in it.

I don't know whether this is really elegant, but for me it works fine.

thomas
-- 
fon: ++49 (0)40 42878 3781
fax: ++49 (0)40 42878 2728