Python SQlite select query returning list instead of integer

Question

I have a function to query DB and return a value like below

def find_dase(Plants):
    conn = sqlite3.connect("dexro.db")
    cursor = conn.cursor()
    cursor.execute(("SELECT Years FROM Plants_no WHERE Plant=?"),(Plants,))
    data = cursor.fetchall()
    conn.close()
    return data

when i execute this i am getting a list instead of the value

print(find_dase('dex'))
print(type(find_dase('dex')))

Output:

[('10',)]      
<class 'list'>

How can i fetch only the integer value

Yes, it returns a row, in this case the row contains only one value, Years. So .fetchone()[0] — Andrej Kesely
– Andrej Kesely, Commented Jul 9, 2018 at 8:19

Andrej Kesely · Accepted Answer · 2018-07-09 08:26:33Z

2

cursor.fetchall() fetches all rows in form of list. In this case the row has only one value Year, so list of one valued tuples.

Solution:

Use .fetchone() to fetch only one row in form of tuple and index it:

def find_dase(Plants):
    conn = sqlite3.connect("dexro.db")
    cursor = conn.cursor()
    cursor.execute(("SELECT Years FROM Plants_no WHERE Plant=?"),(Plants,))
    data = cursor.fetchone()[0]  # THIS IS CHANGED
    conn.close()
    return data

answered Jul 9, 2018 at 8:26

Andrej Kesely

196k15 gold badges60 silver badges105 bronze badges

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

Collectives™ on Stack Overflow

Python SQlite select query returning list instead of integer

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