Fixed #28853 -- Updated connection.cursor() uses to use a context manager.

1 files changed, 12 insertions, 12 deletions

diff --git a/tests/backends/postgresql/test_introspection.py b/tests/backends/postgresql/test_introspection.py
index cfa801a77f..4dcadbd733 100644
--- a/tests/backends/postgresql/test_introspection.py
+++ b/tests/backends/postgresql/test_introspection.py
@@ -9,15 +9,15 @@ from ..models import Person
 @unittest.skipUnless(connection.vendor == 'postgresql', "Test only for PostgreSQL")
 class DatabaseSequenceTests(TestCase):
     def test_get_sequences(self):
-        cursor = connection.cursor()
-        seqs = connection.introspection.get_sequences(cursor, Person._meta.db_table)
-        self.assertEqual(
-            seqs,
-            [{'table': Person._meta.db_table, 'column': 'id', 'name': 'backends_person_id_seq'}]
-        )
-        cursor.execute('ALTER SEQUENCE backends_person_id_seq RENAME TO pers_seq')
-        seqs = connection.introspection.get_sequences(cursor, Person._meta.db_table)
-        self.assertEqual(
-            seqs,
-            [{'table': Person._meta.db_table, 'column': 'id', 'name': 'pers_seq'}]
-        )
+        with connection.cursor() as cursor:
+            seqs = connection.introspection.get_sequences(cursor, Person._meta.db_table)
+            self.assertEqual(
+                seqs,
+                [{'table': Person._meta.db_table, 'column': 'id', 'name': 'backends_person_id_seq'}]
+            )
+            cursor.execute('ALTER SEQUENCE backends_person_id_seq RENAME TO pers_seq')
+            seqs = connection.introspection.get_sequences(cursor, Person._meta.db_table)
+            self.assertEqual(
+                seqs,
+                [{'table': Person._meta.db_table, 'column': 'id', 'name': 'pers_seq'}]
+            )