Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

Trigering post_save signal only after transaction has completed

I have written some APIs, for which the respective functions executive inside a transaction block. I am calling the save() method (after some modifications) on instance/s of a/several Model/s, and also consecutively indexing some JSON related information of the instance/s in Elasticsearch. I want the database to rollback even if for some reason the save() for one of the instances or indexing to the Elasticsearch fails.

Now, the problem is arising that even inside the transaction block, the post_save() signals gets called, and that is an issue because some notifications are being triggered from those signals.

Is there a way to trigger post_save() signals only after the transactions have completed successful?

like image 615
doto Avatar asked Oct 16 '15 22:10

doto


2 Answers

I think the simplest way is to use transaction.on_commit(). Here's an example using the models.Model subclass Photo that will only talk to Elasticsearch once the current transaction is over:

from django.db import transaction from django.db.models.signals import post_save  @receiver(post_save, sender=Photo) def save_photo(**kwargs):     transaction.on_commit(lambda: talk_to_elasticsearch(kwargs['instance'])) 

Note that if the transaction.on_commit() gets executed while not in an active transaction, it will run right away.

like image 65
Michael Tom Avatar answered Sep 23 '22 10:09

Michael Tom


Not really. The signals have nothing to do with the db transaction success or failure, but with the save method itself - before the call you have the pre_save signal fired and after the call you have the post_save signal fired.

There are 2 approaches here:

  • you are going to inspect the instance in the post_save method and decide that the model was saved successfully or not; simplest way to do that: in the save method, after the transaction executed successfully, annotate your instance with a flag, say instance.saved_successfully = True, which you will test in the post_save handler.
  • you are going to ditch the post_save signal and create a custom signal for yourself, which you will trigger after the transaction ran successfully.

Makes sense?

P.S.

If you strictly need to bind to the transaction commit signal, have a look over this package: https://django-transaction-hooks.readthedocs.org/en/latest/; it looks like the functionality is integrated in Django 1.9a.

like image 24
Roba Avatar answered Sep 24 '22 10:09

Roba