public void for_each_migration_script_downgraded_then_any_applied_script_stored_is_removed() { _mockMetadataProvider.Setup(m => m.SchemaExists(It.IsAny<string>())).Returns(true); _mockVersionRepository.Setup(m => m.GetCurrentVersion(It.IsAny<string>())).Returns(new DatabaseVersion(1234, Some.String())); var migration = new DownMigration(_mockMetadataProvider.Object, _mockVersionRepository.Object, _mockAppliedScriptsRepository.Object, false); migration.Migrate(SomeScripts, null, null, _mockScriptRunner.Object, Some.String(), Some.String()); _mockAppliedScriptsRepository.Verify(m => m.RemoveAppliedScript(SomeScripts[0].BackwardScript.AsDatabaseVersion(), It.IsAny<string>()), Times.Once); _mockAppliedScriptsRepository.Verify(m => m.RemoveAppliedScript(SomeScripts[1].BackwardScript.AsDatabaseVersion(), It.IsAny<string>()), Times.Once); }
public void if_force_is_specified_then_the_subsequent_migration_scripts_will_still_run() { _mockMetadataProvider.Setup(m => m.SchemaExists(It.IsAny<string>())).Returns(true); _mockVersionRepository.Setup(m => m.GetCurrentVersion(It.IsAny<string>())).Returns(new DatabaseVersion(1234, Some.String())); var migration = new DownMigration(_mockMetadataProvider.Object, _mockVersionRepository.Object, _mockAppliedScriptsRepository.Object, true); _mockScriptRunner.Setup(m => m.Execute(SomeScripts[1].BackwardScript)).Throws(new SqlPlusException()); Ignore.Exception(() => migration.Migrate(SomeScripts, null, null, _mockScriptRunner.Object, Some.String(), Some.String())); _mockVersionRepository.Verify(m => m.RemoveVersion(SomeScripts[2].BackwardScript.AsDatabaseVersion(), It.IsAny<string>()), Times.Once); _mockVersionRepository.Verify(m => m.RemoveVersion(SomeScripts[1].BackwardScript.AsDatabaseVersion(), It.IsAny<string>()), Times.Once); _mockVersionRepository.Verify(m => m.RemoveVersion(SomeScripts[0].BackwardScript.AsDatabaseVersion(), It.IsAny<string>()), Times.Once); }
private static void RunMigration(MigrationInfo migrationInfo, DatabaseVersion currentVersion, IEnumerable<Script> initScripts, IEnumerable<Script> upScripts, IEnumerable<Script> downScripts, IEnumerable<Script> termScripts, IList<IStep> storedSteps, IScriptRunner scriptRunner, IDatabaseMetadataProvider databaseMetadataProvider, IVersionRespository versionRespository, IAppliedScriptsRepository appliedScriptsRepository) { var upDownSteps = upScripts.Select(u => new DatabaseStep(u, downScripts.FirstOrDefault(d => d.Version == u.Version))).ToList(); var initTermSteps = initScripts.Select(i => new DatabaseStep(i, termScripts.FirstOrDefault(t => t.Version == i.Version))).ToList(); if (migrationInfo.Direction == MigrationDirection.Down) { var downMigration = new DownMigration(databaseMetadataProvider, versionRespository, appliedScriptsRepository, migrationInfo.Forced); if (storedSteps.Any()) { Output.Warn("NOTE: Using stored applied scripts to perform downgrade instead of local 'down' scripts."); downMigration.Migrate(storedSteps, currentVersion, migrationInfo.TargetVersion, scriptRunner, migrationInfo.TargetSchema, migrationInfo.TargetTablespace); } else { downMigration.Migrate(upDownSteps, currentVersion, migrationInfo.TargetVersion, scriptRunner, migrationInfo.TargetSchema, migrationInfo.TargetTablespace); } if (!migrationInfo.TargetVersion.HasValue) { var termMigration = new TermMigration(databaseMetadataProvider, migrationInfo.Forced); termMigration.Migrate(initTermSteps, currentVersion, migrationInfo.TargetVersion, scriptRunner, migrationInfo.TargetSchema, migrationInfo.TargetTablespace); } else { Output.Info("A target version was provided, termination scripts will not be executed."); } } else { var initMigration = new InitMigration(databaseMetadataProvider, migrationInfo.Forced); initMigration.Migrate(initTermSteps, currentVersion, migrationInfo.TargetVersion, scriptRunner, migrationInfo.TargetSchema, migrationInfo.TargetTablespace); EnsureVersioningTableIsInitialised(versionRespository, migrationInfo.TargetSchema, migrationInfo.TargetTablespace); EnsureAppliedScriptsTableIsInitialised(appliedScriptsRepository, migrationInfo.TargetSchema, migrationInfo.TargetTablespace); var upMigration = new UpMigration(versionRespository, appliedScriptsRepository, migrationInfo.Forced); upMigration.Migrate(upDownSteps, currentVersion, migrationInfo.TargetVersion, scriptRunner, migrationInfo.TargetSchema, migrationInfo.TargetTablespace); } }
public void when_there_are_no_migration_scripts_then_none_are_ever_executed() { _mockMetadataProvider.Setup(m => m.SchemaExists(It.IsAny<string>())).Returns(false); var migration = new DownMigration(_mockMetadataProvider.Object, _mockVersionRepository.Object, _mockAppliedScriptsRepository.Object, false); migration.Migrate(Enumerable.Empty<IStep>(), null, null, _mockScriptRunner.Object, Some.String(), Some.String()); _mockScriptRunner.Verify(m => m.Execute(It.IsAny<IScript>()), Times.Never); }
public void when_schema_exists_but_there_are_no_recorded_versions_then_do_not_run_any_migration_scripts() { _mockMetadataProvider.Setup(m => m.SchemaExists(It.IsAny<string>())).Returns(true); _mockVersionRepository.Setup(m => m.GetCurrentVersion(It.IsAny<string>())).Returns((DatabaseVersion)null); var migration = new DownMigration(_mockMetadataProvider.Object, _mockVersionRepository.Object, _mockAppliedScriptsRepository.Object, false); migration.Migrate(SomeScripts, null, null, _mockScriptRunner.Object, Some.String(), Some.String()); _mockScriptRunner.Verify(m => m.Execute(It.IsAny<IScript>()), Times.Never); }
public void when_schema_does_not_exist_then_do_not_run_any_migration_scripts() { _mockMetadataProvider.Setup(m => m.SchemaExists(It.IsAny<string>())).Returns(false); var migration = new DownMigration(_mockMetadataProvider.Object, _mockVersionRepository.Object, _mockAppliedScriptsRepository.Object, false); migration.Migrate(SomeScripts, null, null, _mockScriptRunner.Object, Some.String(), Some.String()); _mockScriptRunner.Verify(m => m.Execute(It.IsAny<IScript>()), Times.Never); }