C# (CSharp) Deveel.Data.Sql.Statements OpenStatement 예제들

예제 #1

파일: CursorStringFormatTests.cs 프로젝트: deveel/deveeldb

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

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

            Assert.AreEqual(expected, sql);
        }

예제 #2

파일: CursorStringFormatTests.cs 프로젝트: 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);
        }

예제 #3

파일: OpenStatementTests.cs 프로젝트: 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);
        }

예제 #4

파일: CursorStringFormatTests.cs 프로젝트: 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);
        }

예제 #5

파일: CursorStringFormatTests.cs 프로젝트: 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);
        }

예제 #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);
        }

예제 #7

파일: StatementVisitor.cs 프로젝트: deveel/deveeldb

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

예제 #8

파일: StatementSerializationTests.cs 프로젝트: 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);
            });
        }

예제 #9

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