Boolean fields in MySQL Django Models?

Question

At Django, a boolean field in MySQL is stored as a TINYINT. When I retrieve it, I get 0 or 1. Shouldn't I get False or True? Is there a way to achieve this behaviour?

Answer 1

>>> u=User.objects.get(pk=1)
>>> u.is_active
1
>>> u.is_active==1
True
>>>

The reasons why boolean columns return 1 or 0 are on the link in your question.

Answer 2

You could create your own method for your model that evaluates this for you:

class User(models.Model):
    active_status = models.BooleanField(default=1)

    def is_active(self):
        if self.active_status:
            return True
        else:
            return False

Then any tests you perform against this field could just reference the method instead:

>>> u.is_active()
True

So instead of calling an attribute, you're calling a method (extra ()!!), but this gives you the result you desire.