MySQL, Python, NumPy and formatted read

[Ian Hoffman]

On May 23, 6:54 pm, Matteo Landi <landima... at gmail.com> wrote:
> I know anything about mysqldb and fetchone method, but it's easy to
> create a numpy array, given a tuple of data:
>
>
>
> >>> import numpy
>
> >>> t = ('1', '2', '3')
> >>> numpy.array(t, int)
> array([1, 2, 3])
>
> I made the assumption that mysqldb.fetchone return a tuple of strings,
> so we need to create an array by specifying the type of the needed
> values.
>
>
>
> On Mon, May 24, 2010 at 12:30 AM, Ian Hoffman <ith... at gmail.com> wrote:
> > Hello,
>
> > I'm having significant Python difficulties (and I'm new to Python).
> > I'm trying to read BLOB ASCII (numerical) data from a MySQL database
> > using MySQLdb in a formatted fashion.  The BLOB data is a sequence of
> > numbers separated by newlines (\n), like this:
> > 5
> > 6
> > 10
> > 45
> > etc.
>
> > When I read the data using the fetchone() command I get a single
> > tuple.  What I'd like is to somehow put the tuple into a NumPy array
> > with each value as one element.  Then I can continue to do some
> > numerical processing.
>
> > Any advice/help?
>
> > --
> >http://mail.python.org/mailman/listinfo/python-list
>
> --
> Matteo Landihttp://www.matteolandi.net/

The problem is the tuple is contained in a single value separated by
newlines (only a[0] has a record), otherwise I could do as you
suggest...

Isn