On 4/12/06, Paul Winkler [EMAIL PROTECTED] wrote:
Functionally, we are missing some important testables:* we have no way to verify that these queries are syntactically correct sql.* we have no way to verify that these queries behave as expected against
a sample data set.How do people test this
Ok, here it is. It is a demo product, which has one class,
GenerateInsert, which will generate an insert based on your parameters.
I've also written a small test, which tries to show what I would do:
test that given the proper parameters, it will generate the proper
string. The case I'm showing is
Paul Winkler wrote at 2006-4-12 12:32 -0400:
...
Functionally, we are missing some important testables:
...
* we have no way to verify that these queries behave as expected against
a sample data set.
If you want to test this, then do it. It will also cover all
other test requirements (e.g.
This is a very general question: I'm looking for ideas on how to
effectively test dynamically generated sql queries.
Both unit and functional test ideas welcome.
We have a bunch of views (in the zope 3 / Five sense, but that's not
really relevant) which typically construct a
The problem is what you want to test. I'm not familiar with Zope 3,
therefore I'm talk on the base of ZSQLMethod.SQL.SQL from Zope 2.
If I understand correctly, you've some high level construct which
creates an nvSQL instance. Now, if you put yourself at the end of the
line, what you need to do
--On 12. April 2006 12:32:29 -0400 Paul Winkler [EMAIL PROTECTED] wrote:
How do people test this sort of thing? Do you go whole-hog and
fire up MySQL or whatever? Or use gadfly? sqlite? or what?
I've had a project some yrs ago where we had to parse some kind of query
language and
On Wed, Apr 12, 2006 at 06:51:18PM +0200, Marco Bizzarri wrote:
The problem is what you want to test. I'm not familiar with Zope 3,
therefore I'm talk on the base of ZSQLMethod.SQL.SQL from Zope 2.
If I understand correctly, you've some high level construct which creates an
nvSQL instance.