[TIP] database regression testing

Satchidanand Haridas satchit at zope.com
Wed Apr 9 10:44:28 PDT 2008

While I don't have any specific suggestions for testing SQL, I've a  
question: Does your database layer contain business logic? If not and  
your SQL queries are for mainly for simple CRUD operations, one way  
(that you may have already considered) might be to write a python  
wrapper around your SQL queries and then testing the wrapper using  
python unit-testing framework. It should be possible to test stored  
procedures in this manner as well depending on which database/database- 
adapter you are using. Of course you won't have the benefit of code- 
coverage tools in this case, but you have tests none-the-less, which  
is always good.


On Apr 9, 2008, at 10:41 AM, Nate Lowrie wrote:
> I am in the middle of developing a complex business application for a
> client.  I am using an agile approach for development.  I have almost
> completed Iteration 2.  My weak link now is the database.  I want to
> take an agile approach to it, however my knowledge of test tools for
> databases is somewhat limited.  Do we have something similar to
> SQLUnit in Python?  Any recommendations?  I would prefer not to write
> Java if I can avoid it... If we have something that could interface
> with Unittest that would be great.
> Nate L.
> _______________________________________________
> testing-in-python mailing list
> testing-in-python at lists.idyll.org
> http://lists.idyll.org/listinfo/testing-in-python

Satchidanand Haridas
Software Engineer
Zope Corporation

More information about the testing-in-python mailing list