How to do SELECT COUNT(*) GROUP BY DJANGO? [duplicate]

Question

I want to execute this MySQL query in Django:

SELECT Descripcion,count(*)
FROM votaciones.Tarjeton 
WHERE Voto_idVoto=1 
GROUP BY Descripcion;

Expected result from MySQL:

'', '1'

'Camilo Gomez Ortega', '3'

'JUan Jose Marquez', '3'

'Pedro Pablo de la Mar', '15'

'Sandra Mejia Gutierez', '4'

My model is:

class Tarjeton(models.Model):
idtarjeton = models.AutoField(db_column='idTarjeton', primary_key=True)  # Field name made lowercase.
descripcion = models.CharField(db_column='Descripcion', max_length=45)  # Field name made lowercase.
cadidatos_idcadidatos = models.ForeignKey(Cadidatos, models.DO_NOTHING, db_column='Cadidatos_idCadidatos')  # Field name made lowercase.
voto_candidato = models.ForeignKey('Voto', models.DO_NOTHING, db_column='Voto_idVoto')  # Field name made lowercase.

class Meta:
    managed = False
    db_table = 'Tarjeton'

You should look at the examples in Django aggregation. Possible duplicate of stackoverflow.com/a/629691/6382901 — Jedi
– Jedi, Commented Jun 3, 2017 at 1:10

Tiny.D · Accepted Answer · 2017-06-03 01:21:22Z

2

Try this way:

from django.db.models import Count
Tarjeton.objects.filter(voto_candidato=1).values('descripcion').annotate(Count('descripcion')).order_by()

edited Jun 3, 2017 at 1:21

answered Jun 3, 2017 at 1:14

Tiny.D

6,5562 gold badges18 silver badges20 bronze badges

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

4 Comments

Andres Mejia Over a year ago

Observacion Votos Pedro Pablo de la Mar 15 Sandra Mejia Gutierez 4 JUan Jose Marquez 3 Camilo Gomez Ortega 3 1

Tiny.D Over a year ago

the result is not correct?

Tiny.D Over a year ago

the result is same as the one in your question, just it is ordered.

Andres Mejia Over a year ago

yes, result is correct, thank

Collectives™ on Stack Overflow

How to do SELECT COUNT(*) GROUP BY DJANGO? [duplicate]

1 Answer 1

4 Comments

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

4 Comments

Linked

Related