rollback the update query

2015-05-11 Thread Simran Singh
I am really new to Django and I am using Django 1.8. Many of the manual_transaction features have been depreciated in this. I have used *@transaction.atomic(None, True)* to pack the transaction and rollback the updates if at any point the condition is not met. I tried to store the transaction

Re: rollback the update query

2015-05-11 Thread Simran Singh
, 'HOST': 'localhost', # Or an IP Address that your DB is hosted on 'PORT': '3306', 'AUTOCOMMIT': 'False', } I am using InnoDB engine with mysql. Thanks, Simran On Monday, May 11, 2015 at 4:27:50 PM UTC+5:

Re: rollback the update query

2015-05-12 Thread Simran Singh
able to redirect the flow to some template but all the transactions are being committed and rollback functionality is not working. Thanks, Simran On Monday, May 11, 2015 at 4:27:50 PM UTC+5:30, Simran Singh wrote: > > I am really new to Django and I am using Django 1.8. Many

Re: rollback the update query

2015-05-13 Thread Simran Singh
Tom, basically I want to discard everything that is stored in transaction.savepoint. As per my current case, it is getting committed no matter where the flow goes. Regards, Simran On Monday, May 11, 2015 at 4:27:50 PM UTC+5:30, Simran Singh wrote: > > I am really new to Django and I am

Re: rollback the update query

2015-05-13 Thread Simran Singh
*. If an exception is thrown and not caught, *then changes are not committed* but the flow is disturbed. So is there any other way to stop my transaction from being committed. Regards, Simran On Monday, May 11, 2015 at 4:27:50 PM UTC+5:30, Simran Singh wrote: > > I am really new to Django

Re: rollback the update query

2015-05-13 Thread Simran Singh
goes into except, it gives above error message. Regards, Simran On Monday, May 11, 2015 at 4:27:50 PM UTC+5:30, Simran Singh wrote: > > I am really new to Django and I am using Django 1.8. Many of the > manual_transaction features have been depreciated in this. I have used > *@transa

Re: rollback the update query

2015-05-13 Thread Simran Singh
working and giving error. Lets hope to close this issue soon :( Regards, Simran On Monday, May 11, 2015 at 4:27:50 PM UTC+5:30, Simran Singh wrote: > > I am really new to Django and I am using Django 1.8. Many of the > manual_transaction features have been depreciated in this. I

Re: rollback the update query

2015-05-13 Thread Simran Singh
Hi James, Yes, it workedd :) I created the object outside the method and called it at every transaction point in the loop and when there is rollback, it rollbacks all the queries. Thanks James Regards, Simran On Monday, May 11, 2015 at 4:27:50 PM UTC+5:30, Simran Singh wrote: > > I am

Re: rollback the update query

2015-05-13 Thread Simran Singh
Hi Tom, Thanks a lot for your efforts. It worked with savepoint called before update query. Thank you Regards, Simran On Monday, May 11, 2015 at 4:27:50 PM UTC+5:30, Simran Singh wrote: > > I am really new to Django and I am using Django 1.8. Many of the > manual_transaction feat