public void SplitInBatches_StringsShouldBeIgnored()
{
var somethingToSplit = @"SELECT * FROM Table1 WHERE Name = 'é du go LR?'";
var actual = new SqlServer.MsSql120ScriptParser().SplitInBatches(somethingToSplit);
Assert.AreEqual(1, actual.Count());
}
public void SplitInBatches_HappyDays2()
{
var somethingToSplit = @"SELECT * FROM Table1";
var actual = new SqlServer.MsSql120ScriptParser().SplitInBatches(somethingToSplit);
Assert.AreEqual(1, actual.Count());
}
public void SplitInBatches_CaseInsensitiveness()
{
var somethingToSplit = @"SELECT * FROM Table1;
gO;
SELECT * FROM Table2";
var actual = new SqlServer.MsSql120ScriptParser().SplitInBatches(somethingToSplit);
Assert.AreEqual(2, actual.Count());
}
public void SplitInBatches_SemicolonsDoesntFuckThingsUp()
{
var somethingToSplit = @"SELECT * FROM Table1;
GO
SELECT * FROM Table2";
var actual = new SqlServer.MsSql120ScriptParser().SplitInBatches(somethingToSplit);
Assert.AreEqual(2, actual.Count());
}