Deveel.Data.Sql.Statements.InsertIntoStatementTests Class Reference

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

Public Member Functions
void	ParseValuesInsert_OneRow ()
void	ParseValueInsert_MultipleRows ()
void	ParserSetInsert ()
void	ParseInsertSelect ()
Public Member Functions inherited from Deveel.Data.ContextBasedTest
void	TestSetUp ()
void	TestFixtureSetUp ()
void	TestTearDown ()
void	TestFixtureTearDown ()

Private Member Functions
void	CreateTestTable ()

Additional Inherited Members
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	OnSetUp (string testName)
virtual void	OnTearDown ()
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 InsertIntoStatementTests.cs.

Member Function Documentation

void Deveel.Data.Sql.Statements.InsertIntoStatementTests.CreateTestTable ( )

inlineprivate

Definition at line 29 of file InsertIntoStatementTests.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.Statements.InsertIntoStatementTests.ParseInsertSelect ( )

inline

Definition at line 111 of file InsertIntoStatementTests.cs.

                                        {
            const string sql = "INSERT INTO test_table FROM (SELECT * FROM table2 WHERE arg1 = 1)";

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

            var statementList = statements.ToList();
            Assert.IsNotEmpty(statementList);
            Assert.AreEqual(1, statementList.Count);

            var statement = statementList[0];
            Assert.IsInstanceOf<InsertSelectStatement>(statement);
        }

void Deveel.Data.Sql.Statements.InsertIntoStatementTests.ParserSetInsert ( )

inline

Definition at line 89 of file InsertIntoStatementTests.cs.

                                      {
            const string sql =
                "INSERT INTO test_table SET first_name = 'Antonello', last_name = 'Provenzano', birth_date = TODATE('1980-06-04')";

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

            var statementList = statements.ToList();
            Assert.IsNotEmpty(statementList);
            Assert.AreEqual(1, statementList.Count);

            var statement = statementList[0];
            Assert.IsInstanceOf<InsertStatement>(statement);

            var insertStatement = (InsertStatement)statement;
            Assert.AreEqual("test_table", insertStatement.TableName);
            Assert.AreEqual(3, insertStatement.ColumnNames.Count());
            Assert.AreEqual(1, insertStatement.Values.Count());
        }

void Deveel.Data.Sql.Statements.InsertIntoStatementTests.ParseValueInsert_MultipleRows ( )

inline

Definition at line 66 of file InsertIntoStatementTests.cs.

                                                    {
            const string sql = "INSERT INTO test_table (first_name, last_name, birth_date) " +
                "VALUES ('Antonello', 'Provenzano', TOODATE('1980-06-04')), " + 
                "('Sebastiano', 'Provenzano', TODATE('1981-08-27'))";

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

            var statementList = statements.ToList();
            Assert.IsNotEmpty(statementList);
            Assert.AreEqual(1, statementList.Count);

            var statement = statementList[0];
            Assert.IsInstanceOf<InsertStatement>(statement);

            var insertStatement = (InsertStatement)statement;
            Assert.AreEqual("test_table", insertStatement.TableName);
            Assert.AreEqual(3, insertStatement.ColumnNames.Count());
            Assert.AreEqual(2, insertStatement.Values.Count());
        }

void Deveel.Data.Sql.Statements.InsertIntoStatementTests.ParseValuesInsert_OneRow ( )

inline

Definition at line 44 of file InsertIntoStatementTests.cs.

                                               {
            const string sql = "INSERT INTO test_table (first_name, last_name, birth_date) "+
                "VALUES ('Antonello', 'Provenzano', TOODATE('1980-06-04'))";

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

            var statementList = statements.ToList();
            Assert.IsNotEmpty(statementList);
            Assert.AreEqual(1, statementList.Count);

            var statement = statementList[0];
            Assert.IsInstanceOf<InsertStatement>(statement);

            var insertStatement = (InsertStatement) statement;
            Assert.AreEqual("test_table", insertStatement.TableName);
            Assert.AreEqual(3, insertStatement.ColumnNames.Count());
            Assert.AreEqual(1, insertStatement.Values.Count());
        }

---

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