id	summary	reporter	owner	description	type	status	component	version	severity	resolution	keywords	cc	stage	has_patch	needs_docs	needs_tests	needs_better_patch	easy	ui_ux
31318	sqlmigrate doesn't allow inspecting migrations that have been squashed	Adam Johnson	David Wobrock	"This project for another ticket can be used to reproduce: https://github.com/adamchainz/django-unique-together-bug

When running sqlmigrate to pick up migration 0001 in this project, it complains that two migrations have that prefix:

{{{
$ python manage.py sqlmigrate testapp 0001
CommandError: More than one migration matches '0001' in app 'testapp'. Please be more specific.
}}}

But when trying to be more specific, it's not possible to load it:

{{{
$ python manage.py sqlmigrate testapp 0001_initial
Traceback (most recent call last):
  File ""manage.py"", line 21, in <module>
    main()
  File ""manage.py"", line 17, in main
    execute_from_command_line(sys.argv)
  File ""/.../django/django/core/management/__init__.py"", line 401, in execute_from_command_line
    utility.execute()
  File ""/.../django/django/core/management/__init__.py"", line 395, in execute
    self.fetch_command(subcommand).run_from_argv(self.argv)
  File ""/.../django/django/core/management/base.py"", line 328, in run_from_argv
    self.execute(*args, **cmd_options)
  File ""/.../django/django/core/management/commands/sqlmigrate.py"", line 30, in execute
    return super().execute(*args, **options)
  File ""/.../django/django/core/management/base.py"", line 369, in execute
    output = self.handle(*args, **options)
  File ""/.../django/django/core/management/commands/sqlmigrate.py"", line 64, in handle
    plan = [(executor.loader.graph.nodes[targets[0]], options['backwards'])]
KeyError: ('testapp', '0001_initial')
}}}

It would be nice to:

A) catch this error and report a nice message as well
B) allow inspection of individual migrations that have been involved in a squash. Normally the workflow is to remove the individual migrations some time after committing the squash, but until that is done it could be useful to see their sql."	Cleanup/optimization	closed	Migrations	dev	Normal	fixed			Ready for checkin	1	0	0	0	0	0