How to count the number of rows in a database table in Django

django django-models django-database
Friend picture Friend · Mar 26, 2013 · Viewed 40.8k times · Source

I have database created by Django model, where status and id and username are the fields of the table Messages.

I need to count the number of rows where status value= 0 for a particular username.

This is my incomplete code:

Message_me = Messages.objects.get(username='myname')

Answer

Mikhail Chernykh picture Mikhail Chernykh · Mar 26, 2013

Try this code:

Message_me = Messages.objects.filter(username='myname', status=0).count()

Related questions

Update only specific fields in a models.Model

I have a model class Survey(models.Model): created_by = models.ForeignKey(User) question = models.CharField(max_length=150) active = models.NullBooleanField() def __unicode__(self): return self.question and now I want to update only the active field. So I do …

Read More
Add Indexes (db_index=True)

I'm reading a book about coding style in Django and one thing they discuss is db_index=True. Ever since I started using Django, I've never used this function because I'm not really sure what it does. So my question …

Read More
"Returning to that page might cause any action you took to be repeated" - Django

I have a form on my website, that creates an entry in database. So every time when I refresh a page I got this message first: The page that you're looking for used information that you entered. Returning to that …

Read More