public void atualizar_status_do_script_para_sucess_revised_user() { const string conteudoSql = "Create Table tabelaTeste (id int not null, name varchar(45) not null, primary key (id));"; var changeScript = new ChangeScript("1.0.0.0", 1); splitter.Setup(s => s.Split(It.IsAny <string>())).Returns <string>(s => new[] { s }); var directToDbApplier = new DirectToDbApplier(queryExecuter.Object, schemaVersionManager.Object, splitter.Object, new Mock <IDbmsSyntax>().Object, ChangeLogTableName, System.Console.Out); directToDbApplier.ApplyScriptContent(changeScript, conteudoSql, true); schemaVersionManager.Verify(x => x.RecordScriptStatus(changeScript, ScriptStatus.SucessRevisedUser, It.IsAny <string>()), Times.Once); }
public void executar_script_passando_conteudo() { const string conteudoSql = "Create Table tabelaTeste (id int not null, name varchar(45) not null, primary key (id));"; var changeScript = new ChangeScript("1.0.0.0", 1); splitter.Setup(s => s.Split(It.IsAny <string>())).Returns <string>(s => new[] { s }); var directToDbApplier = new DirectToDbApplier(queryExecuter.Object, schemaVersionManager.Object, splitter.Object, new Mock <IDbmsSyntax>().Object, ChangeLogTableName, System.Console.Out); directToDbApplier.ApplyScriptContent(changeScript, conteudoSql, true); queryExecuter.Verify(x => x.Execute(conteudoSql, It.IsAny <StringBuilder>()), Times.Once); }
public void nao_criar_tabela_changelog() { const string conteudoSql = "Create Table tabelaTeste (id int not null, name varchar(45) not null, primary key (id));"; var changeScript = new ChangeScript("1.0.0.0", 1); splitter.Setup(s => s.Split(It.IsAny <string>())).Returns <string>(s => new[] { s }); dbmsSyntax = new MsSqlDbmsSyntax(); var changeLogTableSqlScript = dbmsSyntax.CreateChangeLogTableSqlScript(ChangeLogTableName); var directToDbApplier = new DirectToDbApplier(queryExecuter.Object, schemaVersionManager.Object, splitter.Object, dbmsSyntax, ChangeLogTableName, System.Console.Out); directToDbApplier.ApplyScriptContent(changeScript, conteudoSql, false); schemaVersionManager.Verify(x => x.RecordScriptStatus(changeScript, ScriptStatus.SucessRevisedUser, It.IsAny <string>()), Times.Once); queryExecuter.Verify(x => x.Execute(changeLogTableSqlScript), Times.Never()); }
public void nao_criar_tabela_changelog() { const string conteudoSql = "Create Table tabelaTeste (id int not null, name varchar(45) not null, primary key (id));"; var changeScript = new ChangeScript("1.0.0.0", 1); splitter.Setup(s => s.Split(It.IsAny<string>())).Returns<string>(s => new[] { s }); dbmsSyntax = new MsSqlDbmsSyntax(); var changeLogTableSqlScript = dbmsSyntax.CreateChangeLogTableSqlScript(ChangeLogTableName); var directToDbApplier = new DirectToDbApplier(queryExecuter.Object, schemaVersionManager.Object, splitter.Object, dbmsSyntax, ChangeLogTableName, System.Console.Out); directToDbApplier.ApplyScriptContent(changeScript, conteudoSql, false); schemaVersionManager.Verify(x => x.RecordScriptStatus(changeScript, ScriptStatus.SucessRevisedUser, It.IsAny<string>()), Times.Once); queryExecuter.Verify(x => x.Execute(changeLogTableSqlScript), Times.Never()); }
public void atualizar_status_do_script_para_sucess_revised_user() { const string conteudoSql = "Create Table tabelaTeste (id int not null, name varchar(45) not null, primary key (id));"; var changeScript = new ChangeScript("1.0.0.0", 1); splitter.Setup(s => s.Split(It.IsAny<string>())).Returns<string>(s => new[] { s }); var directToDbApplier = new DirectToDbApplier(queryExecuter.Object, schemaVersionManager.Object, splitter.Object, new Mock<IDbmsSyntax>().Object, ChangeLogTableName, System.Console.Out); directToDbApplier.ApplyScriptContent(changeScript, conteudoSql, true); schemaVersionManager.Verify(x => x.RecordScriptStatus(changeScript, ScriptStatus.SucessRevisedUser, It.IsAny<string>()), Times.Once); }
public void executar_script_passando_conteudo() { const string conteudoSql = "Create Table tabelaTeste (id int not null, name varchar(45) not null, primary key (id));"; var changeScript = new ChangeScript("1.0.0.0", 1); splitter.Setup(s => s.Split(It.IsAny<string>())).Returns<string>(s => new[] { s }); var directToDbApplier = new DirectToDbApplier(queryExecuter.Object, schemaVersionManager.Object, splitter.Object, new Mock<IDbmsSyntax>().Object, ChangeLogTableName, System.Console.Out); directToDbApplier.ApplyScriptContent(changeScript, conteudoSql, true); queryExecuter.Verify(x => x.Execute(conteudoSql, It.IsAny<StringBuilder>()), Times.Once); }