How to get a single result from a SQL query in python?

Question

Is there an elegant way of getting a single result from an SQLite SELECT query when using Python?

for example:

conn = sqlite3.connect('db_path.db') cursor=conn.cursor() cursor.execute("SELECT MAX(value) FROM table")  for row in cursor:     for elem in row:         maxVal = elem 

is there a way to avoid those nested fors and get the value directly? I've tried

maxVal = cursor[0][0] 

without any success.

Answer 1

Or you could write a wrapper function that, given SQL, returns a scalar result:

def get_scalar_result(conn, sql):     cursor=conn.cursor()     cursor.execute(sql)      return cursor.fetchone()[0] 

I apologize for the possibly less than syntactically correct Python above, but I hope you get the idea.

Answer 2

I think you're looking for Cursor.fetchone() :

cursor.fetchone()[0]