diff options
| author | Mariusz Felisiak <felisiak.mariusz@gmail.com> | 2019-04-29 10:38:17 +0200 |
|---|---|---|
| committer | GitHub <noreply@github.com> | 2019-04-29 10:38:17 +0200 |
| commit | ed880d92b50c641c3e7f6e8ce5741085ffe1f8fb (patch) | |
| tree | a7443b99607054e8fab0f75fda5fcd62338f3c16 | |
| parent | 0dd2308cf6f559a4f4b50edd7c005c7cf025d1aa (diff) | |
Added tests for queries log in CursorDebugWrapper.executemany().
| -rw-r--r-- | tests/backends/tests.py | 20 |
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) |
