Hi all.
My name's Mauro and I start to work with Django 1.7.3
I work on my project which tracks my accounting.
I need to translate a SQL query to annoteta values aggretate statements.
The application is named accounting
The models involved are:
class Nominativo(models.Model):
nome = models.CharField(max_length=100)
class Impianto(models.Model):
nome = models.CharField(max_length=100)
class Capitolo(models.Model):
nome = models.CharField(max_length=100)
class Registrazione(models.Model):
anno = models.PositiveIntegerField()
impianto = models.ForeignKey('Impianto')
nominativo = models.ForeignKey('Nominativo')
capitolo = models.ForeignKey('Capitolo')
dare = models.DecimalField(max_digits=10, decimal_places=2)
avere = models.DecimalField(max_digita=10, decimal_places=2)
I need to translate te following sql statement
SELECT capitolo.nome, sum(dare) as uscite, sum(avere) as entrate
FROM contabilita_registrazione
INNER JOIN contabilita_capitolo as capitolo ON
contabilita_registrazione.capitolo_id=capitolo.id
WHERE anno=2014
GROUP BY capitolo.nome
ORDER BYcapitolo.nome;
How can obtain the same behavior using ORM?
Thanks in advance
MZ
--
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 [email protected].
To post to this group, send email to [email protected].
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/2b6998bf-741e-46c1-8721-e1870e5fe608%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.
