fetchall to python lists

[Joel Goldstick]

On Mon, Sep 30, 2013 at 10:58 AM, <christensen.jerome at gmail.com> wrote:

> Hi - I have some basic programming experience and new to Python. I have
> connected to SQL Server as follows:
>
> import pyodbc
> conn = pyodbc.connect('DSN=DBC')
> cursor = conn.cursor()
> cursor.execute("select measure,fin_year_no,fin_week_no,location_no,value
> from actual")
> result=cursor.fetchall()
>
> result looks like this:
>
>
>
> result[0] - ('2013', 2014, 7, 242, 96064.35)
> result[1] - ('2013', 2014, 7, 502, 18444.2)
> .... approximately 2m records
>
> Is there a way to assign the values of result to 5 lists without doing 5
> select statments one for each of the colums and then assigning it to a list
> so that:
>
>
What you have below is just result[0][0], result[0][1], etc.


list1[0] = '2013'
> list1[1] = 2014
> list1[2] = 7
> list1[3] = 242
> list1[4] = 96064.35
>
> list2[0] = '2013'
> list2[1] = 2014
> list2[2] = 7
> list2[3] = 502
> list2[4] = 18444.2
>
> and so on ...
>
> Hope someone can help. Regards Jerome
>

So what I'm trying to say is that you already have what you want.  each
tuple is contained in the out list of all of the tuples.

For brevity sake, I am acting as if the data set contained only a single
row:

>>> result =  (('2013', 2014, 7, 242, 96064.35),)
>>> result
(('2013', 2014, 7, 242, 96064.35),)
>>> result[0]
('2013', 2014, 7, 242, 96064.35)
>>> result[0][0]
'2013'
>>> result[0][1]
2014

--
> https://mail.python.org/mailman/listinfo/python-list
>



-- 
Joel Goldstick
http://joelgoldstick.com
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://mail.python.org/pipermail/python-list/attachments/20130930/52042c5a/attachment.html>