gh-69093: Expose sqlite3.Blob as a class (GH-91550)

JelleZijlstra · web-flow · commit b7f83bdd0e16 · 2022-04-15T06:29:57.000-07:00
I noticed this was missing while writing typeshed stubs. It's
useful to expose it for use in annotations and for exploration.
diff --git a/Lib/test/test_sqlite3/test_dbapi.py b/Lib/test/test_sqlite3/test_dbapi.py
@@ -1055,6 +1055,9 @@ def tearDown(self):
         self.blob.close()
         self.cx.close()
 
+    def test_blob_is_a_blob(self):
+        self.assertIsInstance(self.blob, sqlite.Blob)
+
     def test_blob_seek_and_tell(self):
         self.blob.seek(10)
         self.assertEqual(self.blob.tell(), 10)
diff --git a/Modules/_sqlite/module.c b/Modules/_sqlite/module.c
@@ -697,6 +697,7 @@ module_exec(PyObject *module)
     }
 
     pysqlite_state *state = pysqlite_get_state(module);
+    ADD_TYPE(module, state->BlobType);
     ADD_TYPE(module, state->ConnectionType);
     ADD_TYPE(module, state->CursorType);
     ADD_TYPE(module, state->PrepareProtocolType);

Original file line number	Diff line number	Diff line change
`@@ -697,6 +697,7 @@ module_exec(PyObject *module)`
`697`	`697`	`}`
`698`	`698`
`699`	`699`	`pysqlite_state *state = pysqlite_get_state(module);`
	`700`	`+ ADD_TYPE(module, state->BlobType);`
`700`	`701`	`ADD_TYPE(module, state->ConnectionType);`
`701`	`702`	`ADD_TYPE(module, state->CursorType);`
`702`	`703`	`ADD_TYPE(module, state->PrepareProtocolType);`