Deveel.Data.Sql.Statements.CreateViewStatementTests Class Reference

Inheritance diagram for Deveel.Data.Sql.Statements.CreateViewStatementTests:

Public Member Functions
void	ParseSimpleCreateView ()
void	ParseCreateViewWithColumns ()
void	ParseCreateViewWithOrReplace ()
void	ExecuteSimpleCreateView ()
Public Member Functions inherited from Deveel.Data.ContextBasedTest
void	TestSetUp ()
void	TestFixtureSetUp ()
void	TestTearDown ()
void	TestFixtureTearDown ()

Protected Member Functions
override ISession	CreateAdminSession (IDatabase database)
Protected Member Functions inherited from Deveel.Data.ContextBasedTest
virtual void	RegisterServices (ServiceContainer container)
virtual ISystem	CreateSystem ()
virtual IDatabase	CreateDatabase (ISystem system, IConfiguration configuration)
virtual IQuery	CreateQuery (ISession session)
ISession	CreateUserSession (string userName, string password)
virtual void	OnSetUp (string testName)
virtual void	OnTearDown ()

Additional Inherited Members
Protected Attributes inherited from Deveel.Data.ContextBasedTest
const string	AdminUserName = "SA"
const string	AdminPassword = "1234567890"
const string	DatabaseName = "testdb"
Properties inherited from Deveel.Data.ContextBasedTest
virtual bool	SingleContext [get]
IQuery	Query [get, private set]
ISystem	System [get, private set]
IDatabase	Database [get, private set]
ISession	Session [get, private set]

Detailed Description

Definition at line 27 of file CreateViewStatementTests.cs.

Member Function Documentation

override ISession Deveel.Data.Sql.Statements.CreateViewStatementTests.CreateAdminSession ( IDatabase  database )

inlineprotectedvirtual

Reimplemented from Deveel.Data.ContextBasedTest.

Definition at line 29 of file CreateViewStatementTests.cs.

                                                                           {
            using (var session = base.CreateAdminSession(database)) {
                using (var query = session.CreateQuery()) {
                    var tableInfo = new TableInfo(ObjectName.Parse("APP.test_table"));
                    tableInfo.AddColumn("a", PrimitiveTypes.Integer());
                    tableInfo.AddColumn("b", PrimitiveTypes.String(), false);

                    query.CreateTable(tableInfo, false, false);
                    query.Commit();
                }
            }

            return base.CreateAdminSession(database);
        }

void Deveel.Data.Sql.Statements.CreateViewStatementTests.ExecuteSimpleCreateView ( )

inline

Definition at line 97 of file CreateViewStatementTests.cs.

                                              {
            const string sql = "CREATE VIEW text_view1 AS SELECT * FROM test_table WHERE a = 1";

            IEnumerable<SqlStatement> statements = null;
            Assert.DoesNotThrow(() => statements = SqlStatement.Parse(sql));
            Assert.IsNotNull(statements);

            var list = statements.ToList();

            Assert.AreEqual(1, list.Count);

            var statement = list[0];

            Assert.IsNotNull(statement);
            Assert.IsInstanceOf<CreateViewStatement>(statement);

            ITable result = null;
            Assert.DoesNotThrow(() => result = statement.Execute(Query));
            Assert.IsNotNull(result);
            Assert.AreEqual(1, result.RowCount);
        }

void Deveel.Data.Sql.Statements.CreateViewStatementTests.ParseCreateViewWithColumns ( )

inline

Definition at line 65 of file CreateViewStatementTests.cs.

                                                 {
            const string sql = "CREATE VIEW text_view1 (a, b, c) AS SELECT * FROM test_table WHERE a = 1";

            IEnumerable<SqlStatement> statements = null;
            Assert.DoesNotThrow(() => statements = SqlStatement.Parse(sql));
            Assert.IsNotNull(statements);

            var statementList = statements.ToList();
            Assert.IsNotEmpty(statementList);
            Assert.AreEqual(1, statementList.Count);
            Assert.IsInstanceOf<CreateViewStatement>(statementList[0]);

            var createView = (CreateViewStatement)statementList[0];
        }

void Deveel.Data.Sql.Statements.CreateViewStatementTests.ParseCreateViewWithOrReplace ( )

inline

Definition at line 81 of file CreateViewStatementTests.cs.

                                                   {
            const string sql = "CREATE OR REPLACE VIEW text_view1 AS SELECT * FROM test_table WHERE a = 1";

            IEnumerable<SqlStatement> statements = null;
            Assert.DoesNotThrow(() => statements = SqlStatement.Parse(sql));
            Assert.IsNotNull(statements);

            var statementList = statements.ToList();
            Assert.IsNotEmpty(statementList);
            Assert.AreEqual(1, statementList.Count);
            Assert.IsInstanceOf<CreateViewStatement>(statementList[0]);

            var createView = (CreateViewStatement)statementList[0];
        }

void Deveel.Data.Sql.Statements.CreateViewStatementTests.ParseSimpleCreateView ( )

inline

Definition at line 45 of file CreateViewStatementTests.cs.

                                            {
            const string sql = "CREATE VIEW text_view1 AS SELECT * FROM test_table WHERE a = 1";

            var statements = SqlStatement.Parse(sql);
            Assert.IsNotNull(statements);

            var statementList = statements.ToList();
            Assert.IsNotEmpty(statementList);
            Assert.AreEqual(1, statementList.Count);
            Assert.IsInstanceOf<CreateViewStatement>(statementList[0]);

            var createView = (CreateViewStatement) statementList[0];
            Assert.IsNotNull(createView.SourceQuery);
            Assert.IsTrue(createView.IsFromQuery);

            Assert.IsNotNull(createView.ViewName);
        }

---

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.Statements/CreateViewStatementTests.cs