If case not working for empty result with sql query python

Question

So basically I am trying to retrieve values from a database. My if case is that if the query result which is saved in variable data is None then it should print message data not found. If the value is not none then it should print the data. My problem is that I am on purpose giving it a value which is not present in the database which means data should be null. But my if none case is not triggering. It goes directly to else. I have attached pictures down below. Apologies if this question is too basic.

If you have code, why would you post it as an image? Could you please post your code as formatted text (Ctrl+K)? — JE_Muc
– JE_Muc, Commented Mar 3, 2020 at 17:58

Steve Mapes · Accepted Answer · 2020-03-03 17:58:26Z

2

This is because you are testing if the data variable is am instance of the None object which, from your output, it's not it's a list.

So all you need to do is to change your if statement to if not data: which will fix the problem.

Not will pass true for None, False and empty list amongst other things. see Python Truth Value Testing

answered Mar 3, 2020 at 17:58

Steve Mapes

9418 silver badges23 bronze badges

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

1 Comment

Steve Mapes Over a year ago

Excellent, would you mind up-voting (Clicking on the up arrow) and selecting my post as the selected answer for your question please to help anyone in the future who has the same problem.

Collectives™ on Stack Overflow

If case not working for empty result with sql query 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