From aba9c2de669dcc0278c7ffde7981be91801be00b Mon Sep 17 00:00:00 2001 From: Wu Haotian Date: Wed, 30 Jun 2021 18:45:10 +0800 Subject: Fixed #32226 -- Fixed JSON format of QuerySet.explain() on PostgreSQL. --- django/db/models/sql/compiler.py | 4 +++- 1 file changed, 3 insertions(+), 1 deletion(-) (limited to 'django/db/models/sql') diff --git a/django/db/models/sql/compiler.py b/django/db/models/sql/compiler.py index 136732bd0b..eda7fc3b5e 100644 --- a/django/db/models/sql/compiler.py +++ b/django/db/models/sql/compiler.py @@ -1,4 +1,5 @@ import collections +import json import re from functools import partial from itertools import chain @@ -1250,9 +1251,10 @@ class SQLCompiler: result = list(self.execute_sql()) # Some backends return 1 item tuples with strings, and others return # tuples with integers and strings. Flatten them out into strings. + output_formatter = json.dumps if self.query.explain_format == 'json' else str for row in result[0]: if not isinstance(row, str): - yield ' '.join(str(c) for c in row) + yield ' '.join(output_formatter(c) for c in row) else: yield row -- cgit v1.3