# HG changeset patch # User Radek Brich # Date 1406294116 -7200 # Node ID db4c582a2abd076a1f94dbbf475e09e78abf661f # Parent 10551741f61f3368419ccaa15ed45ed9f4c66f62 Fix autocommit mode in oursql. diff -r 10551741f61f -r db4c582a2abd pydbkit/mymanager_oursql.py --- a/pydbkit/mymanager_oursql.py Wed Jul 09 18:04:11 2014 +0200 +++ b/pydbkit/mymanager_oursql.py Fri Jul 25 15:15:16 2014 +0200 @@ -289,7 +289,10 @@ conn = oursql.connect(default_cursor=Cursor, **ci.parameters) if not ci.isolation_level is None: if ci.isolation_level == 'AUTOCOMMIT': - conn.autocommit(True) + # This is default in MySQL, but to be sure... + curs = conn.cursor() + curs.execute('SET autocommit = 1;') + curs.close() else: curs = conn.cursor() curs.execute('SET SESSION TRANSACTION ISOLATION LEVEL ' + ci.isolation_level)