agesys-dev team mailing list archive

[Chris Petersen <785305@xxxxxxxxxxxxxxxxxx>]

SET autocommit='OFF' is a connection setting, not a cursor setting.
Wouldn't it be a little more efficient to run at connection time rather
than every time a cursor is created?

-- 
You received this bug notification because you are a member of Agesys
Team, which is subscribed to oursql.
https://bugs.launchpad.net/bugs/785305

Title:
  Disable autocommit for new connections

Status in oursql:
  New

Bug description:
  I could very well be wrong on this, but from my understanding,
  autocommit should be disabled for databases such as MySQL that have
  this feature to be compliant with python's DB-API. I had an agonizing
  time discovering this when trying to get test cases to rollback when
  run on oursql. Perhaps oursql, similar to MySQLdb should set
  autocommit off for new cursors.