how to count value returned from select query in python

Question

I want to count the total number of rows returned by query. I am able to retrieved rows returned by query but what if i need to work in case when no data exits. that is when query returns no va from database.

the code i used to solve this problem is :

try: cur.execute(query)

    id = cur.fetchone()[0]
    if(id is None):
        return '-1'
    else: 
        return id

But this doenst help when no values is returned selected from query.(when condition doesnt meet criteria defined in select statement)

quanticle · Accepted Answer · 2011-03-01 21:24:32Z

2

cur.fetchall() will give you a sequence of all the rows. You can look at the length of that sequence to see if any rows were returned. This works for small result sets, but may not be ideal for queries that return large amounts of data.

Alternatively, you can look at cur.rowcount. Rowcount will return the number of rows in the query, or -1 if the number cannot be determined. It is up to the implementation to set rowcount; several popular python database modules (most notably sqlite3), do not set rowcount for all queries. For modules that do not set rowcount, the only way to count the number of result rows is to load the full result set into memory.

answered Mar 1, 2011 at 21:24

quanticle

5,0506 gold badges35 silver badges42 bronze badges

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

1 Comment

quanticle Over a year ago

If it worked for you, could you please mark this answer as correct (using the check mark)? It will help others find the correct answer when they come across this question.

Collectives™ on Stack Overflow

how to count value returned from select query in python

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related