chucknorris/roundhouse — pull request #82 by icedtoast (2012-09-10 05:04:50+00:00)
Title: Change the StatementSplitter to handle combinations of string literals, comments and batch seperators

Change RoundHouse to handle mixing of the following for sql server:
* Single line comments `--`
* Multi line comments `/* newline */`
* Nested comments `/* /* nested */ */`
* String literals `'hello there'`
* Batch seperators `GO`

Changes to roundhouse include:
* Added Unit Tests for the regression introduced by [a297dd4](https://github.com/chucknorris/roundhouse/commit/a297dd4) and simliar examples.
* Refactored the Statement Splitter logic into an interface.
* Changed Unit Tests to check on the Split sql, not the replacement of terminators with a "split" string.
* Implemented a tokenizer based splitter for SQL Server.

The SqlServerStatement splitter uses a regular expression to just tokenize the sql. An outer loop then only breaks the sql on "go" statements that are outside of comments or string literals. This has the added advantage of not introducing whitespace into sql batches.

Only SQL Server database targets are affected by these changes