[Python-checkins] bpo-25130: Make SQLite tests more compatible with PyPy (GH-28021)

[miss-islington]

https://github.com/python/cpython/commit/a49398b643b3a2e6f9cc39729c528eb1e4385b1a
commit: a49398b643b3a2e6f9cc39729c528eb1e4385b1a
branch: 3.10
author: Miss Islington (bot) <31488909+miss-islington at users.noreply.github.com>
committer: miss-islington <31488909+miss-islington at users.noreply.github.com>
date: 2021-08-29T03:43:48-07:00
summary:

bpo-25130: Make SQLite tests more compatible with PyPy (GH-28021)

(cherry picked from commit 07d3d54f4e84b1259b800884b202701f69e408d8)

Co-authored-by: Serhiy Storchaka <storchaka at gmail.com>

files:
M Lib/sqlite3/test/dbapi.py
M Lib/sqlite3/test/regression.py

diff --git a/Lib/sqlite3/test/dbapi.py b/Lib/sqlite3/test/dbapi.py
index 5d521d0cce5e1..a8dcd7e8bfedd 100644
--- a/Lib/sqlite3/test/dbapi.py
+++ b/Lib/sqlite3/test/dbapi.py
@@ -398,6 +398,9 @@ class MyIter:
             def __init__(self):
                 self.value = 5
 
+            def __iter__(self):
+                return self
+
             def __next__(self):
                 if self.value == 10:
                     raise StopIteration
diff --git a/Lib/sqlite3/test/regression.py b/Lib/sqlite3/test/regression.py
index 417a53109c87c..70d0ff9af1071 100644
--- a/Lib/sqlite3/test/regression.py
+++ b/Lib/sqlite3/test/regression.py
@@ -125,11 +125,11 @@ def test_type_map_usage(self):
         con = sqlite.connect(":memory:",detect_types=sqlite.PARSE_DECLTYPES)
         con.execute("create table foo(bar timestamp)")
         con.execute("insert into foo(bar) values (?)", (datetime.datetime.now(),))
-        con.execute(SELECT)
+        con.execute(SELECT).close()
         con.execute("drop table foo")
         con.execute("create table foo(bar integer)")
         con.execute("insert into foo(bar) values (5)")
-        con.execute(SELECT)
+        con.execute(SELECT).close()
 
     def test_bind_mutating_list(self):
         # Issue41662: Crash when mutate a list of parameters during iteration.