Python SQLite query returns None

Question

The following SQLite query returns 3:

SELECT MAX(depth) FROM mpitree WHERE child = 2

But this code evaluates to None:

def ancestors_depth(self):
    self.cursor.execute("SELECT MAX(depth) FROM mpitree WHERE child = 2");
    return self.cursor.fetchone()[0]

Why is that ?

score 0 · Answer 1 · answered Sep 19 '18 at 07:29

0

You should store the result of you query I think:

SQL_QUERY = "SELECT MAX(depth) FROM mpitree WHERE child = 2"

def ancestors_depth(self):
    result = self.cursor.execute(SQL_QUERY)
    return result.fetchone()[0]

answered Sep 19 '18 at 07:29

Léopold Houdin

1,515
13
18

score 0 · Answer 2 · answered Sep 19 '18 at 08:12

All right, I found the problem. My code was called in a unit test. In this unit test, at first I wrote a test case that populated the database (which was working). Then I added a test for the query. But because tests are executed in alphanumerical order, the test that was querying the database was being executed BEFORE the databases was populated.

Thank you for your help.

Python SQLite query returns None

2 Answers2