Deveel.Data.Sql.JoinTableTests Class Reference

Inheritance diagram for Deveel.Data.Sql.JoinTableTests:

Public Member Functions
void	NaturalInnerJoin ()
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	AddTestData ()
void	CreateTestTables ()
TableInfo	CreateSecondTable ()
TableInfo	CreateFirstTable ()

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 JoinTableTests.cs.

Member Function Documentation

void Deveel.Data.Sql.JoinTableTests.AddTestData ( )

inlineprivate

Definition at line 34 of file JoinTableTests.cs.

                                   {
            var table = Query.GetMutableTable(new ObjectName(new ObjectName("APP"), "persons"));

            var row = table.NewRow();
            row["person_id"] = DataObject.Integer(1);
            row["name"] = DataObject.String("Antonello Provenzano");
            row["age"] = DataObject.Integer(34);
            table.AddRow(row);

            row = table.NewRow();
            row["person_id"] = DataObject.Integer(3);
            row["name"] = DataObject.String("John Doe");
            row["age"] = DataObject.Integer(56);
            table.AddRow(row);

            table = Query.GetMutableTable(new ObjectName(new ObjectName("APP"), "codes"));
            row = table.NewRow();
            row["person_id"] = DataObject.Integer(1);
            row["code"] = DataObject.String("123456");
            row["registered"] = DataObject.Date(new SqlDateTime(2014, 01, 12));
            table.AddRow(row);
        }

TableInfo Deveel.Data.Sql.JoinTableTests.CreateFirstTable ( )

inlineprivate

Definition at line 75 of file JoinTableTests.cs.

                                             {
            var tableInfo = new TableInfo(new ObjectName(new ObjectName("APP"), "persons"));
            tableInfo.AddColumn("person_id", PrimitiveTypes.Integer());
            tableInfo.AddColumn("name", PrimitiveTypes.String());
            tableInfo.AddColumn("age", PrimitiveTypes.Integer());

            return tableInfo;
        }

TableInfo Deveel.Data.Sql.JoinTableTests.CreateSecondTable ( )

inlineprivate

Definition at line 66 of file JoinTableTests.cs.

                                              {
            var tableInfo = new TableInfo(new ObjectName(new ObjectName("APP"), "codes"));
            tableInfo.AddColumn("person_id", PrimitiveTypes.Integer());
            tableInfo.AddColumn("code", PrimitiveTypes.String());
            tableInfo.AddColumn("registered", PrimitiveTypes.DateTime());

            return tableInfo;
        }

void Deveel.Data.Sql.JoinTableTests.CreateTestTables ( )

inlineprivate

Definition at line 57 of file JoinTableTests.cs.

                                        {
            var tableInfo = CreateFirstTable();
            Query.CreateTable(tableInfo);
            Query.AddPrimaryKey(tableInfo.TableName, "person_id");

            tableInfo = CreateSecondTable();
            Query.CreateTable(tableInfo);
        }

void Deveel.Data.Sql.JoinTableTests.NaturalInnerJoin ( )

inline

Definition at line 85 of file JoinTableTests.cs.

                                       {
            SqlExpression expression = null;
            Assert.DoesNotThrow(() => expression = SqlExpression.Parse("SELECT * FROM persons, codes"));
            Assert.IsNotNull(expression);
            Assert.IsInstanceOf<SqlQueryExpression>(expression);

            SqlExpression resultExpression = null;
            Assert.DoesNotThrow(() => resultExpression = expression.Evaluate(Query, null));
            Assert.IsNotNull(resultExpression);
            Assert.IsInstanceOf<SqlConstantExpression>(resultExpression);

            var constantExpression = (SqlConstantExpression) resultExpression;
            Assert.IsInstanceOf<QueryType>(constantExpression.Value.Type);

            var queryPlan = ((SqlQueryObject) constantExpression.Value.Value);
            ITable result = null;

            Assert.DoesNotThrow(() => result = queryPlan.QueryPlan.Evaluate(Query));

            Assert.IsNotNull(result);
        }

override void Deveel.Data.Sql.JoinTableTests.OnSetUp ( string  testName )

inlineprotectedvirtual

Reimplemented from Deveel.Data.ContextBasedTest.

Definition at line 29 of file JoinTableTests.cs.

                                                         {
            CreateTestTables();
            AddTestData();
        }

---

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/JoinTableTests.cs