Set format to cursor.fetchall() result

Question

Im working with mysql.connection library to Python and I have this method:

query = ("select " + columns + " from " + table)
self.cursor.execute(query)
data = self.cursor.fetchall()
for row in data:
    print row

In my print row, I get something like this:

(u'Kabul', u'AFG', u'Kabol', 1780000)

I would like to get it as a string, this result:

Kabul AFG Kabol 1780000

I can do this:

print row[0] + ' ' + row[1] + row[2] + ' ' + row[3]

But it will not work if the user sets a query with less than 4 columns or more than 4.

I also was thinking about a loop in my tuple, but I get this result:

Kabul
AFG
Kabol
1780000

Some idea?

score 4 · Accepted Answer · answered Apr 13 '16 at 08:28

4

You can use join but will run into errors when joining a list of mixed unicode and integers. Use the built in str function and list comprehension to create your intended output.

print ' '.join(str(x) for x in row)

answered Apr 13 '16 at 08:28

dnix

121
4

This work well =) Thanks. – BigBugCreator Apr 13 '16 at 08:49
1

I would like to add that I get an error of unicode or something like that, I resolve with this: print " ".join(str(unicode(c).encode('utf-8')) for c in row) – BigBugCreator Apr 13 '16 at 08:55

AKS · Answer 2 · 2016-04-13T08:39:02.540

2

If row is a tuple you could join every value in it using space:

print " ".join(row)
# Kabul AFG Kabol 1780000

So, it doesn't matter how many columns a user has selected, it will always join what row has.

UPDATE:

Above code works only if the values in row are string, so you need to first convert values to string and then join

print " ".join(map(str, row))

edited Apr 13 '16 at 08:39

answered Apr 13 '16 at 08:20

AKS

18,983
3
43
54

1

This will fail if anything in the tuple is not a string. – Burhan Khalid Apr 13 '16 at 08:31
Thank you. I updated the answer. – AKS Apr 13 '16 at 08:39

Set format to cursor.fetchall() result

2 Answers2