Re: Saving an inline view and executing an aggregating function only once

You're almost right. I want that - for each item_code - the sum aggregated by item_code of the items inserted into OrderDetail be automatically inserted into total_quantity_in_store by the same code in Items model.
Ciao
Vittorio
Il giorno 08/nov/2013, alle ore 16:13, Vincenzo Prignano ha scritto:

> I got that you are executing a raw sql query every time you insert a new OrderDetail record. But can I ask why are you doing this?
> I think you should really need to redesign your models..
>
> On Thursday, November 7, 2013 10:04:33 AM UTC+1, vittorio wrote:
> I made an effort to simplify my app and translate it into English.
> Here it is
> =================
> models.py
> .................................
> class Items(models.Model):
> code = models.CharField(primary_key=True,max_length=15,db_column='code')
> description = models.CharField(max_length=255, db_column='Description', db_index=True)
> category = models.IntegerField(choices=categoria, db_column='Category',default=2)
> total_quantity_in_store=models.IntegerField(db_column='total_quantity_in_store', default=0)
> def __unicode__(self):
> return self.description
> class Meta:
> db_table = u'Items'
>
> class Order(models.Model):
> id_order = models.IntegerField(primary_key=True,db_column='id_order')
> patient = models.ForeignKey(Patients, db_column='patient')
> def __unicode__(self):
> return u"Ord.%s per %s" % (self.id_order, self.paziente)
> class Meta:
> db_table = u'Order'
>
> post_save.connect(TotalInStore, sender=Order)
>
> class OrderDetail(models.Model):
> id_order = models.ForeignKey(Order,db_column='id_order')
> item_code = models.ForeignKey(Items,verbose_name='Items')
> quantity = models.IntegerField(db_column='quantity',blank=True,default=0)
> class Meta:
> db_table = u'OrderDetail'
> ==================
> admin.py
> ......................
> class OrderDetailInline(admin.TabularInline):
> model=OrderDetail
> raw_id_fields = ['item_code',]
> fields=('item_code', 'quantity',)
>
> class OrderOption(admin.ModelAdmin):
> readonly_fields = ['order_id', 'patient']
> list_display = ( 'patient','order_id')
> fields=( 'order_id', 'patient')
> inlines=[OrderDetailInline,]
>
> admin.site.register(Order,OrderOption)
> ....................
> =========================
> signals.py
> def ExecuteQuery(query):
> from django.db import connection
> cursor=None
> cursor= connection.cursor()
> cursor.execute(query, [])
> return cursor.fetchall()
>
> def TotalInStore(sender,**kwargs):
> ....................
> ItemsInOrder = """SELECT item_code_id as code,SUM(quantity) as total
> FROM OrderDetail
> GROUP BY item_code_id
> ORDER BY item_code_id"""
> SUMS = ExecuteQuery(ItemsInOrder)
> if SUMS:
> [Items.objects.filter(pk=t[0]).update(total_quantity_in_store=int(t[1])) for t in SUMS]
> .............
> return
>
> To put it in a nutshell my Django 1.5.5 app 1):records the quantities of medical items given to patients of a medical center by means of an inline view that connects 'OrderDetail' to 'Order', 2): then input in the field total_quantity_in_store of the model 'Items' the sum of the field quantity ('OrderDetail') aggregated by item code via a post_save signal calling the TotalInStore function.
> It works happily BUT .... unfortunately with the increasing numbers of record in 'OrderDetail' it is (and will be obviously) becoming slower and slower. This is due to the fact that the post_save signal - aggregating the quantities - by code is called for EACH OrderDetail record I have input in the inline view while it will be more logical to execute it ***after*** all records of the inline view have been saved.
>
> Please help me modify my app so that the TotalInStore function is called only once after the inline view Order-OrderDetail has been saved.
>
> Ciao
> Vittorio
>
>
> --
> 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/c1081e20-375a-4626-9b72-6582caad3a97%40googlegroups.com.
> For more options, visit https://groups.google.com/groups/opt_out.

--
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/DAE972AB-EF9B-4F88-AA0E-1CC0A2FB08D2%40gmail.com.
For more options, visit https://groups.google.com/groups/opt_out.