Deveel.Data.DeclareCursorTests.InsensitiveWithParams C# (CSharp) Method

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

            AdminQuery.DeclareCursor(cursorName, parameters, query);

            var cursor = AdminQuery.Context.FindCursor(cursorName);
            Assert.IsNotNull(cursor);
            Assert.AreEqual(cursorName, cursor.CursorInfo.CursorName);
            Assert.IsNotEmpty(cursor.CursorInfo.Parameters);
        }