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+unsubscr...@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.
