public void MultipleQuotesInQueryAreSeparated() { var results = new Tokenizer().Tokenize("SELECT * FROM Table WHERE Column='value value' AND Column2='value value value'").ToList(); Assert.IsTrue(results.Any(result => result.ToString() == "StringConstant: 'value value'")); Assert.IsTrue(results.Any(result => result.ToString() == "StringConstant: 'value value value'")); }
public void MultipleOneLineCommentsAreRecognized() { var results = new Tokenizer().Tokenize(@" -- multi -- line SELECT * FROM Table -- comment WHERE Column='value value' AND Column2=45").ToList(); Assert.IsTrue(results.Any(result => result.ToString() == "Comment: -- multi")); Assert.IsTrue(results.Any(result => result.ToString() == "Comment: -- line")); Assert.IsTrue(results.Any(result => result.ToString() == "Comment: -- comment")); }
public void SingleMySqlCommentIsRecognized() { var results = new Tokenizer().Tokenize(@" # single line comment SELECT * FROM Table WHERE Column='value value' AND Column2=45").ToList(); Assert.IsTrue(results.Any(result => result.ToString() == "Comment: # single line comment")); }
public void MultiLineCommentIsRecognized() { var results = new Tokenizer().Tokenize(@" /* multi line comment */ SELECT * FROM Table WHERE Column='value value' AND Column2=45").ToList(); Assert.IsTrue(results.Any(result => result.ToString() == "Comment: /* multi\nline\ncomment */")); }
public void SingleQuotesWithEscapedQuoteInsideAreRecognized() { var results = new Tokenizer().Tokenize("SELECT * FROM Table WHERE Column='value '' value' AND Column2=45").ToList(); Assert.IsTrue(results.Any(result => result.Content == "'value '' value'")); }