I have a mysql query that runs and selects all of the Id's that match the select statement:
first_seen_select = "SELECT Id FROM domains_archive WHERE current_epoch = " + current_epoch + " AND first_seen IS NULL"
cur.execute(first_seen_select)
The output of cur.fetchall() is
((1,), (2,), (3,), (4,), (5,), (6,), (7,))
How do i extract these nested tuple Id #'s and convert them into a single list that i can iterate over?
If i run the following i get:
>>> bleh = cur.fetchall()
>>> for i in bleh:
... print(i)
...
(1,)
(2,)
(3,)
(4,)
(5,)
(6,)
(7,)
you can use a simple list comprehension:
[y for x in l for y in x]
Or with more meaningful variable names:
[item for sublist in l for item in sublist]
this will result in:
In [8]: l = ((1,), (2,), (3,), (4,), (5,), (6,), (7,))
In [9]: [y for x in l for y in x]
Out[9]: [1, 2, 3, 4, 5, 6, 7]
Collected from the Internet
Please contact [email protected] to delete if infringement.
Comments