How to set NULL for IntegerField instead of setting 0?

python django django-models xlrd
jyli7 picture jyli7 · May 13, 2013 · Viewed 23.4k times · Source

I'm uploading some data from an excel file using xlrd and turning that data into models (with mainly IntegerField values) in Django. My excel file has a bunch of missing data. Unfortunately, these missing data are converted to the value of 0 in my models, instead of NULL. This means that when my Person model doesn't have an age, that age gets recorded as 0, instead of as NULL.

What's the best way to change this? I've tried doing this:

age = models.IntegerField(blank=True, null=True)

But the blank fields still get set to 0 by default.

Answer

Shwetabh Sharan picture Shwetabh Sharan · May 14, 2013

Instead of using 

age = models.IntegerField()

use 

age = models.IntegerField(blank=True, null=True)

When we specify

blank=True, null=True

it will allow you to store null in that column

Related questions

How do I do a not equal in Django queryset filtering?

In Django model QuerySets, I see that there is a __gt and __lt for comparative values, but is there a __ne or != (not equals)? I want to filter out using a not equals. For example, for Model: bool a; int …

Read More
How to query as GROUP BY in django?

I query a model: Members.objects.all() And it returns: Eric, Salesman, X-Shop Freddie, Manager, X2-Shop Teddy, Salesman, X2-Shop Sean, Manager, X2-Shop What I want is to know the best Django way to fire a group_by …

Read More
How to delete a record in Django models?

I want to delete a particular record. Such as delete from table_name where id = 1; How can I do this in a django model?

Read More