I have a table with the columns id, col1, col2, and col3. When I ran the query, this is how it was executed:
cur.execute(query)
row = cur.fetchall()
Is there a way to store the data in the variable row inside a dictionary so that I can pass this result to an API?
The output of cur.fetchall() looks like this:
((id, col1, col2, col3), (id, col1, col2, col3), (id, col1, col2, col3))Can I format the result as follows?
[
{ id: value, col1: value, col2: value, col3: value },
{ id: value, col1: value, col2: value, col3: value },
{ id: value, col1: value, col2: value, col3: value }
]
I understand that I can iterate through the fetchall() results and extract values using a dictionary concept, such as:
rows = cursor.fetchall()
for row in rows:
id = row['id']
col1 = row['col1']
# and so on...
Can I convert rows into a dictionary before passing it?