def test_running_without_changes(self):
project_state = self.set_up_test_model("test_arstd")
operation = AlterStorageEngine("Pony", from_engine="MyISAM",
to_engine="InnoDB")
assert table_storage_engine("test_arstd_pony") == "InnoDB"
# Forwards - shouldn't actually do an ALTER since it is already InnoDB
new_state = project_state.clone()
operation.state_forwards("test_arstd", new_state)
capturer = CaptureQueriesContext(connection)
with capturer, connection.schema_editor() as editor:
operation.database_forwards("test_arstd", editor, project_state,
new_state)
queries = [q['sql'] for q in capturer.captured_queries]
assert not any(q.startswith('ALTER TABLE ') for q in queries), (
"One of the executed queries was an unexpected ALTER TABLE:\n{}"
.format("\n".join(queries))
)
assert table_storage_engine("test_arstd_pony") == "InnoDB"
# Backwards - will actually ALTER since it is going 'back' to MyISAM
with connection.schema_editor() as editor:
operation.database_backwards("test_arstd", editor, new_state,
project_state)
assert table_storage_engine("test_arstd_pony") == "MyISAM"
def test_running_with_changes(self):
project_state = self.set_up_test_model("test_arstd")
operation = AlterStorageEngine("Pony", from_engine="MyISAM",
to_engine="InnoDB")
assert table_storage_engine("test_arstd_pony") == "MyISAM"
# Forwards
new_state = project_state.clone()
operation.state_forwards("test_arstd", new_state)
with connection.schema_editor() as editor:
operation.database_forwards("test_arstd", editor, project_state,
new_state)
assert table_storage_engine("test_arstd_pony") == "InnoDB"
# Backwards
with connection.schema_editor() as editor:
operation.database_backwards("test_arstd", editor, new_state,
project_state)
assert table_storage_engine("test_arstd_pony") == "MyISAM"