From d7429defe6f8d1dce49976cf49827d18ff6be025 Mon Sep 17 00:00:00 2001 From: Tomasz Rybak Date: Sat, 23 Feb 2013 17:07:50 +0100 Subject: Add sqldropindexes to manage Change patch from https://code.djangoproject.com/ticket/5568 to work on modern Django. Add special case for MySQL which has different syntax for DROP INDEX. Add unit tests for the new functionality. --- tests/regressiontests/bash_completion/tests.py | 2 +- tests/regressiontests/commands_sql/tests.py | 9 ++++++++- 2 files changed, 9 insertions(+), 2 deletions(-) (limited to 'tests') diff --git a/tests/regressiontests/bash_completion/tests.py b/tests/regressiontests/bash_completion/tests.py index ed8cedf1ab..4fdb793feb 100644 --- a/tests/regressiontests/bash_completion/tests.py +++ b/tests/regressiontests/bash_completion/tests.py @@ -66,7 +66,7 @@ class BashCompletionTests(unittest.TestCase): "Subcommands can be autocompleted" self._user_input('django-admin.py sql') output = self._run_autocomplete() - self.assertEqual(output, ['sql sqlall sqlclear sqlcustom sqlflush sqlindexes sqlinitialdata sqlsequencereset']) + self.assertEqual(output, ['sql sqlall sqlclear sqlcustom sqldropindexes sqlflush sqlindexes sqlinitialdata sqlsequencereset']) def test_help(self): "No errors, just an empty list if there are no autocomplete options" diff --git a/tests/regressiontests/commands_sql/tests.py b/tests/regressiontests/commands_sql/tests.py index 723e5cc3f7..949032ae6f 100644 --- a/tests/regressiontests/commands_sql/tests.py +++ b/tests/regressiontests/commands_sql/tests.py @@ -2,7 +2,7 @@ from __future__ import unicode_literals from django.core.management.color import no_style from django.core.management.sql import (sql_create, sql_delete, sql_indexes, - sql_all) + sql_destroy_indexes, sql_all) from django.db import connections, DEFAULT_DB_ALIAS, models from django.test import TestCase from django.utils import six @@ -36,6 +36,13 @@ class SQLCommandsTestCase(TestCase): self.assertIn(len(output), [1, 2]) self.assertTrue(output[0].startswith("CREATE INDEX")) + def test_sql_destroy_indexes(self): + app = models.get_app('commands_sql') + output = sql_destroy_indexes(app, no_style(), connections[DEFAULT_DB_ALIAS]) + # PostgreSQL creates two indexes + self.assertIn(len(output), [1, 2]) + self.assertTrue(output[0].startswith("DROP INDEX")) + def test_sql_all(self): app = models.get_app('commands_sql') output = sql_all(app, no_style(), connections[DEFAULT_DB_ALIAS]) -- cgit v1.3