summaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorMariusz Felisiak <felisiak.mariusz@gmail.com>2019-04-29 10:38:17 +0200
committerGitHub <noreply@github.com>2019-04-29 10:38:17 +0200
commited880d92b50c641c3e7f6e8ce5741085ffe1f8fb (patch)
treea7443b99607054e8fab0f75fda5fcd62338f3c16
parent0dd2308cf6f559a4f4b50edd7c005c7cf025d1aa (diff)
Added tests for queries log in CursorDebugWrapper.executemany().
-rw-r--r--tests/backends/tests.py20
1 files changed, 17 insertions, 3 deletions
diff --git a/tests/backends/tests.py b/tests/backends/tests.py
index 7d5dbe7a39..da20d94442 100644
--- a/tests/backends/tests.py
+++ b/tests/backends/tests.py
@@ -429,18 +429,32 @@ class BackendTestCase(TransactionTestCase):
"""
Test the documented API of connection.queries.
"""
+ sql = 'SELECT 1' + connection.features.bare_select_suffix
with connection.cursor() as cursor:
reset_queries()
- cursor.execute("SELECT 1" + connection.features.bare_select_suffix)
+ cursor.execute(sql)
self.assertEqual(1, len(connection.queries))
-
self.assertIsInstance(connection.queries, list)
self.assertIsInstance(connection.queries[0], dict)
- self.assertCountEqual(connection.queries[0], ['sql', 'time'])
+ self.assertEqual(list(connection.queries[0]), ['sql', 'time'])
+ self.assertEqual(connection.queries[0]['sql'], sql)
reset_queries()
self.assertEqual(0, len(connection.queries))
+ sql = ('INSERT INTO %s (%s, %s) VALUES (%%s, %%s)' % (
+ connection.introspection.identifier_converter('backends_square'),
+ connection.ops.quote_name('root'),
+ connection.ops.quote_name('square'),
+ ))
+ with connection.cursor() as cursor:
+ cursor.executemany(sql, [(1, 1), (2, 4)])
+ self.assertEqual(1, len(connection.queries))
+ self.assertIsInstance(connection.queries, list)
+ self.assertIsInstance(connection.queries[0], dict)
+ self.assertEqual(list(connection.queries[0]), ['sql', 'time'])
+ self.assertEqual(connection.queries[0]['sql'], '2 times: %s' % sql)
+
# Unfortunately with sqlite3 the in-memory test database cannot be closed.
@skipUnlessDBFeature('test_db_allows_multiple_connections')
@override_settings(DEBUG=True)