Cursor.fetchall() to list

And what about list comprehensions? If result is ((123,), (234,), (345,)):

>>> row = [item[0] for item in cursor.fetchall()]
>>> row
[123, 234, 345]

If result is ({'id': 123}, {'id': 234}, {'id': 345}):

>>> row = [item['id'] for item in cursor.fetchall()]
>>> row
[123, 234, 345]

--César

Similar codes

0 vote221 views1 answer
Use argparse to call function and use argument in function
Python
0 vote207 views1 answer
Mechanize python XE #27
Python
2 votes251 views1 answer
Pytorch tensor change dimension order
Python
0 vote199 views1 answer
Binarize array python
Python
24 votes194 views6 answers
Python string list to list
Python
1 vote206 views1 answer
Python count number of zeros in a column
Python
0 vote188 views1 answer
Python get host.docker.internal ip site:stackoverflow.com
Python
0 vote188 views1 answer
Limits the result count to the number specified
Python
3 votes189 views2 answers
Python decouple
Python
0 vote206 views1 answer
Celery timezone setting django
Python