public void InsensitiveSimpleCursor()
{
const string cursorName = "c";
var query = (SqlQueryExpression) SqlExpression.Parse("SELECT * FROM APP.test_table");
var statement = new DeclareCursorStatement(cursorName, query);
statement.Execute(Query);
var cursor = Query.FindCursor(cursorName);
Assert.IsNotNull(cursor);
Assert.AreEqual(cursorName, cursor.CursorInfo.CursorName);
Assert.IsEmpty(cursor.CursorInfo.Parameters);
}
public void InsensitiveSimpleCursor()
{
const string cursorName = "c";
var query = (SqlQueryExpression)SqlExpression.Parse("SELECT * FROM APP.test_table");
var statement = new DeclareCursorStatement(cursorName, query);
statement.Execute(Query);
var cursor = Query.FindCursor(cursorName);
Assert.IsNotNull(cursor);
Assert.AreEqual(cursorName, cursor.CursorInfo.CursorName);
Assert.IsEmpty(cursor.CursorInfo.Parameters);
}
public void InsensitiveWithParams()
{
const string cursorName = "c";
var query = (SqlQueryExpression)SqlExpression.Parse("SELECT * FROM APP.test_table WHERE a = :a");
var parameters = new[] {new CursorParameter("a", PrimitiveTypes.Integer())};
var statement = new DeclareCursorStatement(cursorName, parameters, query);
statement.Execute(Query);
var cursor = Query.FindCursor(cursorName);
Assert.IsNotNull(cursor);
Assert.AreEqual(cursorName, cursor.CursorInfo.CursorName);
Assert.IsNotEmpty(cursor.CursorInfo.Parameters);
}
public void InsensitiveWithParams()
{
const string cursorName = "c";
var query = (SqlQueryExpression)SqlExpression.Parse("SELECT * FROM APP.test_table WHERE a = :a");
var parameters = new[] { new CursorParameter("a", PrimitiveTypes.Integer()) };
var statement = new DeclareCursorStatement(cursorName, parameters, query);
statement.Execute(Query);
var cursor = Query.FindCursor(cursorName);
Assert.IsNotNull(cursor);
Assert.AreEqual(cursorName, cursor.CursorInfo.CursorName);
Assert.IsNotEmpty(cursor.CursorInfo.Parameters);
}
