how to make fetch object MySQL:Connector cursor with python

Question

I m looking for a default fetch object Cursor method for my select queries, I m using this code permanently to fetch all received data from my cursor.

My implementation of fetch object method

def fetch_object(self,cursor):
    data = cursor.fetchall()
    names = cursor.column_names
    results = []
    for info in data:
        object = {}
        for index in range(len(names)):
            object[names[index]] = info[index]
        results.append(object)
    return results

My selecting data code and fetching

 try:
        cursor = self.connexion.cursor()
        cursor.execute("SELECT * FROM domains")
        domains = self.fetch_object(cursor)
        return domains
    except Error as error:
        print(error)

Any other suggestion way ( a exists way in mysql:connector fetch methods ) with mysql:connector,thank you.

Take a look at the answers to this question: stackoverflow.com/q/22769873/42346 — mechanical_meat
– mechanical_meat, Commented May 7, 2020 at 22:49

Nuno Mariz · Accepted Answer · 2020-05-19 18:15:06Z

3

You can use cursor.MySQLCursorDict and you'll have the same functionality:

try:
    cursor = self.connection.cursor(dictionary=True)
    cursor.execute("SELECT * FROM domains")
    domains = cursor.fetchall()
    return domains
except Error as error:
    print(error)

More details in https://dev.mysql.com/doc/connector-python/en/connector-python-api-mysqlcursordict.html

answered May 19, 2020 at 18:15

Nuno Mariz

5993 silver badges9 bronze badges

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

Collectives™ on Stack Overflow

how to make fetch object MySQL:Connector cursor with python

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related