public void Sqlizer_should_return_false_if_anything_goes_wrong()
{
// arrange
var dir = TestFileSystem.CreateTempWorkingDirectory();
TestFileSystem.RemoveDirectory(dir);
var sqlizer = new Sqlizer(Enumerable.Empty<IDirectoryValidationRule>(),
Enumerable.Empty<IPrerequisiteValidationRule>(),
Mock.Of<IScriptsExecutor>(),
Mock.Of<ILogger>());
// act
var result = sqlizer.RunDatabaseScripts(dir);
// assert
result.ShouldBeEquivalentTo(false);
}
public void Sqlizer_should_return_false_if_anything_goes_wrong()
{
// arrange
var dir = TestFileSystem.CreateTempWorkingDirectory();
TestFileSystem.RemoveDirectory(dir);
var sqlizer = new Sqlizer(Enumerable.Empty <IDirectoryValidationRule>(),
Enumerable.Empty <IPrerequisiteValidationRule>(),
Mock.Of <IScriptsExecutor>(),
Mock.Of <ILogger>());
// act
var result = sqlizer.RunDatabaseScripts(dir);
// assert
result.ShouldBeEquivalentTo(false);
}
public void Sqlizer_Should_Order_Files_For_Execution()
{
// arrange
var dir = TestFileSystem.CreateTempWorkingDirectory();
TestFileSystem.CreateFile(baseDirectory: dir, fileName: "01_script.sql");
TestFileSystem.CreateFile(baseDirectory: dir, fileName: "03_script.sql");
TestFileSystem.CreateFile(baseDirectory: dir, fileName: "20_script.sql");
TestFileSystem.CreateFile(baseDirectory: dir, fileName: "02_script.sql");
TestFileSystem.CreateFile(baseDirectory: dir, fileName: "10_script.sql");
TestFileSystem.CreateFile(baseDirectory: dir, fileName: "15_script.sql");
var actualResult = new List <string>();
var scriptExecutor = new Mock <IScriptsExecutor>();
scriptExecutor.Setup(s => s.Execute(It.IsAny <string>()))
.Callback <string>(actualResult.Add);
var sqlizer = new Sqlizer(Enumerable.Empty <IDirectoryValidationRule>(),
Enumerable.Empty <IPrerequisiteValidationRule>(),
scriptExecutor.Object,
Mock.Of <ILogger>());
// act
sqlizer.RunDatabaseScripts(dir);
// assert
actualResult.ShouldBeEquivalentTo(new List <string>
{
Path.Combine(dir, "01_script.sql"),
Path.Combine(dir, "02_script.sql"),
Path.Combine(dir, "03_script.sql"),
Path.Combine(dir, "10_script.sql"),
Path.Combine(dir, "15_script.sql"),
Path.Combine(dir, "20_script.sql")
});
}
public void Sqlizer_Should_Order_Files_For_Execution()
{
// arrange
var dir = TestFileSystem.CreateTempWorkingDirectory();
TestFileSystem.CreateFile(baseDirectory: dir, fileName: "01_script.sql");
TestFileSystem.CreateFile(baseDirectory: dir, fileName: "03_script.sql");
TestFileSystem.CreateFile(baseDirectory: dir, fileName: "20_script.sql");
TestFileSystem.CreateFile(baseDirectory: dir, fileName: "02_script.sql");
TestFileSystem.CreateFile(baseDirectory: dir, fileName: "10_script.sql");
TestFileSystem.CreateFile(baseDirectory: dir, fileName: "15_script.sql");
var actualResult = new List<string>();
var scriptExecutor = new Mock<IScriptsExecutor>();
scriptExecutor.Setup(s => s.Execute(It.IsAny<string>()))
.Callback<string>(actualResult.Add);
var sqlizer = new Sqlizer(Enumerable.Empty<IDirectoryValidationRule>(),
Enumerable.Empty<IPrerequisiteValidationRule>(),
scriptExecutor.Object,
Mock.Of<ILogger>());
// act
sqlizer.RunDatabaseScripts(dir);
// assert
actualResult.ShouldBeEquivalentTo(new List<string>
{
Path.Combine(dir, "01_script.sql"),
Path.Combine(dir, "02_script.sql"),
Path.Combine(dir, "03_script.sql"),
Path.Combine(dir, "10_script.sql"),
Path.Combine(dir, "15_script.sql"),
Path.Combine(dir, "20_script.sql")
});
}