Deveel.Data.Sql.Compile.CreateViewTests Class Reference

Inheritance diagram for Deveel.Data.Sql.Compile.CreateViewTests:

Public Member Functions
void	WithColumns ()
void	WithoutColumns ()

Additional Inherited Members
Protected Member Functions inherited from Deveel.Data.Sql.Compile.SqlCompileTestBase
SqlCompileResult	Compile (string sql)

Detailed Description

Definition at line 10 of file CreateViewTests.cs.

Member Function Documentation

void Deveel.Data.Sql.Compile.CreateViewTests.WithColumns ( )

inline

Definition at line 12 of file CreateViewTests.cs.

                                  {
            const string sql = "CREATE VIEW test_view (a, b, c) AS SELECT * FROM test";

            var result = Compile(sql);
            Assert.IsNotNull(result);
            Assert.IsFalse(result.HasErrors);
            Assert.AreEqual(1, result.Statements.Count);

            var statement = result.Statements.First();

            Assert.IsInstanceOf<CreateViewStatement>(statement);

            var createView = (CreateViewStatement) statement;
            Assert.AreEqual("test_view", createView.ViewName);
            Assert.IsNotEmpty(createView.ColumnNames);
            Assert.IsNotNull(createView.QueryExpression);
            Assert.IsFalse(createView.ReplaceIfExists);
        }

void Deveel.Data.Sql.Compile.CreateViewTests.WithoutColumns ( )

inline

Definition at line 32 of file CreateViewTests.cs.

                                     {
            const string sql = "CREATE VIEW test_view AS SELECT a, c FROM test";

            var result = Compile(sql);
            Assert.IsNotNull(result);
            Assert.IsFalse(result.HasErrors);
            Assert.AreEqual(1, result.Statements.Count);

            var statement = result.Statements.First();

            Assert.IsInstanceOf<CreateViewStatement>(statement);

            var createView = (CreateViewStatement)statement;
            Assert.AreEqual("test_view", createView.ViewName);
            Assert.IsNull(createView.ColumnNames);
            Assert.IsNotNull(createView.QueryExpression);
            Assert.IsFalse(createView.ReplaceIfExists);
        }

---

The documentation for this class was generated from the following file:

• /var/calculate/remote/distfiles/egit-src/deveeldb.git/src/deveeldb-nunit/Deveel.Data.Sql.Compile/CreateViewTests.cs