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