Fixed #30595 -- Added error message when no objects found to sql* management commands.

6 files changed, 30 insertions, 0 deletions

diff --git a/tests/empty_models/__init__.py b/tests/empty_models/__init__.py
new file mode 100644
index 0000000000..e69de29bb2
--- /dev/null
+++ b/tests/empty_models/__init__.py
diff --git a/tests/empty_models/models.py b/tests/empty_models/models.py
new file mode 100644
index 0000000000..e69de29bb2
--- /dev/null
+++ b/tests/empty_models/models.py
diff --git a/tests/empty_models/test_commands.py b/tests/empty_models/test_commands.py
new file mode 100644
index 0000000000..5dd4744033
--- /dev/null
+++ b/tests/empty_models/test_commands.py
@@ -0,0 +1,18 @@
+import io
+
+from django.core.management import call_command
+from django.test import TestCase
+
+
+class CoreCommandsNoOutputTests(TestCase):
+    available_apps = ['empty_models']
+
+    def test_sqlflush_no_tables(self):
+        err = io.StringIO()
+        call_command('sqlflush', stderr=err)
+        self.assertEqual(err.getvalue(), 'No tables found.\n')
+
+    def test_sqlsequencereset_no_sequences(self):
+        err = io.StringIO()
+        call_command('sqlsequencereset', 'empty_models', stderr=err)
+        self.assertEqual(err.getvalue(), 'No sequences found.\n')
diff --git a/tests/migrations/test_commands.py b/tests/migrations/test_commands.py
index a15ae461ce..4132b96be0 100644
--- a/tests/migrations/test_commands.py
+++ b/tests/migrations/test_commands.py
@@ -645,6 +645,12 @@ class MigrateTests(MigrationTestBase):
             self.assertNotIn(start_transaction_sql.lower(), queries)
         self.assertNotIn(connection.ops.end_transaction_sql().lower(), queries)
 
+    @override_settings(MIGRATION_MODULES={'migrations': 'migrations.test_migrations_no_operations'})
+    def test_migrations_no_operations(self):
+        err = io.StringIO()
+        call_command('sqlmigrate', 'migrations', '0001_initial', stderr=err)
+        self.assertEqual(err.getvalue(), 'No operations found.\n')
+
     @override_settings(
         INSTALLED_APPS=[
             "migrations.migrations_test_apps.migrated_app",
diff --git a/tests/migrations/test_migrations_no_operations/0001_initial.py b/tests/migrations/test_migrations_no_operations/0001_initial.py
new file mode 100644
index 0000000000..a07dd888da
--- /dev/null
+++ b/tests/migrations/test_migrations_no_operations/0001_initial.py
@@ -0,0 +1,6 @@
+from django.db import migrations
+
+
+class Migration(migrations.Migration):
+    dependencies = []
+    operations = []
diff --git a/tests/migrations/test_migrations_no_operations/__init__.py b/tests/migrations/test_migrations_no_operations/__init__.py
new file mode 100644
index 0000000000..e69de29bb2
--- /dev/null
+++ b/tests/migrations/test_migrations_no_operations/__init__.py