public void Test_Nested_Multi_Line_Block_Comment() { //arrange var sqlStatementRaw = $@"SELECT 1; SELECT 2; GO /* another line comment /*this is a multi-line block comment*/ another line comment */ SELECT 3; GO "; //act var sut = new CommentAnalyzer(); var results = sut.Run(sqlStatementRaw); //assert results.Count.ShouldBe(1); results[0].Text.ShouldBe( $@"/* another line comment /*this is a multi-line block comment*/ another line comment */"); results[0].Start = 28; results[0].End = 120; }
public void Test_Dash_Dash_Inline_Comment_Inside_Middle_Valid_Sql_Statement() { //arrange var sqlStatementRaw = $@"SELECT 1; SELECT 2; GO SELECT 'This is normal statement with --this is an inline comment'; GO "; //act var sut = new CommentAnalyzer(); var results = sut.Run(sqlStatementRaw); //assert results.Count.ShouldBe(0); }
public void Test_Dash_Dash_Inline_Comment_After_Sql_Statement() { //arrange var sqlStatementRaw = $@"SELECT 1; SELECT 2; GO SELECT 3; --this is an inline comment GO "; //act var sut = new CommentAnalyzer(); var results = sut.Run(sqlStatementRaw); //assert results.Count.ShouldBe(1); results[0].Text.ShouldBe($@"--this is an inline comment" + Environment.NewLine); results[0].Start = 40; results[0].End = 69; }
public void Test_Single_Line_Block_Comment() { //arrange var sqlStatementRaw = $@"SELECT 1; SELECT 2; GO /*this is a single line block comment*/ SELECT 3; GO "; //act var sut = new CommentAnalyzer(); var results = sut.Run(sqlStatementRaw); //assert results.Count.ShouldBe(1); results[0].Text.ShouldBe($@"/*this is a single line block comment*/"); results[0].Start = 28; results[0].End = 69; }