Saving mysql data with Django

Question

I am using Django with a MYSQL backend and I have noticed that there is a delay between when I update the data in my database and when the new data is available. Here is what's going on in my code:

def change_user_email_api(request):
logger.debug("API: resend verification email")
new_email = request.GET.get('email', '')
username = request.user.username
the_user = User.objects.get(username=username)
the_user.email = new_email
the_user.save()
send_verification_email(request.user)
return generate_success(callback)

send_verification_email sends out an email to the user to verify their email account. I'm thinking the error is due to me passing request.user instead of the_user to send_verification_email.

Is there any way that I an ensure that I always have the newest data from the db, and if so, should I be doing this anyway? Or should I just accept that the data will take some time to update and design around this?

Thanks!

sounds like something else is going wrong there. updating properties on an instance are visible directly, even without the save(). please provide more context, or a real example. (yours looks made up, e.g. you are missing the string quotes) — second
– second, Commented Nov 26, 2012 at 23:01
I have updated the question, and I think I found the answer but some verification would be nice. Thanks for your reply :) — jmetz
– jmetz, Commented Nov 26, 2012 at 23:23

Raunak Agarwal · Accepted Answer · 2012-11-26 23:33:12Z

2

request.user does not fetches you the User object from the database. Its the middleware which sets the object in the request scope. So, you can not expect when you use request.user to give you the updated instance of the user. If you want to send the email you will have to use 'the_user' object

def change_user_email_api(request):
   logger.debug("API: resend verification email")
   new_email = request.GET.get('email', '')
   the_user = request.user
   the_user.email = new_email
   the_user.save()
   send_verification_email(the_user)
   return generate_success(callback)

answered Nov 26, 2012 at 23:33

Raunak Agarwal

7,2486 gold badges41 silver badges62 bronze badges

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

1 Comment

jmetz Over a year ago

That's what I thought. Thanks for the confirmation!

Collectives™ on Stack Overflow

Saving mysql data with Django

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related