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()); }