Re: how to query max count

ok that max(the_max)  didn't work every time it provide a different result (looking into this) just updating the post in case someone was looking into this as a solution.

On Thursday, October 16, 2014 12:21:33 AM UTC-5, dk wrote:

looks like it works like this

the_max = Choice.objects.filter(date=date)
print max(the_max)

On Monday, October 13, 2014 6:14:28 PM UTC-5, dk wrote:

I need to learn how to use aggregation in django, I was thinking  on filter by date,

and then loop the query and make a dictionary with the name, and += value and then use the python max function.

On Monday, October 13, 2014 3:12:39 AM UTC-5, JirkaV wrote:

Hi there,

  you could do it manually by counting occurrences or you could take a look at aggregation functions here: https://docs.djangoproject.com/en/1.7/topics/db/aggregation/

  Do as it suits your use case.

  HTH

    Jirka

On 13 October 2014 06:30, dk <dem...@gmail.com> wrote:

I am storing the information in the database like this.

class Choice(models.Model):
    restaurant = models.ForeignKey(Restaurant)
    person = models.ForeignKey(Person)
    date = models.DateField("time published")
    time = models.TimeField("date published")

that way I can get the person and the restaurant.   and will look like in the attached pictures,     now how can I query.

the max repeated restaurant id, for today date.

I want to know today what restaurant won.   =)          (I am trying to even think on how to get this in a regular sql command)

thanks guys.

--
You received this message because you are subscribed to the Google Groups "Django users" group.
To unsubscribe from this group and stop receiving emails from it, send an email to django-users...@googlegroups.com.
To post to this group, send email to django...@googlegroups.com.
Visit this group at http://groups.google.com/group/django-users.
To view this discussion on the web visit https://groups.google.com/d/msgid/django-users/1628cbb6-f8ee-491b-a031-ad7aec787178%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

--
You received this message because you are subscribed to the Google Groups "Django users" group.
To unsubscribe from this group and stop receiving emails from it, send an email to django-users+unsubscribe@googlegroups.com.
To post to this group, send email to django-users@googlegroups.com.
Visit this group at http://groups.google.com/group/django-users.
To view this discussion on the web visit https://groups.google.com/d/msgid/django-users/a23eaefc-65e8-4763-8d0f-1d2c51136e46%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.