Actually, the code looks like a clever expansion on my example, in PyCon 2007 (Revised) .

"But wait," you say. "Creating a pivot table in Python?"

Of course. Spreadsheets can create pivot tables from dimensionally normalized data. However, getting the data in this form is often challenging and if there is …

In one form, the question is "How do we handle the [X] transaction in the warehouse?" Another form of the question is "What do we do when [Y] changes?" The third form is less clear, but essentially the same: "How do we maintain [Z] in the warehouse?"

All of these …

I do a fair amount of manual refactoring. I've used WebSphere Studio (Eclipse) to do some automated refactoring, so I have some experience in using IDE's which exploit Java's static type-checking.

However, the question of type checking in a dynamic language is interesting. I don't use a sophisticated IDE for …

Simple object persistence (i.e., serialization to a file system) is what pickle, marshal and shelve do.

However, here's the next thing of some interest OODB's.

Zope's ZODB . The original OODB for Python, the backbone of Zope.

buzhug : "a fast, pure-Python database engine, using a syntax that Python programmers should …

This is something that elevates Doctest into the realm of Pattern. Perhaps even above that.

The idea is so elegant: the document is the test, and the test procedure is the document.

There's a DRY clarity to the whole thing that is rather exciting. It is an elegant application of …

Ian Bicking: A Blog http://blog.ianbicking.org/, provided some info on Py3K and Python Introspection http://blog.ianbicking.org/introspecting-expressions-in-py3k.html.

For me, the interesting part was his summary of Object-Relational Mapping. Mr. Bicking identifies two broad approaches: lambda introspection and operator overloading.

A number of testing frameworks were used. The Agile Testing tutorial provides a path through the toolsets, showing what you can do, and how you should do it.

Unit Testing: [Nose ], <{filename}/blog/2005/11/2005_11_09-compare_and_contrast_round_3_revised.rst>

Acceptance Testing: [FitNesse ]

Regression Testing: [TextTest ]

Functional Testing: [twill ]. A thorough analysis is …

testresources http://www.robertcollins.net/unittest/testresources/ purpose appears to be to manage the resources used by a test suite.

Adding this resource management context extends the Test Suite to optimize tests around the resources. This can reshuffle the TestCases to minimize SetUp's. This can be useful in contexts where …

SubUnit's http://www.robertcollins.net/unittest/subunit/ purpose appears to be to manage testing via subprocesses.

Consequently, it can run external tests not in Python, it can fork a subprocess to manage the Fixture in an isolated process.

Adding this subprocess execution context extends the Test Runner implementation of the …

Trial is not really a stand-alone unit test framework. It is an extension to unittest focused on the testing needs for the Twisted framework.

The Trial how-to http://twistedmatrix.com/projects/core/documentation/howto/testing.html has some information. More valuable, perhaps are the API documents http://twistedmatrix.com/documents …