I am using mysql ith InooDB.
I have some cutsom sql doing inserts. These inserts are not visible
after the function returns, if I so something like
sql = 'INSERT INTO tbl1 ...'
from django.db import connection
cursor = connection.cursor()
cursor.execute(sql)
return cursor.fetchall()
However if I do something like
cursor.execute("set autocommit = 1")
and then do the above code the inserts are visible in a dirrent mysql
session.
So how does django transaction management work with custom sql, and
would my calling cursor.execute("set autocommit = 1") interfare with
it?
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"Django users" group.
To post to this group, send email to [email protected]
To unsubscribe from this group, send email to [EMAIL PROTECTED]
For more options, visit this group at
http://groups.google.com/group/django-users?hl=en
-~----------~----~----~----~------~----~------~--~---
