sqlite3.version_info is deprecated since Python 3.12 and will be removed in Python 3.14

[Jun Omae]

​https://docs.python.org/3.12/library/sqlite3.html#sqlite3.version_info

After the following patch, it will retrieve pysqlite3.version_info only when pysqlite3 is used.

contrib/make_status.py

@@ -51 +51 @@
     ("Jinja2",            'jinja2.__version__'),
     ("multipart",         'multipart.__version__'),
     ("Babel",             'babel.__version__'),
-    ("sqlite3",           ('sqlite3.version',
-                           'sqlite3.sqlite_version')),
+    ("sqlite3",           'sqlite3.sqlite_version'),
     ("PySqlite3",         ('__main__._pysqlite3_version()',
                            'pysqlite3.dbapi2.sqlite_version')),
     ("PyMySQL",           'pymysql.__version__'),

trac/db/sqlite_backend.py

@@ -37 +37 @@
     import pysqlite3.dbapi2 as sqlite
 except ImportError:
     import sqlite3 as sqlite
+    pysqlite3_version = None
+else:
+    pysqlite3_version = get_pkginfo(sqlite).get('version', '%d.%d.%s' %
+                                                           sqlite.version_info)
 
 sqlite_version = sqlite.sqlite_version_info
 sqlite_version_string = sqlite.sqlite_version
-pysqlite_version = sqlite.version_info
-pysqlite_version_string = get_pkginfo(sqlite).get('version',
-                                                  '%d.%d.%s'
-                                                  % pysqlite_version)
 min_sqlite_version = (3, 0, 0)
 
 
@@ -273 +273 @@
 
     def get_system_info(self):
         yield 'SQLite', sqlite_version_string
-        yield 'pysqlite', pysqlite_version_string
+        if pysqlite3_version:
+            yield 'pysqlite3', pysqlite3_version
 
     @lazy
     def _extensions(self):

trac/tests/env.py

@@ -520 +520 @@
             self.assertEqual(info_before, info_after)
             self.assertRegex(get_info(info_before, 'SQLite'),
                              r'^\d+(\.\d+)+$')
-            self.assertRegex(get_info(info_before, 'pysqlite'),
-                             r'^\d+(\.\d+)+$')
         else:
             self.fail("Unknown value for dburi %s" % self.env.dburi)