qvx wrote:
> "autocommit off" attempt:
>
> connection_string = 'sqlite:/' + db_filename +'?autoCommit=0'
>
> "no select" attempt:
>
> t1 = T1(id=t1id, col1=r.col1, ...)
I changed :
conn_string = 'sqlite:/' + db_datoteka +'?autoCommit=0'
conn = connectionForURI(conn_string)
SQLObject._connection = conn
into:
conn_string = 'sqlite:/' + db_datoteka +'?autoCommit=0'
conn = connectionForURI(conn_string)
conn.autoCommit = False
tran = conn.transaction()
sqlhub.threadConnection = tran
This seems to help in performance department. But it now fails with
exception:
* when input is unicode
for ex: t1.col1 = unicode(col1, encoding='dbcs')
=> UnicodeEncodeError: 'ascii' codec can't encode character
u'\u0107' ...
File "sqlobject\col.py", line 498, in from_python
return value.encode("ascii")
* when input is 'utf8'
for ex: t1.col1 = unicode(col1, encoding='dbcs').encode('utf8')
=> UnicodeEncodeError: 'ascii' codec can't encode character
u'\u017d' ...
File "sqlobject\col.py", line 489, in to_python
return value.encode("ascii")
* when input is 'dbcs'
for ex: t1.col1 = col1_var # col1_var it is already in 'dbcs'
=> UnicodeDecodeError: 'utf8' codec can't decode bytes ...
File "sqlobject\dbconnection.py", line 295, in _executeRetry
return cursor.execute(query)
P.S. I'm a Windows Central European (windows-1250) user and my
sys.setdefaultencoding is 'dbcs'.
--
http://mail.python.org/mailman/listinfo/python-list
