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")); }