Deveel.Data.Sql.Expressions.SqlQueryExpressionTests Class Reference

Inheritance diagram for Deveel.Data.Sql.Expressions.SqlQueryExpressionTests:

Public Member Functions
void	ExecuteSelectAll ()
void	ParseSelectWithFromClause ()
void	ParseSelectWithNaturalJoin ()
void	ParseSelectWithInnerJoin ()
void	ParseSelectFunction ()
void	ParseSelectSubQuery ()
void	ParseSimpleQuery ()
void	ParseSelectGroupBy ()
Public Member Functions inherited from Deveel.Data.ContextBasedTest
void	TestSetUp ()
void	TestFixtureSetUp ()
void	TestTearDown ()
void	TestFixtureTearDown ()

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

Private Member Functions
void	CreateTestTable ()
void	AddTestData ()

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 28 of file SqlQueryExpressionTests.cs.

Member Function Documentation

void Deveel.Data.Sql.Expressions.SqlQueryExpressionTests.AddTestData ( )

inlineprivate

Definition at line 48 of file SqlQueryExpressionTests.cs.

                                   {
            var table = Query.GetMutableTable(ObjectName.Parse("APP.test_table"));
            var row = table.NewRow();
            row.SetValue("first_name", DataObject.String("John"));
            row.SetValue("last_name", DataObject.String("Doe"));
            row.SetValue("birth_date", DataObject.Date(new SqlDateTime(1977, 01, 01)));
            row.SetValue("active", DataObject.Boolean(false));
            table.AddRow(row);

            row = table.NewRow();
            row.SetValue("first_name", DataObject.String("Jane"));
            row.SetValue("last_name", DataObject.String("Doe"));
            row.SetValue("birth_date", DataObject.Date(new SqlDateTime(1978, 11, 01)));
            row.SetValue("active", DataObject.Boolean(true));
            table.AddRow(row);

            row = table.NewRow();
            row.SetValue("first_name", DataObject.String("Roger"));
            row.SetValue("last_name", DataObject.String("Rabbit"));
            row.SetValue("birth_date", DataObject.Date(new SqlDateTime(1985, 05, 05)));
            row.SetValue("active", DataObject.Boolean(true));
            table.AddRow(row);
        }

void Deveel.Data.Sql.Expressions.SqlQueryExpressionTests.CreateTestTable ( )

inlineprivate

Definition at line 34 of file SqlQueryExpressionTests.cs.

                                       {
            var tableInfo = new TableInfo(ObjectName.Parse("APP.test_table"));
            var idColumn = tableInfo.AddColumn("id", PrimitiveTypes.Integer());
            idColumn.DefaultExpression = SqlExpression.FunctionCall("UNIQUE_KEY",
                new SqlExpression[] {SqlExpression.Reference(tableInfo.TableName)});
            tableInfo.AddColumn("first_name", PrimitiveTypes.String());
            tableInfo.AddColumn("last_name", PrimitiveTypes.String());
            tableInfo.AddColumn("birth_date", PrimitiveTypes.DateTime());
            tableInfo.AddColumn("active", PrimitiveTypes.Boolean());

            Query.CreateTable(tableInfo);
            Query.AddPrimaryKey(tableInfo.TableName, "id", "PK_TEST_TABLE");
        }

void Deveel.Data.Sql.Expressions.SqlQueryExpressionTests.ExecuteSelectAll ( )

inline

Definition at line 74 of file SqlQueryExpressionTests.cs.

                                       {
            var expression =
                new SqlQueryExpression(new[] {new SelectColumn(SqlExpression.Reference(new ObjectName("first_name")))});
            expression.FromClause.AddTable("test_table");

            DataObject result = null;
            Assert.DoesNotThrow(() => result = expression.EvaluateToConstant(Query, null));
            Assert.IsNotNull(result);
            Assert.IsInstanceOf<QueryType>(result.Type);
            Assert.IsNotNull(result.Value);
            Assert.IsInstanceOf<SqlQueryObject>(result.Value);

            ITable queryResult = null;

            Assert.DoesNotThrow(() => queryResult = ((SqlQueryObject) result.Value).QueryPlan.Evaluate(Query));
            Assert.IsNotNull(queryResult);
            Assert.AreEqual(3, queryResult.RowCount);
        }

override void Deveel.Data.Sql.Expressions.SqlQueryExpressionTests.OnSetUp ( string  testName )

inlineprotectedvirtual

Reimplemented from Deveel.Data.ContextBasedTest.

Definition at line 29 of file SqlQueryExpressionTests.cs.

                                                         {
            CreateTestTable();
            AddTestData();
        }

void Deveel.Data.Sql.Expressions.SqlQueryExpressionTests.ParseSelectFunction ( )

inline

Definition at line 159 of file SqlQueryExpressionTests.cs.

                                          {
            const string sql = "SELECT user()";

            SqlExpression expression = null;
            Assert.DoesNotThrow(() => expression = SqlExpression.Parse(sql));
            Assert.IsNotNull(expression);
            Assert.IsInstanceOf<SqlQueryExpression>(expression);

            var queryExpression = (SqlQueryExpression) expression;
            Assert.IsNotEmpty(queryExpression.SelectColumns);
            Assert.IsInstanceOf<SqlFunctionCallExpression>(queryExpression.SelectColumns.First().Expression);
            Assert.AreEqual("user", ((SqlFunctionCallExpression) queryExpression.SelectColumns.First().Expression).FunctioName.FullName);
        }

void Deveel.Data.Sql.Expressions.SqlQueryExpressionTests.ParseSelectGroupBy ( )

inline

Definition at line 216 of file SqlQueryExpressionTests.cs.

                                         {
            const string sql = "SELECT col1 AS a, AVG(col2) b FROM table WHERE b > 2 GROUP BY a";

            SqlExpression expression = null;
            Assert.DoesNotThrow(() => expression = SqlExpression.Parse(sql));
            Assert.IsNotNull(expression);
            Assert.IsInstanceOf<SqlQueryExpression>(expression);

            var queryExpression = (SqlQueryExpression)expression;
            Assert.IsNotEmpty(queryExpression.SelectColumns);

            var groupBy = queryExpression.GroupBy;
            Assert.IsNotNull(groupBy);
            Assert.IsNotEmpty(groupBy);
            Assert.AreEqual(1, groupBy.Count());
        }

void Deveel.Data.Sql.Expressions.SqlQueryExpressionTests.ParseSelectSubQuery ( )

inline

Definition at line 175 of file SqlQueryExpressionTests.cs.

                                          {
            const string sql = "SELECT * FROM (SELECT a, b FROM table1)";

            SqlExpression expression = null;
            Assert.DoesNotThrow(() => expression = SqlExpression.Parse(sql));
            Assert.IsNotNull(expression);
            Assert.IsInstanceOf<SqlQueryExpression>(expression);

            var queryExpression = (SqlQueryExpression) expression;
            Assert.IsNotEmpty(queryExpression.SelectColumns);
            Assert.IsNotEmpty(queryExpression.FromClause.AllTables);
            Assert.AreEqual(1, queryExpression.FromClause.AllTables.Count());
            Assert.IsTrue(queryExpression.FromClause.AllTables.First().IsSubQuery);
        }

void Deveel.Data.Sql.Expressions.SqlQueryExpressionTests.ParseSelectWithFromClause ( )

inline

Definition at line 95 of file SqlQueryExpressionTests.cs.

                                                {
            const string sql = "SELECT col1 AS a FROM table";

            var expression = SqlExpression.Parse(sql);
            Assert.IsNotNull(expression);
            Assert.IsInstanceOf<SqlQueryExpression>(expression);

            var queryExpression = (SqlQueryExpression) expression;
            Assert.IsNotEmpty(queryExpression.SelectColumns);
            Assert.IsInstanceOf<SqlReferenceExpression>(queryExpression.SelectColumns.First().Expression);
            Assert.AreEqual("a", queryExpression.SelectColumns.First().Alias);
            Assert.IsNotNull(queryExpression.FromClause);
            Assert.AreEqual(1, queryExpression.FromClause.AllTables.Count());
            Assert.AreEqual("table", queryExpression.FromClause.AllTables.First().Name);
        }

void Deveel.Data.Sql.Expressions.SqlQueryExpressionTests.ParseSelectWithInnerJoin ( )

inline

Definition at line 135 of file SqlQueryExpressionTests.cs.

                                               {
            const string sql = "SELECT a.col1, b.col2 FROM table1 AS a INNER JOIN table2 b ON a.id = b.id";

            SqlExpression expression = null;
            Assert.DoesNotThrow(() => expression = SqlExpression.Parse(sql));
            Assert.IsNotNull(expression);
            Assert.IsInstanceOf<SqlQueryExpression>(expression);

            var queryExpression = (SqlQueryExpression) expression;
            Assert.IsNotEmpty(queryExpression.SelectColumns);
            Assert.IsInstanceOf<SqlReferenceExpression>(queryExpression.SelectColumns.First().Expression);
            Assert.IsInstanceOf<SqlReferenceExpression>(queryExpression.SelectColumns.Skip(1).First().Expression);
            Assert.IsNotNull(queryExpression.FromClause);
            Assert.IsNotEmpty(queryExpression.FromClause.AllTables);
            Assert.AreEqual(2, queryExpression.FromClause.AllTables.Count());
            Assert.AreEqual(1, queryExpression.FromClause.JoinPartCount);
            Assert.IsNotNull(queryExpression.FromClause.GetJoinPart(0));
            Assert.AreEqual(JoinType.Inner, queryExpression.FromClause.GetJoinPart(0).JoinType);
            Assert.IsNotNull(queryExpression.FromClause.GetJoinPart(0).OnExpression);
            Assert.IsInstanceOf<SqlBinaryExpression>(queryExpression.FromClause.GetJoinPart(0).OnExpression);
        }

void Deveel.Data.Sql.Expressions.SqlQueryExpressionTests.ParseSelectWithNaturalJoin ( )

inline

Definition at line 113 of file SqlQueryExpressionTests.cs.

                                                 {
            const string sql = "SELECT a.col1, b.col2 FROM table1 a, table2 b";

            SqlExpression expression = null;
            Assert.DoesNotThrow(() => expression = SqlExpression.Parse(sql));
            Assert.IsNotNull(expression);
            Assert.IsInstanceOf<SqlQueryExpression>(expression);

            var queryExpression = (SqlQueryExpression) expression;
            Assert.IsNotEmpty(queryExpression.SelectColumns);
            Assert.IsInstanceOf<SqlReferenceExpression>(queryExpression.SelectColumns.First().Expression);
            Assert.IsInstanceOf<SqlReferenceExpression>(queryExpression.SelectColumns.Skip(1).First().Expression);
            Assert.IsNotNull(queryExpression.FromClause);
            Assert.IsNotEmpty(queryExpression.FromClause.AllTables);
            Assert.AreEqual(2, queryExpression.FromClause.AllTables.Count());
            Assert.AreEqual(1, queryExpression.FromClause.JoinPartCount);
            Assert.IsNotNull(queryExpression.FromClause.GetJoinPart(0));
            Assert.AreEqual(JoinType.Inner, queryExpression.FromClause.GetJoinPart(0).JoinType);
        }

void Deveel.Data.Sql.Expressions.SqlQueryExpressionTests.ParseSimpleQuery ( )

inline

Definition at line 197 of file SqlQueryExpressionTests.cs.

                                       {
            const string sql = "SELECT col1 AS a FROM table";

            SqlExpression expression = null;
            Assert.DoesNotThrow(() => expression = SqlExpression.Parse(sql));
            Assert.IsNotNull(expression);
            Assert.IsInstanceOf<SqlQueryExpression>(expression);

            var queryExpression = (SqlQueryExpression)expression;
            Assert.IsNotEmpty(queryExpression.SelectColumns);
            Assert.IsInstanceOf<SqlReferenceExpression>(queryExpression.SelectColumns.First().Expression);
            Assert.AreEqual("a", queryExpression.SelectColumns.First().Alias);
            Assert.IsNotNull(queryExpression.FromClause);
            Assert.AreEqual(1, queryExpression.FromClause.AllTables.Count());
            Assert.AreEqual("table", queryExpression.FromClause.AllTables.First().Name);
        }

---

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.Expressions/SqlQueryExpressionTests.cs