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 vote127 views1 answer
Postgresql.org Currency data type
Python
0 vote129 views1 answer
Twin axis python
Python
1 vote127 views1 answer
Argparse boolean default
Python
14 votes129 views3 answers
Getting ip address based on phone number python
Python
1 vote134 views1 answer
Pandas select data conditional
Python
0 vote133 views1 answer
Online convert http query to json python
Python
0 vote169 views1 answer
Django fixtures. To loaddata
Python Django
0 vote141 views1 answer
How to count a consecutive series of positive or negative values in a column in python
Python
0 vote166 views1 answer
Check if key exists in sesson python flask
Python
0 vote140 views1 answer
Pyton get minimum value of array
Python