Fix DeprecationWarning on 3.12 with a datetime adapter for sqlite3 (#14139)

Carreau · web-flow · commit 46c7ccf03476 · 2023-08-28T14:27:06.000+02:00
After python/cpython#90016, default adapters and converters are deprecated. See also https://docs.python.org/3.12/library/sqlite3.html#sqlite3-adapter-converter-recipes
diff --git a/IPython/core/history.py b/IPython/core/history.py
@@ -574,17 +574,23 @@ def new_session(self, conn=None):
             cur = conn.execute(
                 """INSERT INTO sessions VALUES (NULL, ?, NULL,
                             NULL, '') """,
-                (datetime.datetime.now(),),
+                (datetime.datetime.now().isoformat(" "),),
             )
             self.session_number = cur.lastrowid
 
     def end_session(self):
         """Close the database session, filling in the end time and line count."""
         self.writeout_cache()
         with self.db:
-            self.db.execute("""UPDATE sessions SET end=?, num_cmds=? WHERE
-                            session==?""", (datetime.datetime.now(),
-                            len(self.input_hist_parsed)-1, self.session_number))
+            self.db.execute(
+                """UPDATE sessions SET end=?, num_cmds=? WHERE
+                            session==?""",
+                (
+                    datetime.datetime.now().isoformat(" "),
+                    len(self.input_hist_parsed) - 1,
+                    self.session_number,
+                ),
+            )
         self.session_number = 0
 
     def name_session(self, name):
diff --git a/IPython/core/logger.py b/IPython/core/logger.py
@@ -20,7 +20,6 @@
 import time
 
 
-
 # prevent jedi/parso's debug messages pipe into interactiveshell
 logging.getLogger("parso").setLevel(logging.WARNING)
 
