executing query and then fetching results in pymysql python

Question

If I write,

cursor=db.cursor(pymysql.cursors.DictCursor)
cursor.execute(query)
result=cursor.fetchall()
print(result)

this works and print results as a dictionary.

But if I write like this,

cursor=db.cursor(pymysql.cursors.DictCursor)
result=cursor.execute(query).fetchall()
print(result)

it gives me error:

Traceback (most recent call last):
  File "senti4SDanalyze.py", line 22, in <module>
    constructMaleResults()
  File "senti4SDanalyze.py", line 12, in constructMaleResults
    result=cursor.execute(query).fetchall()
AttributeError: 'int' object has no attribute 'fetchall'

why is that?

Because cursor.execute(query) returns an int.

Sraw
– Sraw

2018-06-22 02:19:22 +00:00
Commented Jun 22, 2018 at 2:19 — Sraw
– Sraw, Commented Jun 22, 2018 at 2:19

Bennett Brown · Accepted Answer · 2018-06-22 02:19:45Z

2

In result=cursor.fetchall() the method fetchall is being called on the object cursor.

In result=cursor.execute(query).fetchall() the method fetchall is being called on the object (or native type) returned by the execute method.

To understand this better, explore with the built-ins type and dir:

type(cursor)
dir(cursor)
type(cursor.execute(query))
dir(cursor.execute(query))

answered Jun 22, 2018 at 2:19

Bennett Brown

5,3911 gold badge29 silver badges35 bronze badges

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

Collectives™ on Stack Overflow

executing query and then fetching results in pymysql python

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related