Fetch multiple values from database

Question

I get from my DB the following return, when I use the sql command SELECT DISTINCT RezeptID FROM Rezepte;:

((1L,), (13L,), (14L,), (15L,))

Now I want to work with this values. Normally I use for single values something like this:

a=cursor.execute(sql_command)
(a, )=cursor.fetchone()

But then I get of course only the first value, the "1" back. How can I work with all these values? It would be optimal when I can put all these values in a array

score 2 · Accepted Answer · answered Apr 28 '17 at 08:31

2

A cursor can be used as an iterator to iterate over rows in the result set. To get the first value from each row try this:

cursor.execute(sql)
values = [row[0] for row in cursor]

answered Apr 28 '17 at 08:31

Eugene Yarmash

142,882
41
325
378

Okay, that works so far but the all the values in the list have an L behind the value. So the list looks so now : ´[1L, 13L, 14L, 15L]´ – jofri Apr 28 '17 at 08:38
Check this question: http://stackoverflow.com/q/11764713/244297 Generally, you shouldn't have to worry about it. – Eugene Yarmash Apr 28 '17 at 08:44
So what? That has no impact on anything. – Daniel Roseman Apr 28 '17 at 08:44
Ah, okay now I got it. This L only shows that this are long values^^ – jofri Apr 28 '17 at 08:49

score 0 · Answer 2 · answered Apr 28 '17 at 08:27

0

cursor.fetchall() if you are using sqlalchemy.

answered Apr 28 '17 at 08:27

CK Chen

625
5
15

Yes, but when I use ´(a,b,c,d, )=cursor.fetchall()´ I get values like (1L, ) with the datatype tuple – jofri Apr 28 '17 at 08:32

Fetch multiple values from database

2 Answers2