Re: [Webware-discuss] MiddleKit Problems

[Chuck E. <Chu...@ya...>]

At 10:08 AM 10/5/2001 -0400, Aaron Held wrote:
>callLogQuery.addWhereClause( callLogTable.State, "NJ", QueryBuilder.EQUALS)
>callLogQuery.addWhereClause( "extention", "1111", QueryBuilder.EQUALS)
>callLogQuery.addWhereClause( "duration", "60", QueryBuilder.GREATER_THAN)
>
>I'm actually trying to figure out the best way to handle this type of 
>query builder in webware/python today.  I'm building a
>reporting engine and I want a clean set of classes to handle the query.

Here is how you do server side queries in MiddleKit:

store.fetchObjectsOfClass('CallLog', clauses='where state="NJ" and 
extension="1111" and duration="60"')

I think the clauses= approach is a lot easier to read and write than the 
multiple calls to create WHERE clauses. The potential downside is that this 
is direct SQL code, however this kind of simple SQL code is highly portable.

Note that the above call will also pick up subclasses of CallLog if there 
are any. If for some reason you didn't want that, you could add isDeep=1 to 
the call.


-Chuck