How to convert list to Json after retrieve from database in Python?

Question

I have a database like this:

When i retrieved this column and want to convert it to Json format like this:

cursor3 = conn.cursor()
cursor3.execute("select version()")
data = cursor3.fetchone()
cursor3.execute("SELECT headerdynamic FROM emailData ")
headerDynamic = cursor3.fetchall()
di = {i.split(':')[0]:i.split(':')[1] for i in headerDynamic}
js = json.dumps(di)
print(js)

It will prompt this error message:

di = {i.split(':')[0]:i.split(':')[1] for i in headerDynamic}
AttributeError: 'tuple' object has no attribute 'split'

Here is the print output of the headerDynamic

 [("'header1 : Subject', 'header2 :Text'",)]

Does anyone know what im doing wrong here? Thanks

this might help u - stackoverflow.com/questions/3286525/…

gil
– gil

2022-03-22 07:11:16 +00:00
Commented Mar 22, 2022 at 7:11 — gil
– gil, Commented Mar 22, 2022 at 7:11

user18539642 · Accepted Answer · 2022-03-22 08:08:53Z

1

Use an extend method to convert your tuple to an array

x = []
for item in a:
    x.extend(item)

answered Mar 22, 2022 at 8:08

user18539642

Sign up to request clarification or add additional context in comments.

Comments

score 0 · Accepted Answer · 2022-03-22 08:00:10Z

0

You can print out headerDynamic and see what kind of data is inside. Most likely, you will find tuple datatypes which cannot be splitted the way you try.

Iterate over your tuples (Not your Array which contains tuples!):

for i in ("'header1 : Subject', 'header2 :Text'",):
    # i is a string, which has your intended split function
    print(i)

edited Mar 22, 2022 at 8:00

answered Mar 22, 2022 at 7:27

user18539237

2 Comments

WEI ZHUANG GOH Over a year ago

Here is the print output [("'header1 : Subject', 'header2 :Text'",), ("'header1 : Subject', 'header2 :Text'",)] and the type is list

user18539237 Over a year ago

Yes but inside the list, there are tuples; identified by the (,) syntax.

Collectives™ on Stack Overflow

How to convert list to Json after retrieve from database in Python?

2 Answers 2

Comments

2 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

2 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related