[storm] Building large queries with Storm ORM

[James Henstridge]

On 26/10/2007, nhytro-python at web.de <nhytro-python at web.de> wrote:
> I have to code an extended search for a site, the search criteria can be built from large groups of values which are retrieved from checkboxes. I have 4 groups and each group has at least 10 checkboxes, each group result has to be joined with the next to acheive the final result.
>
> My question is, how can I build such a query using the Storm ORM to search tables? Some of the values in the checkboxes would be "None" so I cant have a definite number of substitution Strings, and joong all of them afterwards makes my head spin.
>
> Doe someone have a snippet for me on how I could acheive this?

You can build up queries using Storm's expression logic.  For
instance, if I was building a query from a search form, I might do
something like this:

    conditions = []
    if field1_values:
        conditions.append(In(Table.field1, field1_values))
    if field2_values:
        conditions.append(In(Table.field2, field2_values))
    ...
    results = store.find(Table, And(*conditions))

Is this the sort of thing you were wondering about?

James.