protected override void ProcessRecord() { base.ProcessRecord(); var infoTextWriter = new LambdaTextWriter(WriteVerbose); List<ChangeScript> allChangeScripts = new DirectoryScanner(infoTextWriter, Encoding.UTF8, new DirectoryInfo(this.deltasDirectory)) .GetChangeScripts(); var repository = new ChangeScriptRepository(allChangeScripts); var changeScripts = repository.GetAvailableChangeScripts(); DbmsFactory factory = new DbmsFactory(this.DatabaseType, this.ConnectionString); var queryExecuter = new QueryExecuter(factory); var schemaManager = new DatabaseSchemaVersionManager(queryExecuter, factory.CreateDbmsSyntax(), this.TableName); var appliedChanges = schemaManager.GetAppliedChanges(); var notAppliedChangeScripts = changeScripts.Where(c => appliedChanges.All(a => a.ScriptNumber != c.ScriptNumber)); var descriptionPrettyPrinter = new DescriptionPrettyPrinter(); var objects = notAppliedChangeScripts .Select(script => new { Id = script.ScriptNumber, Description = descriptionPrettyPrinter.Format(script.ScriptName), File = script.FileInfo }); this.WriteObject(objects, true); }
private void RunIntegratedTestAndConfirmOutputResults(string syntaxName, DirectoryInfo templateDirectory) { StringWriter writer = new StringWriter(); ChangeScript changeOne = new StubChangeScript(1, "001_change.sql", "-- contents of change script 1"); ChangeScript changeTwo = new StubChangeScript(2, "002_change.sql", "-- contents of change script 2"); List<ChangeScript> changeScripts = new List<ChangeScript> { changeOne, changeTwo }; ChangeScriptRepository changeScriptRepository = new ChangeScriptRepository(changeScripts); var factory = new DbmsFactory(syntaxName, string.Empty); var dbmsSyntax = factory.CreateDbmsSyntax(); var createChangeLogTable = false; StubSchemaManager schemaManager = new StubSchemaManager(dbmsSyntax, createChangeLogTable); IChangeScriptApplier applier = new TemplateBasedApplier(writer, dbmsSyntax, "ChangeLog", ";", new NormalDelimiter(), templateDirectory); Controller controller = new Controller(changeScriptRepository, schemaManager, applier, null, createChangeLogTable, System.Console.Out); controller.ProcessChangeScripts(null); var actual = writer.ToString(); try { Assert.AreEqual(this.ReadExpectedFileContents(this.GetExpectedFilename(syntaxName)), actual); } catch (Exception) { // Output actual template on failure. Console.WriteLine("\n\nActual Template ({0}):", syntaxName); Console.WriteLine(actual); throw; } }
private void GenerateUndoChangeScripts(ChangeScriptRepository repository, int lastChangeToApply, List<int> appliedChanges) { ChangeScriptExecuter undoScriptExecuter = new ChangeScriptExecuter(undoOutputPrintStream, dbmsSyntax, useTransaction); Controller undoController = new Controller(schemaManager, repository, undoScriptExecuter, infoPrintStream); undoController.ProcessUndoChangeScripts(lastChangeToApply, appliedChanges); undoOutputPrintStream.Flush(); }
protected override void ProcessRecord() { base.ProcessRecord(); var infoTextWriter = new LambdaTextWriter(WriteVerbose); List<ChangeScript> allChangeScripts = new DirectoryScanner(infoTextWriter).GetChangeScriptsForDirectory(new DirectoryInfo(_deltasDirectory)); var repository = new ChangeScriptRepository(allChangeScripts); var changeScripts = repository.GetOrderedListOfDoChangeScripts(); var appliedChangeNumbers = _databaseSchemaVersion.GetAppliedChangeNumbers(); var notAppliedChangeScripts = changeScripts.Where(c => !appliedChangeNumbers.Contains(c.GetId())); var descriptionPrettyPrinter = new DescriptionPrettyPrinter(); var objects = notAppliedChangeScripts .Select(script => new { Id = script.GetId(), Description = descriptionPrettyPrinter.Format(script.GetDescription()), File = script.GetFile() }); WriteObject(objects, true); }
public Controller(DatabaseSchemaVersionManager schemaManager, ChangeScriptRepository changeScriptRepository, ChangeScriptExecuter changeScriptExecuter) { this.schemaManager = schemaManager; this.changeScriptRepository = changeScriptRepository; this.changeScriptExecuter = changeScriptExecuter; }
public void DoDeploy(int lastChangeToApply) { Console.Out.WriteLine("dbdeploy v2.12"); List<ChangeScript> changeScripts = new DirectoryScanner(Console.Out).GetChangeScriptsForDirectory(dir); ChangeScriptRepository repository = new ChangeScriptRepository(changeScripts); List<int> appliedChanges = schemaManager.GetAppliedChangeNumbers(); GenerateChangeScripts(repository, lastChangeToApply, appliedChanges); if (undoOutputPrintStream != null) { GenerateUndoChangeScripts(repository, lastChangeToApply, appliedChanges); } }
public PowershellPrintStreamDeployer(DatabaseSchemaVersionManager schemaManager, ChangeScriptRepository repository, TextWriter outputPrintStream, IDbmsSyntax dbmsSyntax, bool useTransaction, TextWriter undoOutputPrintStream, TextWriter infoPrintStream) { this.schemaManager = schemaManager; this.doOutputPrintStream = outputPrintStream; this.dbmsSyntax = dbmsSyntax; this.useTransaction = useTransaction; this.undoOutputPrintStream = undoOutputPrintStream; this.infoPrintStream = infoPrintStream; this.repository = repository; }
public void TestChangeScriptsMayBeNumberedFromZero() { ChangeScript zero = new ChangeScript(0); ChangeScript four = new ChangeScript(4); ChangeScript[] scripts = new ChangeScript[] {zero, four}; ChangeScriptRepository repository = new ChangeScriptRepository(new List<ChangeScript>(scripts)); List<ChangeScript> list = repository.GetAvailableChangeScripts().ToList(); Assert.AreEqual(2, list.Count); Assert.AreSame(zero, list[0]); Assert.AreSame(four, list[1]); }
public void TestChangeScriptsMayBeNumberedFromZero() { ChangeScript zero = new ChangeScript(0); ChangeScript four = new ChangeScript(4); ChangeScript[] scripts = new ChangeScript[] { zero, four }; ChangeScriptRepository repository = new ChangeScriptRepository(new List <ChangeScript>(scripts)); List <ChangeScript> list = repository.GetOrderedListOfDoChangeScripts(); Assert.AreEqual(2, list.Count); Assert.AreSame(zero, list[0]); Assert.AreSame(four, list[1]); }
public void TestGivenASetOfChangeScriptsReturnsThemCorrectly() { ChangeScript one = new ChangeScript(1); ChangeScript two = new ChangeScript(2); ChangeScript three = new ChangeScript(3); ChangeScript four = new ChangeScript(4); ChangeScript[] scripts = {three, two, four, one}; ChangeScriptRepository repository = new ChangeScriptRepository(new List<ChangeScript>(scripts)); List<ChangeScript> list = repository.GetAvailableChangeScripts().ToList(); Assert.AreEqual(4, list.Count); Assert.AreSame(one, list[0]); Assert.AreSame(two, list[1]); Assert.AreSame(three, list[2]); Assert.AreSame(four, list[3]); }
public void TestGivenASetOfChangeScriptsReturnsThemCorrectly() { ChangeScript one = new ChangeScript(1); ChangeScript two = new ChangeScript(2); ChangeScript three = new ChangeScript(3); ChangeScript four = new ChangeScript(4); ChangeScript[] scripts = { three, two, four, one }; ChangeScriptRepository repository = new ChangeScriptRepository(new List <ChangeScript>(scripts)); List <ChangeScript> list = repository.GetOrderedListOfDoChangeScripts(); Assert.AreEqual(4, list.Count); Assert.AreSame(one, list[0]); Assert.AreSame(two, list[1]); Assert.AreSame(three, list[2]); Assert.AreSame(four, list[3]); }
private void RunIntegratedTestAndConfirmOutputResults(string syntaxName, DirectoryInfo templateDirectory) { StringWriter writer = new StringWriter(); ChangeScript changeOne = new StubChangeScript(1, "001_change.sql", "-- contents of change script 1"); ChangeScript changeTwo = new StubChangeScript(2, "002_change.sql", "-- contents of change script 2"); List<ChangeScript> changeScripts = new List<ChangeScript> { changeOne, changeTwo }; ChangeScriptRepository changeScriptRepository = new ChangeScriptRepository(changeScripts); var factory = new DbmsFactory(syntaxName, string.Empty); StubSchemaManager schemaManager = new StubSchemaManager(factory.CreateDbmsSyntax()); IChangeScriptApplier applier = new TemplateBasedApplier(writer, syntaxName, "changelog", ";", new NormalDelimiter(), templateDirectory); Controller controller = new Controller(changeScriptRepository, schemaManager, applier, null, System.Console.Out); controller.ProcessChangeScripts(null); Assert.AreEqual(this.ReadExpectedFileContents(this.GetExpectedFilename(syntaxName)), writer.ToString()); }
/// <summary> /// Executes the a database deployment with the specified config. /// </summary> /// <param name="config">The config.</param> /// <param name="infoWriter">The info writer.</param> /// <exception cref="System.InvalidOperationException">SQLCMD mode can only be applied against an mssql database.</exception> public void Execute(DbDeployConfig config, TextWriter infoWriter) { this.Validate(config, infoWriter); infoWriter.WriteLine(); infoWriter.WriteLine("=========================================================="); infoWriter.WriteLine(this.GenerateWelcomeString()); var factory = new DbmsFactory(config.Dbms, config.ConnectionString); var dbmsSyntax = factory.CreateDbmsSyntax(); var queryExecuter = new QueryExecuter(factory); var databaseSchemaVersionManager = new DatabaseSchemaVersionManager(queryExecuter, dbmsSyntax, config.ChangeLogTableName); var scanner = new DirectoryScanner(infoWriter, config.Encoding); var changeScriptRepository = new ChangeScriptRepository(scanner.GetChangeScriptsForDirectory(config.ScriptDirectory)); IChangeScriptApplier doScriptApplier; TextWriter doWriter = null; QueryExecuter applierExecutor = null; if (config.OutputFile != null) { doWriter = new StreamWriter(config.OutputFile.OpenWrite(), config.Encoding); doScriptApplier = new TemplateBasedApplier( doWriter, dbmsSyntax, config.ChangeLogTableName, config.Delimiter, config.DelimiterType, config.TemplateDirectory); } else if (config.UseSqlCmd) { // Verify database is MSSQL. if (!string.Equals(config.Dbms, "mssql", StringComparison.InvariantCultureIgnoreCase)) { throw new InvalidOperationException("SQLCMD mode can only be applied against an mssql database."); } doScriptApplier = new SqlCmdApplier( config.ConnectionString, databaseSchemaVersionManager, dbmsSyntax, config.ChangeLogTableName, infoWriter); } else { var splitter = new QueryStatementSplitter { Delimiter = config.Delimiter, DelimiterType = config.DelimiterType, LineEnding = config.LineEnding, }; // Do not share query executor between schema manager and applier, since a failure in one will effect the other. applierExecutor = new QueryExecuter(factory); doScriptApplier = new DirectToDbApplier( applierExecutor, databaseSchemaVersionManager, splitter, dbmsSyntax, config.ChangeLogTableName, infoWriter); } IChangeScriptApplier undoScriptApplier = null; TextWriter undoWriter = null; if (config.UndoOutputFile != null) { undoWriter = new StreamWriter(config.UndoOutputFile.OpenWrite(), config.Encoding); undoScriptApplier = new UndoTemplateBasedApplier( undoWriter, dbmsSyntax, config.ChangeLogTableName, config.Delimiter, config.DelimiterType, config.TemplateDirectory); } try { var controller = new Controller( changeScriptRepository, databaseSchemaVersionManager, doScriptApplier, undoScriptApplier, config.AutoCreateChangeLogTable, infoWriter); controller.ProcessChangeScripts(config.LastChangeToApply, config.ForceUpdate); queryExecuter.Close(); if (applierExecutor != null) { applierExecutor.Close(); } } finally { if (doWriter != null) { doWriter.Dispose(); } if (undoWriter != null) { undoWriter.Dispose(); } } }
public void Go() { this.Validate(); this.InfoWriter.WriteLine(this.GenerateWelcomeString()); var factory = new DbmsFactory(this.Dbms, this.ConnectionString); var dbmsSyntax = factory.CreateDbmsSyntax(); QueryExecuter queryExecuter = new QueryExecuter(factory); var databaseSchemaVersionManager = new DatabaseSchemaVersionManager(queryExecuter, dbmsSyntax, this.ChangeLogTableName); var scanner = new DirectoryScanner(this.InfoWriter, this.Encoding); var changeScriptRepository = new ChangeScriptRepository(scanner.GetChangeScriptsForDirectory(this.ScriptDirectory)); IChangeScriptApplier doScriptApplier; TextWriter doWriter = null; if (this.OutputFile != null) { doWriter = new StreamWriter(this.OutputFile.OpenWrite(), this.Encoding); doScriptApplier = new TemplateBasedApplier( doWriter, this.Dbms, this.ChangeLogTableName, this.Delimiter, this.DelimiterType, this.TemplateDir); } else { QueryStatementSplitter splitter = new QueryStatementSplitter { Delimiter = this.Delimiter, DelimiterType = this.DelimiterType, LineEnding = this.LineEnding, }; doScriptApplier = new DirectToDbApplier( queryExecuter, databaseSchemaVersionManager, splitter, this.InfoWriter); } IChangeScriptApplier undoScriptApplier = null; TextWriter undoWriter = null; if (this.UndoOutputFile != null) { undoWriter = new StreamWriter(this.UndoOutputFile.OpenWrite(), this.Encoding); undoScriptApplier = new UndoTemplateBasedApplier( undoWriter, this.Dbms, this.ChangeLogTableName, this.Delimiter, this.DelimiterType, this.TemplateDir); } try { Controller controller = new Controller( changeScriptRepository, databaseSchemaVersionManager, doScriptApplier, undoScriptApplier, this.InfoWriter); controller.ProcessChangeScripts(this.LastChangeToApply); queryExecuter.Close(); } finally { if (doWriter != null) doWriter.Dispose(); if (undoWriter != null) undoWriter.Dispose(); } }