Python - Returning the output as a dictionary - MySQL

Question

I have coded a class to handle mysql connecting using the external modules but when I get data I want it to be returned like:

{ 'id': '1', 'username': 'Test'}

it's currently returned:

(1, u'Test')

The code which I use is:

def executeQuery(self, query):
    if(self.mysqlSuccess):
        cursor = self.cnx.cursor()
        cursor.execute(query)
        for row in cursor:
            print row
executeQuery('SELECT * FROM `users`')

not exactly a duplicated, but very close (and maybe the answer that op needs) : stackoverflow.com/questions/209840/… — Rod
– Rod, Commented Jul 23, 2015 at 14:00
possible duplicate of Python: use mysqldb to import a MySQL table as a dictionary? — Joe Doherty
– Joe Doherty, Commented Jul 23, 2015 at 14:02

Pie-thorn · Accepted Answer · 2015-07-23 14:09:00Z

17

I found an answer to my problem when your defining the cursor you do it like this

cursor = db.cursor(dictionary=True)

and the mysql package I was using is mysql.connector

answered Jul 23, 2015 at 14:09

Pie-thorn

2893 silver badges6 bronze badges

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

2 Comments

Fernando Popoca Ortiz Over a year ago

I've been using namedtuple for weeks to acomplish a simliar result, thanks

phobic Over a year ago

It should be something like connection.cursor instead of db.cursor, or?

Joe Doherty · Accepted Answer · 2015-07-23 13:59:50Z

8

You can use a DictCursor when initializing your connection to MySQL.

import MySQLdb.cursors

cnx = MySQLdb.connect(user='joe', passwd='password', db='dbname',
                      cursorclass=MySQLdb.cursors.DictCursor)

If you are using a diff mysql package then just check the docs for DictCursor.

answered Jul 23, 2015 at 13:59

Joe Doherty

3,9882 gold badges35 silver badges39 bronze badges

Collectives™ on Stack Overflow

Python - Returning the output as a dictionary - MySQL

2 Answers 2

2 Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

2 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related