public void GetStringWithoutLabel() { var loop = new WhileLoopStatement(SqlExpression.Constant(SqlObject.Boolean(true))); loop.Statements.Add(new ExitStatement()); var sql = new StringBuilder(); sql.AppendLine("WHILE TRUE"); sql.AppendLine("LOOP"); sql.AppendLine(" EXIT;"); sql.Append("END LOOP;"); Assert.Equal(sql.ToString(), loop.ToString()); }
public static void WhileLoop() { var loop = new WhileLoopStatement(SqlExpression.Constant(true)); loop.Statements.Add(new CallStatement(ObjectName.Parse("SYSTEM.print"), new SqlExpression[] { SqlExpression.Constant("iterated") })); var sql = loop.ToString(); var expected = new StringBuilder(); expected.AppendLine("WHILE TRUE"); expected.AppendLine("LOOP"); expected.AppendLine(" CALL SYSTEM.print('iterated')"); expected.Append("END LOOP"); Assert.AreEqual(expected.ToString(), sql); }