New submission from Erlend E. Aasland <[email protected]>:
While working on bpo-45126 / GH-28227 (and while working on the AC conversion,
bpo-40956), I've been slightly frustrated on the implementation of sqlite3
"isolation level". The code is messy, and we've got two connection members that
carry pretty much the same type of information (self->isolation_level, and
self->begin_statement).
I would like to make the following enhancements:
- merge 'isolation_level' and 'begin_statement' members in some kind of way
- split pysqlite_connection_set_isolation_level():
+ one method for parsing and storing the 'isolation_level' member
+ one method for carrying out any needed SQLite API operation
This should result in a cleaner connection __init__() method.
Another slightly related performance enhancement could be to cache the "begin"
(and "commit") statements as sqlite3_stmt pointers on the connection object,
but that is a digression.
----------
components: Extension Modules
messages: 404182
nosy: erlendaasland
priority: low
severity: normal
status: open
title: [sqlite3] simplify "isolation level"
versions: Python 3.11
_______________________________________
Python tracker <[email protected]>
<https://bugs.python.org/issue45512>
_______________________________________
_______________________________________________
Python-bugs-list mailing list
Unsubscribe:
https://mail.python.org/mailman/options/python-bugs-list/archive%40mail-archive.com
