#34859: Format SQL code prodcued by sqlmigrate
-------------------------------------+-------------------------------------
Reporter: Paolo | Owner: nobody
Melchiorre |
Type: New | Status: new
feature |
Component: | Version: dev
Migrations | Keywords: sql, sqlmigrate,
Severity: Normal | migrations
Triage Stage: | Has patch: 0
Unreviewed |
Needs documentation: 0 | Needs tests: 0
Patch needs improvement: 0 | Easy pickings: 0
UI/UX: 0 |
-------------------------------------+-------------------------------------
I propose to use `sqlparse`, which is already a Django dependency, to
format the SQL code generated by the `sqlmigrate` command.
{{{#!diff
diff --git a/django/core/management/commands/sqlmigrate.py
b/django/core/management/commands/sqlmigrate.py
index 2f6993682f..158bcf722b 100644
--- a/django/core/management/commands/sqlmigrate.py
+++ b/django/core/management/commands/sqlmigrate.py
@@ -1,3 +1,5 @@
+import sqlparse
+
from django.apps import apps
from django.core.management.base import BaseCommand, CommandError
from django.db import DEFAULT_DB_ALIAS, connections
@@ -80,4 +82,4 @@ class Command(BaseCommand):
sql_statements = loader.collect_sql(plan)
if not sql_statements and options["verbosity"] >= 1:
self.stderr.write("No operations found.")
- return "\n".join(sql_statements)
+ return sqlparse.format("\n".join(sql_statements), reindent=True)
}}}
--
Ticket URL: <https://code.djangoproject.com/ticket/34859>
Django <https://code.djangoproject.com/>
The Web framework for perfectionists with deadlines.
--
You received this message because you are subscribed to the Google Groups
"Django updates" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
To view this discussion on the web visit
https://groups.google.com/d/msgid/django-updates/0107018ab74c442d-28275bf0-085d-43d5-a703-20ded9c7deeb-000000%40eu-central-1.amazonses.com.
