public void ParsesSimpleSelectQueryInProcedure()
{
const string query = "create procedure abc\r\n as\r\n begin\r\n select 1;\r\n end";
var parser = new StatementParser(SqlServerVersion.Sql120);
var statements = parser.GetChildStatements(query, false);
Assert.AreEqual(1, statements.Count);
}
public void IfThenElseStatementIsBrokenIntoParts()
{
const string query = "create procedure abc\r\n as\r\n if\t \t1 = 1 begin\r\n select 1;\r\n end\r\nelse\r\nselect 99;";
var parser = new StatementParser(SqlServerVersion.Sql120);
var statements = parser.GetChildStatements(query, false);
Assert.IsNotNull(statements.FirstOrDefault(p => p.Text == "select 99;"));
}
public void ParsesSimpleSelectQuery()
{
const string query = "select 1";
var parser = new StatementParser(SqlServerVersion.Sql120);
var statements = parser.GetChildStatements(query, false);
Assert.AreEqual(1, statements.Count);
Assert.AreEqual(query, statements.First().Text);
}
public Batch(StatementParser parser, bool quotedIdentifier, string text, string fileName, string objectName, int objectId)
{
QuotedIdentifier = quotedIdentifier;
Text = text;
FileName = fileName;
ObjectName = objectName;
ObjectId = objectId;
Statements = parser.GetChildStatements(text, quotedIdentifier);
}
public void WhileStatementIsBrokenIntoParts()
{
const string query = @"create procedure abc
as while 1 = 1 begin
select 1;
end
select 99 ;
select * from a_table;";
var parser = new StatementParser(SqlServerVersion.Sql120);
var statements = parser.GetChildStatements(query, false);
Assert.IsNotNull(statements.FirstOrDefault(p => p.Text == "while 1 = 1"));
}
