Python: Cursor 'NoneType' object has no attribute

Question

I am trying to play around with this simple sql query using cursor:

import jaydebeapi,pandas as pd

conn = <connection to TeraData>
cursor = conn.cursor()
sql = ("Select top 10 * from Car_Sales")
data = cursor.execute(sql)
print(data.query)
row = data.fetchone()
#rows = data.fetchall()
print(row)

Error I am getting is:

AttributeError: 'NoneType' object has no attribute 'fetchone'

It has been couple hours trying to find the issue but not getting anywhere on this. Looked different resources online but still the issue remains.

Please let me know where am I going wrong?

Update:

When I executed the same query in Pandas:

pd.read_sql_query('select top 10 * from  Car_Sales',conn)

Output:

Car_Sales
0 112
1 77
2 226
3 990
4 552
5 887

This means that data is None. Maybe your SQL query is invalid? "Select top 10 * Car_Sales" doesn't look like a correct query to me — zdimension
– zdimension, Commented Aug 31, 2018 at 0:31

chris · Accepted Answer · 2018-08-31 11:12:22Z

5

You haven't told us which connection library you're using, but in cases I'm familiar with (psycopg, etc) cursor.execute() doesn't return a result set. Try issuing the fetchone and fetchall commands against the cursor (rather than data):

conn = <connection to TeraData>
cursor = conn.cursor()
cursor.execute("Select top 10 * from Car_Sales")

row = cursor.fetchone()
print(row)

# rows = cursor.fetchall()   
# print(rows)

Update

A tidbit from Blckknght's comment - take a look at the Python Database API Spec: "Return values are not defined" for cursor.execute.

edited Aug 31, 2018 at 11:12

answered Aug 31, 2018 at 2:15

chris

2,0832 gold badges15 silver badges22 bronze badges

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

2 Comments

Blckknght Over a year ago

Indeed, this is part of the Python DB API which most libraries try to follow.

Alpha001 Over a year ago

@chris Apologies I am using Jaydebeapi library. Have updated the question.

Collectives™ on Stack Overflow

Python: Cursor 'NoneType' object has no attribute

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related