public void CanParseSimpleScriptEndingInNewLine() { string script = "Test" + Environment.NewLine + "GO" + Environment.NewLine; List <string> scripts = new ScriptSplitter(script).ToList(); Assert.AreEqual(1, scripts.Count()); Assert.AreEqual("Test", scripts.First()); }
public void CanParseQuotedCorrectly() { const string script = @"INSERT INTO #Indexes EXEC sp_helpindex 'dbo.subtext_URLs'" ; var scripts = new ScriptSplitter(script); Assert.AreEqual(script, scripts.First(), "Script text should not be modified"); }
public void MultiLineQuoteShouldNotBeSplitByGoKeyword() { string script = "PRINT '" + Environment.NewLine + "GO" + Environment.NewLine + "SELECT * FROM BLAH" + Environment.NewLine + "GO" + Environment.NewLine + "'"; var scripts = new ScriptSplitter(script); Assert.AreEqual(script, scripts.First()); Assert.AreEqual(1, scripts.Count(), "expected only one script"); }
public void MultiLineQuoteShouldNotIgnoreDoubleQuote() { string script = "PRINT '" + Environment.NewLine + "''" + Environment.NewLine + "GO" + Environment.NewLine + "/*" + Environment.NewLine + "GO" + "'"; var scripts = new ScriptSplitter(script); Assert.AreEqual(1, scripts.Count()); Assert.AreEqual(script, scripts.First()); }
public void CanParseSimpleScriptEndingInNewLine() { string script = "Test" + Environment.NewLine + "GO" + Environment.NewLine; List<string> scripts = new ScriptSplitter(script).ToList(); Assert.AreEqual(1, scripts.Count()); Assert.AreEqual("Test", scripts.First()); }
public void CanParseQuotedCorrectly() { const string script = @"INSERT INTO #Indexes EXEC sp_helpindex 'dbo.subtext_URLs'"; var scripts = new ScriptSplitter(script); Assert.AreEqual(script, scripts.First(), "Script text should not be modified"); }