how to check empty column in python

Question

how can i check if i have an empty column in my queryset?

this is my code :

        mastercard_percent = ClientPaymentOption.objects.filter(name='MasterCard', client=client).values_list('itemcharged',flat=True)
        if mastercard_percent == [None]:
            print 'empty'
        print mastercard_percent

and i got only this:

[None]

i try also in my code to become:

            if mastercard_percent == [None]:
                print 'empty'
            print mastercard_percent

but it also print :

[None]

thanks in advance...

NPatel · Accepted Answer · 2012-02-27 07:51:44Z

3

You have to check the values of the column

like if not mastercard_percent[0]: print 'empty'

answered Feb 27, 2012 at 7:51

NPatel

21.4k17 gold badges104 silver badges166 bronze badges

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

Comments

7O'clock · Accepted Answer · 2012-02-27 07:56:48Z

0

Shouldn't the expression be like:

print 'empty' if mastercard_percent == []
print mastercard_percent

In case that you're looking for an empty list.

answered Feb 27, 2012 at 7:56

7O'clock

419 bronze badges

Comments

Karl Barker · Accepted Answer · 2012-02-27 08:24:37Z

0

What is the output of repr(mastercard_percent) ? If its value truly is [None], then a comparison with [None] should work:

>>> a = [None]
>>> a == [None]
True

answered Feb 27, 2012 at 8:24

Karl Barker

11.5k3 gold badges23 silver badges26 bronze badges

Collectives™ on Stack Overflow

how to check empty column in python

3 Answers 3

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related