Re: update() (for bulks) is a atomic operation?

[wancharle sebastiao quirino]

thanks,
A friend recommended the django-debug-toolbar but did not pay much
attention.
Now I have a reason.

Thanks


2009/10/25 Mikhail Korobov 

>
> Yes, it's a single query.
>
> Take a look at django-debug-toolbar. It can display all SQL queries
> that was executed during request/response so you'll always be sure
> what's going on.
>
> On 26 окт, 03:12, wancharle sebastiao quirino 
> wrote:
> > Hello,
> >
> > I currently am using raw sql to make an atomic operation of the following
> :
> >
> > UPDATE table SET field1 = 0, flag = 'A' WHERE flag = 'I'
> >
> > Reading the documentation I realized I could do this:
> >
> > Table.objects.filter(flag='I').update(field1=0,flag='A')
> >
> > I want to make sure that this is a unique operation. (to avoid problems
> of
> > parallelism and concurrency)
> >
> > Someone could confirm me this? Apparently the limitations imposed by the
> > documentation already gives a hint that is a single query but I want to
> be
> > sure.
> >
>

--~--~-~--~~~---~--~~
You received this message because you are subscribed to the Google Groups 
"Django users" group.
To post to this group, send email to django-users@googlegroups.com
To unsubscribe from this group, send email to 
django-users+unsubscr...@googlegroups.com
For more options, visit this group at 
http://groups.google.com/group/django-users?hl=en
-~--~~~~--~~--~--~---

Re: update() (for bulks) is a atomic operation?

[Mikhail Korobov]

Yes, it's a single query.

Take a look at django-debug-toolbar. It can display all SQL queries
that was executed during request/response so you'll always be sure
what's going on.

On 26 окт, 03:12, wancharle sebastiao quirino 
wrote:
> Hello,
>
> I currently am using raw sql to make an atomic operation of the following :
>
> UPDATE table SET field1 = 0, flag = 'A' WHERE flag = 'I'
>
> Reading the documentation I realized I could do this:
>
> Table.objects.filter(flag='I').update(field1=0,flag='A')
>
> I want to make sure that this is a unique operation. (to avoid problems of
> parallelism and concurrency)
>
> Someone could confirm me this? Apparently the limitations imposed by the
> documentation already gives a hint that is a single query but I want to be
> sure.
--~--~-~--~~~---~--~~
You received this message because you are subscribed to the Google Groups 
"Django users" group.
To post to this group, send email to django-users@googlegroups.com
To unsubscribe from this group, send email to 
django-users+unsubscr...@googlegroups.com
For more options, visit this group at 
http://groups.google.com/group/django-users?hl=en
-~--~~~~--~~--~--~---

update() (for bulks) is a atomic operation?

[wancharle sebastiao quirino]

Hello,

I currently am using raw sql to make an atomic operation of the following :

UPDATE table SET field1 = 0, flag = 'A' WHERE flag = 'I'

Reading the documentation I realized I could do this:

Table.objects.filter(flag='I').update(field1=0,flag='A')

I want to make sure that this is a unique operation. (to avoid problems of
parallelism and concurrency)

Someone could confirm me this? Apparently the limitations imposed by the
documentation already gives a hint that is a single query but I want to be
sure.

--~--~-~--~~~---~--~~
You received this message because you are subscribed to the Google Groups 
"Django users" group.
To post to this group, send email to django-users@googlegroups.com
To unsubscribe from this group, send email to 
django-users+unsubscr...@googlegroups.com
For more options, visit this group at 
http://groups.google.com/group/django-users?hl=en
-~--~~~~--~~--~--~---