Menu
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.
789
First of all, c. fetchall() retrieves ALL the results from your query, we'll put them in a variable called rows . Then we create a iterator (the thing you tried to do with the while loop) by doing for row in rows . Then we simply print each row.
The fetchall() method retrieves all the rows in the result set of a query and returns them as list of tuples. (If we execute this after retrieving few rows it returns the remaining ones). The fetchone() method fetches the next row in the result of a query and returns it as a tuple.
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.
26
I think you're looking for Cursor.fetchone() :
cursor.fetchone()[0] If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
