Python: 'NoneType' object is not subscriptable on a non empty query result

Question

I get object is not subscriptable on a non empty query result. When i print c.fetchone() it prints the correct result but when i check the type it says <class 'NoneType'>

import sqlite3

conn = sqlite3.connect("scraping.db")
c = conn.cursor()

c.execute('CREATE TABLE IF NOT EXISTS Terminate (numar INT, arj INT )')
conn.commit()
c.execute('DELETE FROM Terminate')
conn.commit()
c.execute('INSERT OR IGNORE INTO Terminate ( numar, arj ) VALUES (1,0)')
conn.commit()
c.execute("SELECT * FROM Terminate") # ORDER BY numar DESC LIMIT 1")
print(c.fetchone(), type(c.fetchone()))

ins = c.fetchone()[0]

There are no more rows available (your table clearly has only one row). You can store the first result if you intend to reuse that: result = c.fetchone() — Moses Koledoye
– Moses Koledoye, Commented Jul 22, 2018 at 18:34
if you want to play more with the same line, you have to keep a reference like res = c.fetchone() then print(res, type(res)) will work as you expect — PRMoureu
– PRMoureu, Commented Jul 22, 2018 at 18:37
i still can not retrieve the first element of that result = c.fetchone() — Mihai Moldovan
– Mihai Moldovan, Commented Jul 22, 2018 at 18:40
ins = result[0] TypeError: 'NoneType' object is not subscriptable — Mihai Moldovan
– Mihai Moldovan, Commented Jul 22, 2018 at 18:42

rth · Accepted Answer · 2018-07-22 18:49:55Z

1

I didn't see @PRMoureu comment. She/he is completely right. It happens because you already have fetched both your values in print. You need re-execute SELECT or remove your print:

import sqlite3

conn = sqlite3.connect("scraping.db")
c = conn.cursor()

c.execute('CREATE TABLE IF NOT EXISTS Terminate (numar INT, arj INT )')
conn.commit()
c.execute('DELETE FROM Terminate')
conn.commit()
c.execute('INSERT OR IGNORE INTO Terminate ( numar, arj ) VALUES (1,0)')
conn.commit()
c.execute("SELECT * FROM Terminate") # ORDER BY numar DESC LIMIT 1")


ins = c.fetchone()[0]
print ins, type(ins)

The output seems ok

1 <type 'int'>

answered Jul 22, 2018 at 18:49

rth

3,1361 gold badge25 silver badges28 bronze badges

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

Collectives™ on Stack Overflow

Python: 'NoneType' object is not subscriptable on a non empty query result

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