Deveel.Data.Linq.TableQueryTests Class Reference

Inheritance diagram for Deveel.Data.Linq.TableQueryTests:

Classes
class	Person
class	TestQueryContext

Public Member Functions
void	TestSetup ()
void	ProjectFirst ()
void	FindById ()
void	QueryById ()
Public Member Functions inherited from Deveel.Data.ContextBasedTest
void	TestSetUp ()
void	TestFixtureSetUp ()
void	TestTearDown ()
void	TestFixtureTearDown ()

Protected Member Functions
override ISession	CreateAdminSession (IDatabase database)
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 IQuery	CreateQuery (ISession session)
ISession	CreateUserSession (string userName, string password)
virtual void	OnTearDown ()

Properties
QueryContext	Context [get, set]
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]

Private Member Functions
void	CreateTestTable (IQuery context)
void	AddTestData (IQuery context)

Private Attributes
ITable	table

Additional Inherited Members
Protected Attributes inherited from Deveel.Data.ContextBasedTest
const string	AdminUserName = "SA"
const string	AdminPassword = "1234567890"
const string	DatabaseName = "testdb"

Detailed Description

Definition at line 12 of file TableQueryTests.cs.

Member Function Documentation

void Deveel.Data.Linq.TableQueryTests.AddTestData ( IQuery  context )

inlineprivate

Definition at line 44 of file TableQueryTests.cs.

                                                 {
            var table = context.GetMutableTable(ObjectName.Parse("APP.people"));
            var row = table.NewRow();

            // row.SetValue("id", DataObject.Integer(0));
            row.SetDefault(0, context);
            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("id", DataObject.Integer(1));
            row.SetDefault(0, context);
            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("id", DataObject.Integer(2));
            row.SetDefault(0, context);
            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);

            context.Commit();
        }

override ISession Deveel.Data.Linq.TableQueryTests.CreateAdminSession ( IDatabase  database )

inlineprotectedvirtual

Reimplemented from Deveel.Data.ContextBasedTest.

Definition at line 17 of file TableQueryTests.cs.

                                                                           {
            using (var session = base.CreateAdminSession(database)) {
                using (var query = session.CreateQuery()) {
                    CreateTestTable(query);
                    AddTestData(query);

                    query.Commit();
                }
            }

            return base.CreateAdminSession(database);
        }

void Deveel.Data.Linq.TableQueryTests.CreateTestTable ( IQuery  context )

inlineprivate

Definition at line 30 of file TableQueryTests.cs.

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

            context.CreateTable(tableInfo);
            context.AddPrimaryKey(tableInfo.TableName, "id", "PK_PEOPLE_TABLE");
        }

void Deveel.Data.Linq.TableQueryTests.FindById ( )

inline

Definition at line 84 of file TableQueryTests.cs.

                               {
            Person entity = null;
            Assert.DoesNotThrow(() => entity = Context.Table<Person>().FindById(1));
            Assert.IsNotNull(entity);
            Assert.AreEqual(1, entity.Id);
            Assert.AreEqual("John", entity.FirstName);
        }

override void Deveel.Data.Linq.TableQueryTests.OnSetUp ( string  testName )

inlineprotectedvirtual

Reimplemented from Deveel.Data.ContextBasedTest.

Definition at line 79 of file TableQueryTests.cs.

                                                         {
            Context = new TestQueryContext(Query);
        }

void Deveel.Data.Linq.TableQueryTests.ProjectFirst ( )

inline

Definition at line 42 of file TableQueryTests.cs.

                                   {
            IQueryable<Person> queryable = null;
            Assert.DoesNotThrow(() => queryable = table.AsQueryable<Person>());
            Assert.IsNotNull(queryable);

            Person first = null;
            Assert.DoesNotThrow(() => first = queryable.First());
            Assert.IsNotNull(first);
            Assert.AreEqual("Antonello", first.FirstName);
            Assert.AreEqual("Provenzano", first.LastName);
            Assert.AreEqual(1, first.Id);
            Assert.AreEqual(0, first.Age);
        }

void Deveel.Data.Linq.TableQueryTests.QueryById ( )

inline

Definition at line 93 of file TableQueryTests.cs.

                                {
            Person entity = null;
            Assert.DoesNotThrow(() => entity = Context.Table<Person>().FirstOrDefault(x => x.Id == 1));
            Assert.IsNotNull(entity);
            Assert.AreEqual(1, entity.Id);
            Assert.AreEqual("John", entity.FirstName);
        }

void Deveel.Data.Linq.TableQueryTests.TestSetup ( )

inline

Definition at line 16 of file TableQueryTests.cs.

                                {
            var tableInfo = new TableInfo(ObjectName.Parse("APP.people"));
            tableInfo.AddColumn("id", PrimitiveTypes.Bit());
            tableInfo.AddColumn("first_name", PrimitiveTypes.String(), true);
            tableInfo.AddColumn("last_name", PrimitiveTypes.String());
            tableInfo.AddColumn("age", PrimitiveTypes.TinyInt());
            table = new TemporaryTable(tableInfo);

            var tempTable = (TemporaryTable) table;
            tempTable.NewRow(new[] {
                DataObject.BigInt(1), 
                DataObject.String("Antonello"), 
                DataObject.String("Provenzano"),
                DataObject.Null()
            });
            tempTable.NewRow(new[] {
                DataObject.BigInt(2), 
                DataObject.String("Moritz"), 
                DataObject.String("Krull"), 
                DataObject.TinyInt(31)
            });

            tempTable.BuildIndexes();
        }

Member Data Documentation

ITable Deveel.Data.Linq.TableQueryTests.table

private

Definition at line 13 of file TableQueryTests.cs.

Property Documentation

QueryContext Deveel.Data.Linq.TableQueryTests.Context

getsetprivate

Definition at line 16 of file TableQueryTests.cs.

---

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

• /var/calculate/remote/distfiles/egit-src/deveeldb.git/src/deveeldb-nunit/Deveel.Data.Linq/TableQueryTests.cs