[Zope] - Extending SQLtest

[David White]

Would it be possible to 'extend' the SQLtest class to be able to
dynamically
generate more things than just 'in' and '='?  I'd like to be able to put
the following
in int type textboxes:

'1-10'
will generate the SQL fragment:

(column BETWEEN 1 AND 10).

'1,3,5-12,17-28,34,37,39'
will generate the SQL fragment:

((column IN (1,3,5,34,37,39)) OR (column BETWEEN 5 AND 12) OR (column
BETWEEN 17 AND 28))

'> 34'
will generate the SQL fragment (note: all numeric comparisons should be
available (>,<,>=,<=,!=, etc):

(column > 34)

In text type textboxes id like to be able to put the following:

'Z%'

and have it generate:

(column LIKE 'Z%')

And finally in date type textboxes I'd like to be able to specify a list
or range of dates
(similar to the int type above) with the exception that to specify a
date range you wouldn't
be able to use the '-' character.  You could use something like 'to'
like this:

'01-JAN-1999 to 01-MAR-1999'


Note that none of these should be very difficult to implement.  I
actually have a web based database
app (connecting to Oracle and written in Perl) which does all of this
(and more).  All my queries are
dynamically generated using the above rules.  I've become VERY
interested in Zope as of late and
am trying to push for our Apps to be more Product centric and Zope seems
heaven-sent, so hence
my interest in porting some/all of our apps to Zope Products.  Getting
everyone else to see that vision
is another matter...

My question is whether this would be a generally useful addition to
SQLtest or if it should be
created as an Extension Module?

Dave

--
----------------------------------------------------
David R. White          Raytheon Electronic Systems
Process Support                      (508) 440-2087
528 Boston Post Rd.
Sudbury, MA 01776
davew@ed.ray.com
----------------------------------------------------