Exemplos de Deveel.Data.Sql.Statements OpenStatement em C# (CSharp)

Exemplo n.º 1

Arquivo: CursorStringFormatTests.cs Projeto: deveel/deveeldb

        public static void OpenCursorNoArguments()
        {
            var statement = new OpenStatement("c1");

            var sql = statement.ToString();
            var expected = "OPEN c1";

            Assert.AreEqual(expected, sql);
        }

Exemplo n.º 2

Arquivo: CursorStringFormatTests.cs Projeto: svg-useful-backup/deveeldb

        public static void OpenCursorNoArguments()
        {
            var statement = new OpenStatement("c1");

            var sql      = statement.ToString();
            var expected = "OPEN c1";

            Assert.AreEqual(expected, sql);
        }

Exemplo n.º 3

Arquivo: OpenStatementTests.cs Projeto: ArsenShnurkov/deveeldb

        public void OpenSimple()
        {
            var statement = new OpenStatement("c1");

            statement.Execute(Query);

            var cursor = Query.FindCursor("c1");
            Assert.IsNotNull(cursor);
            Assert.AreEqual("c1", cursor.CursorInfo.CursorName);
            Assert.AreEqual(CursorStatus.Open, cursor.Status);
        }

Exemplo n.º 4

Arquivo: CursorStringFormatTests.cs Projeto: svg-useful-backup/deveeldb

        public static void OpenCursorWithArguments()
        {
            var statement = new OpenStatement("c1", new SqlExpression[] {
                SqlExpression.Constant(45),
                SqlExpression.VariableReference("a")
            });

            var sql      = statement.ToString();
            var expected = "OPEN c1(45, :a)";

            Assert.AreEqual(expected, sql);
        }

Exemplo n.º 5

Arquivo: CursorStringFormatTests.cs Projeto: deveel/deveeldb

        public static void OpenCursorWithArguments()
        {
            var statement = new OpenStatement("c1", new SqlExpression[] {
                SqlExpression.Constant(45),
                SqlExpression.VariableReference("a")
            });

            var sql = statement.ToString();
            var expected = "OPEN c1(45, :a)";

            Assert.AreEqual(expected, sql);
        }

Exemplo n.º 6

        public void OpenSimple()
        {
            var statement = new OpenStatement("c1");

            statement.Execute(Query);

            var cursor = Query.FindCursor("c1");

            Assert.IsNotNull(cursor);
            Assert.AreEqual("c1", cursor.CursorInfo.CursorName);
            Assert.AreEqual(CursorStatus.Open, cursor.Status);
        }

Exemplo n.º 7

Arquivo: StatementVisitor.cs Projeto: deveel/deveeldb

 protected virtual SqlStatement VisitOpen(OpenStatement statement)
 {
     return new OpenStatement(statement.CursorName, statement.Arguments);
 }

Exemplo n.º 8

Arquivo: StatementSerializationTests.cs Projeto: deveel/deveeldb

        public void OpenWithNoArguments()
        {
            var statement = new OpenStatement("c1");

            SerializeAndAssert(statement, (serialized, deserialized) => {
                Assert.IsNotNull(deserialized);
                Assert.AreEqual("c1", deserialized.CursorName);
                Assert.IsEmpty(deserialized.Arguments);
            });
        }

Exemplo n.º 9

 protected virtual SqlStatement VisitOpen(OpenStatement statement)
 {
     return(new OpenStatement(statement.CursorName, statement.Arguments));
 }