Deveel.Data.Sql.Statements.UpdateStatementTests Class Reference

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

Public Member Functions
void	ParseSimpleUpdate ()
void	ParseSimpleUpdateWithLimit ()
Public Member Functions inherited from Deveel.Data.ContextBasedTest
void	TestSetUp ()
void	TestFixtureSetUp ()
void	TestTearDown ()
void	TestFixtureTearDown ()

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

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

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 29 of file UpdateStatementTests.cs.

Member Function Documentation

void Deveel.Data.Sql.Statements.UpdateStatementTests.AddTestData ( IQuery  context )

inlineprivate

Definition at line 51 of file UpdateStatementTests.cs.

                                                 {
            var table = context.GetMutableTable(ObjectName.Parse("APP.test_table"));
            var row = table.NewRow();
            row.SetValue("id", DataObject.Integer(0));
            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.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.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);
        }

override IQuery Deveel.Data.Sql.Statements.UpdateStatementTests.CreateQuery ( ISession  session )

inlineprotectedvirtual

Reimplemented from Deveel.Data.ContextBasedTest.

Definition at line 30 of file UpdateStatementTests.cs.

                                                                {
            var query = base.CreateQuery(session);
            CreateTestTable(query);
            AddTestData(query);
            return query;
        }

void Deveel.Data.Sql.Statements.UpdateStatementTests.CreateTestTable ( IQuery  context )

inlineprivate

Definition at line 37 of file UpdateStatementTests.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());

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

void Deveel.Data.Sql.Statements.UpdateStatementTests.ParseSimpleUpdate ( )

inline

Definition at line 79 of file UpdateStatementTests.cs.

                                        {
            const string sql = "UPDATE table SET col1 = 'testUpdate', col2 = 22 WHERE id = 1";

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

            var statement = statements.FirstOrDefault();

            Assert.IsNotNull(statement);
            Assert.IsInstanceOf<UpdateStatement>(statement);
        }

void Deveel.Data.Sql.Statements.UpdateStatementTests.ParseSimpleUpdateWithLimit ( )

inline

Definition at line 93 of file UpdateStatementTests.cs.

                                                 {
            const string sql = "UPDATE table SET col1 = 'testUpdate', col2 = 22 WHERE id = 1 LIMIT 20";

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

            var statement = statements.FirstOrDefault();

            Assert.IsNotNull(statement);
            Assert.IsInstanceOf<UpdateStatement>(statement);
        }

---

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