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
30869	Setting to confirm destructive/weird migrations.	awiebe	nobody	"If altering or deleting a column could result in loss of data the migrate command should inform you, unless you have set a flag in the migration file that says you have provided an appropriate data migration.

When iterating, on non production code it's obviously fine if data is added and removed because you're just using test data anyway, but migrations make their way into production code, and then suddenly the fact that you deleted a column as part of an intermediate migration matters, even if you provided a replacement at some later point.  I would put a setting that prevents django from executing:

* Delete Model
* Remove Field
* Alter Field

Without a review of the migration. This could be a setting but maybe it should always be on.

If possible it would also be helpful if django would automatically split destructive operations and non destructive operations into two steps.  For example.

If I add a column that will contain the migrated data, and remove the column that held the old data, the operation to create and populate the new column needs to happen first.  I don't know if the migrator already handles this but iff not, then destructive operation should be pushed into a separate subsequent migration, where the ""data migration provided"" flag is already set.

I had this problem when I was trying to change a string field to a foreign key, and the migrator just turned my sqlite column from a string column to an integer, which is perfectly legal in sqlite for some reason.  But didn't actually I should have made a data migration that I didn't notice.

This was on a test database, but I essentially had to unpick weird things sqlite did, which could have been avoided if django had been a bit more conservative about migrating."	New feature	closed	Migrations	dev	Normal	wontfix	destructive,setting		Unreviewed	0	0	0	0	0	0