Re: [Numpy-discussion] query to array

On 1/31/07, Tom Denniston wrote:

i would do something like the following. I don't have your odbc library so I mocked it up with a fake iterator called "it". This example would be for a two column result where the first is an int and the second a string. Note it creates a recarray which you can have match you database column names if you want to generalize the function. All you need to provide is the dtype equivalent to your query result layout.

In [2]: import numpy

In [3]: it = iter([(1,'String1'), (2, 'String2')])

In [4]: dtype = numpy.dtype([('intvalue', int), ('stringcolumn', '|S20')])

In [5]: numpy.fromiter(it, dtype) Out[5]: array([(1, 'String1'), (2, 'String2')], dtype=[('intvalue', '

All this fromiter and recarray is confusing to me. But I'd like to learn. How would I hook all this up to a query?