public void ProcessPath_DirectorySpecified_ShouldProcessSubDirectories()
{
// arrange
const string filePath1 = @"c:\dbscripts\file1.SQL";
const string filePath2 = @"c:\dbscripts\db1\file2.sql";
const string filePath3 = @"c:\dbscripts\db2\file3.sql";
const string filePath4 = @"c:\dbscripts\db2\sproc\file4.Sql";
var ruleVisitor = Substitute.For <IRuleVisitor>();
var reporter = Substitute.For <IReporter>();
var pluginHandler = Substitute.For <IPluginHandler>();
var fileSystem = new MockFileSystem(new Dictionary <string, MockFileData>
{
{
filePath1, new MockFileData("File1SQL")
},
{
filePath2, new MockFileData("File2SQL")
},
{
filePath3, new MockFileData("File3SQL")
},
{
filePath4, new MockFileData("File4SQL")
}
});
var processor = new SqlFileProcessor(ruleVisitor, pluginHandler, reporter, fileSystem);
// act
processor.ProcessPath(@"c:\DBScripts");
// assert
ruleVisitor.Received().VisitRules(filePath1, Arg.Any <IEnumerable <IExtendedRuleException> >(), Arg.Any <Stream>());
ruleVisitor.Received().VisitRules(filePath2, Arg.Any <IEnumerable <IExtendedRuleException> >(), Arg.Any <Stream>());
ruleVisitor.Received().VisitRules(filePath3, Arg.Any <IEnumerable <IExtendedRuleException> >(), Arg.Any <Stream>());
ruleVisitor.Received().VisitRules(filePath4, Arg.Any <IEnumerable <IExtendedRuleException> >(), Arg.Any <Stream>());
Assert.AreEqual(4, processor.FileCount);
}
public void ProcessPath_PathWithSpaces_ShouldProcessFiles()
{
// arrange
var filePath1 = TestHelper.GetTestFilePath(@"c:\dbscripts\file1.SQL");
var filePath2 = TestHelper.GetTestFilePath(@"c:\dbscripts\file2.txt");
var filePath3 = TestHelper.GetTestFilePath(@"c:\dbscripts\file3.sql");
var filePath4 = TestHelper.GetTestFilePath(@"c:\dbscripts\file4.Sql");
var ruleVisitor = Substitute.For <IRuleVisitor>();
var pluginHandler = Substitute.For <IPluginHandler>();
var reporter = Substitute.For <IReporter>();
var fileSystem = new MockFileSystem(new Dictionary <string, MockFileData>
{
{
filePath1, new MockFileData("File1SQL")
},
{
filePath2, new MockFileData("File2SQL")
},
{
filePath3, new MockFileData("File3SQL")
},
{
filePath4, new MockFileData("File4SQL")
}
});
var processor = new SqlFileProcessor(ruleVisitor, pluginHandler, reporter, fileSystem);
// act
processor.ProcessPath(TestHelper.GetTestFilePath(@"c:\dbscripts"));
// assert
ruleVisitor.Received().VisitRules(filePath1, Arg.Any <IEnumerable <IExtendedRuleException> >(), Arg.Any <Stream>());
ruleVisitor.Received().VisitRules(filePath3, Arg.Any <IEnumerable <IExtendedRuleException> >(), Arg.Any <Stream>());
ruleVisitor.Received().VisitRules(filePath4, Arg.Any <IEnumerable <IExtendedRuleException> >(), Arg.Any <Stream>());
ruleVisitor.DidNotReceive().VisitRules(filePath2, Arg.Any <IEnumerable <IRuleException> >(), Arg.Any <Stream>());
Assert.AreEqual(3, processor.FileCount);
}
public void ProcessPath_Processes_Directory_Directories()
{
const string filePath1 = @"c:\dbscripts\db1\file1.SQL";
const string filePath2 = @"c:\dbscripts\db1\file2.sQL";
var ruleVisitor = Substitute.For <IRuleVisitor>();
var reporter = Substitute.For <IBaseReporter>();
var fileSystem = new MockFileSystem(new Dictionary <string, MockFileData>
{
{ filePath1, new MockFileData("File1SQL") },
{ filePath2, new MockFileData("File2SQL") }
});
var processor = new SqlFileProcessor(ruleVisitor, reporter, fileSystem);
processor.ProcessPath(@"c:\DBScripts");
ruleVisitor.Received().VisitRules(filePath1, Arg.Any <TextReader>());
ruleVisitor.Received().VisitRules(filePath2, Arg.Any <TextReader>());
reporter.DidNotReceive().Report(Arg.Any <string>());
Assert.AreEqual(2, processor.GetFileCount());
}
public void ProcessPath_Processes_Single_File_When_It_Exists()
{
const string filePath = "c:\\dbscripts\\myfile.sql";
var ruleVisitor = Substitute.For <IRuleVisitor>();
var reporter = Substitute.For <IBaseReporter>();
var fileSystem = Substitute.For <IFileSystem>();
var fileBase = Substitute.For <FileBase>();
fileBase.Exists(filePath).Returns(true);
fileBase.ReadAllText(filePath).Returns("Some Sql To Parse");
fileSystem.File.Returns(fileBase);
var processor = new SqlFileProcessor(ruleVisitor, reporter, fileSystem);
processor.ProcessPath("\" " + filePath + " \""); // Also testing removal of quotes and leading/trailing spaces
fileBase.Received().Exists(filePath);
fileBase.Received().ReadAllText(filePath);
ruleVisitor.Received().VisitRules(filePath, Arg.Any <TextReader>());
reporter.DidNotReceive().Report(Arg.Any <string>());
Assert.AreEqual(1, processor.GetFileCount());
}
