how to implement automatically send email when MySQL column get updated (django+MySql)

Question

I have models like Id, Name, email, Status. And created serializers and views.

I am updating the Status values by PUT method. How to implement an automatic email notification to smtp.example.com with the changed Status value.

Ex: Status column value is 'abc' I am updating value 'abc' to 'xyz' using PUT. I want an email should automatically send to particular email-id belongs to that row using primary key Id.

Django backend PUT method

    if request.method=='GET':
        employees = Employees.objects.all()
        employees_serializer=EmployeeSerializer(employees,many=True)
        return JsonResponse(employees_serializer.data,safe=False)
    elif request.method=='POST':
        employee_data=JSONParser().parse(request)
        employees_serializer=EmployeeSerializer(data=employee_data)
        if employees_serializer.is_valid():
            employees_serializer.save()

I want to implement 
```if(employee_data(after update !== employee_data(before update):
     sendmail()

can some one help here with some proper logic and code.

Rajat Jog · Accepted Answer · 2022-03-16 07:38:58Z

1

Say that you have send_email() function or thread implemented seperately as follows:

from django.core.mail import send_mail
def send_email(subject, message, sender, to):
   return send_mail(subject, message, sender, to)

Then in your PUT/UPDATE view function you can call this function as follows:

def update(self, request):
   ... # your operations here
   if (state changed):
     subject = ""
     message= "state: {state} [your message]" 
     send_mail(subject, message, sender, to=[user.email])
     return Response(200)

answered Mar 16, 2022 at 7:38

Rajat Jog

3271 gold badge2 silver badges11 bronze badges

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

Collectives™ on Stack Overflow

how to implement automatically send email when MySQL column get updated (django+MySql)

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related