public static void DeclareCursorWithParameters()
{
var query = (SqlQueryExpression)SqlExpression.Parse("SELECT a, b FROM test_table WHERE a / 4 = c");
var statement = new DeclareCursorStatement("c1", new []{new CursorParameter("c", PrimitiveTypes.Integer()), }, query);
var sql = statement.ToString();
var expected = new SqlStringBuilder();
expected.AppendLine("CURSOR c1(c INTEGER) IS");
expected.Append(" SELECT a, b FROM test_table WHERE a / 4 = c");
Assert.AreEqual(expected.ToString(), sql);
}
public static void DeclareCursorNoParameters()
{
var query = (SqlQueryExpression) SqlExpression.Parse("SELECT a, b FROM test_table GROUP BY a HAVING b > 3");
var statement = new DeclareCursorStatement("c1", query);
var sql = statement.ToString();
var expected = new SqlStringBuilder();
expected.AppendLine("CURSOR c1 IS");
expected.Append(" SELECT a, b FROM test_table GROUP BY a HVAING b > 3");
Assert.AreEqual(expected.ToString(), sql);
}
public static void DeclareCursorWithParameters()
{
var query = (SqlQueryExpression)SqlExpression.Parse("SELECT a, b FROM test_table WHERE a / 4 = c");
var statement = new DeclareCursorStatement("c1", new [] { new CursorParameter("c", PrimitiveTypes.Integer()), }, query);
var sql = statement.ToString();
var expected = new SqlStringBuilder();
expected.AppendLine("CURSOR c1(c INTEGER) IS");
expected.Append(" SELECT a, b FROM test_table WHERE a / 4 = c");
Assert.AreEqual(expected.ToString(), sql);
}
public static void DeclareCursorNoParameters()
{
var query = (SqlQueryExpression)SqlExpression.Parse("SELECT a, b FROM test_table GROUP BY a HAVING b > 3");
var statement = new DeclareCursorStatement("c1", query);
var sql = statement.ToString();
var expected = new SqlStringBuilder();
expected.AppendLine("CURSOR c1 IS");
expected.Append(" SELECT a, b FROM test_table GROUP BY a HVAING b > 3");
Assert.AreEqual(expected.ToString(), sql);
}
