Deveel.Data.Sql.Compile.AlterTableCompileTests Class Reference

Inheritance diagram for Deveel.Data.Sql.Compile.AlterTableCompileTests:

Public Member Functions
void	AddColumn ()
void	AddMultipleColumns ()
void	AddColumnsAndUniqeContraints ()
void	AddPrimaryKeyContraint ()
void	DropColumn ()
Public Member Functions inherited from Deveel.Data.Sql.Compile.CursorCompileTests
void	DeclareCursorWithArguments ()
void	ImplicitDeclareCursor ()
void	DeclareCursorWithoutArguments ()
void	OpenCursorWithArguments ()
void	OpenCursorSimple ()
void	CloseCursor ()
void	FetchNextFromCursorInto ()
void	FetchNextImplicitCursor ()

Additional Inherited Members
Protected Member Functions inherited from Deveel.Data.Sql.Compile.SqlCompileTestBase
SqlCompileResult	Compile (string sql)

Detailed Description

Definition at line 11 of file AlterTableCompileTests.cs.

Member Function Documentation

void Deveel.Data.Sql.Compile.AlterTableCompileTests.AddColumn ( )

inline

Definition at line 13 of file AlterTableCompileTests.cs.

                                {
            const string sql = "ALTER TABLE test ADD COLUMN b INT NOT NULL";

            var result = Compile(sql);
            Assert.IsNotNull(result);
            Assert.IsFalse(result.HasErrors);
            Assert.IsNotEmpty(result.Statements);
            Assert.AreEqual(1, result.Statements.Count);

            var statement = result.Statements.First();

            Assert.IsNotNull(statement);
            Assert.IsInstanceOf<AlterTableStatement>(statement);

            var alterStatement = (AlterTableStatement) statement;
            
            Assert.AreEqual("test", alterStatement.TableName.FullName);
            Assert.IsInstanceOf<AddColumnAction>(alterStatement.Action);

            var alterAction = (AddColumnAction) alterStatement.Action;
            Assert.AreEqual("b", alterAction.Column.ColumnName);
            Assert.IsInstanceOf<NumericType>(alterAction.Column.ColumnType);
            Assert.IsTrue(alterAction.Column.IsNotNull);
        }

void Deveel.Data.Sql.Compile.AlterTableCompileTests.AddColumnsAndUniqeContraints ( )

inline

Definition at line 51 of file AlterTableCompileTests.cs.

                                                   {
            const string sql = "ALTER TABLE test ADD COLUMN b INT NOT NULL ADD CONSTRAINT c UNIQUE(a, b)";

            var result = Compile(sql);
            Assert.IsNotNull(result);
            Assert.IsFalse(result.HasErrors);
            Assert.IsNotEmpty(result.Statements);
            Assert.AreEqual(2, result.Statements.Count);

            var firstStatement = result.Statements.ElementAt(0);
            var secondStatement = result.Statements.ElementAt(1);

            Assert.IsNotNull(firstStatement);
            Assert.IsNotNull(secondStatement);

            Assert.IsInstanceOf<AlterTableStatement>(firstStatement);
            Assert.IsInstanceOf<AlterTableStatement>(secondStatement);

            var alter1 = (AlterTableStatement) firstStatement;
            var alter2 = (AlterTableStatement) secondStatement;

            Assert.IsInstanceOf<AddColumnAction>(alter1.Action);
            Assert.IsInstanceOf<AddConstraintAction>(alter2.Action);
        }

void Deveel.Data.Sql.Compile.AlterTableCompileTests.AddMultipleColumns ( )

inline

Definition at line 40 of file AlterTableCompileTests.cs.

                                         {
            const string sql = "ALTER TABLE test ADD COLUMN b INT NOT NULL ADD c VARCHAR DEFAULT 'test'";

            var result = Compile(sql);
            Assert.IsNotNull(result);
            Assert.IsFalse(result.HasErrors);
            Assert.IsNotEmpty(result.Statements);
            Assert.AreEqual(2, result.Statements.Count);
        }

void Deveel.Data.Sql.Compile.AlterTableCompileTests.AddPrimaryKeyContraint ( )

inline

Definition at line 77 of file AlterTableCompileTests.cs.

                                             {
            const string sql = "ALTER TABLE test ADD CONSTRAINT c PRIMARY KEY(id)";

            var result = Compile(sql);
            Assert.IsNotNull(result);
            Assert.IsFalse(result.HasErrors);
            Assert.IsNotEmpty(result.Statements);
            Assert.AreEqual(1, result.Statements.Count);

            var statement = result.Statements.First();

            Assert.IsNotNull(statement);
            Assert.IsInstanceOf<AlterTableStatement>(statement);

            var alterStatement = (AlterTableStatement) statement;
            
            Assert.AreEqual("test", alterStatement.TableName.FullName);
            Assert.IsInstanceOf<AddConstraintAction>(alterStatement.Action);            
        }

void Deveel.Data.Sql.Compile.AlterTableCompileTests.DropColumn ( )

inline

Definition at line 98 of file AlterTableCompileTests.cs.

                                 {
            const string sql = "ALTER TABLE test DROP COLUMN b";

            var result = Compile(sql);
            Assert.IsNotNull(result);
            Assert.IsFalse(result.HasErrors);
            Assert.IsNotEmpty(result.Statements);
            Assert.AreEqual(1, result.Statements.Count);

            var statement = result.Statements.ElementAt(0);

            Assert.IsInstanceOf<AlterTableStatement>(statement);

            var alter = (AlterTableStatement) statement;

            Assert.IsInstanceOf<DropColumnAction>(alter.Action);
        }

---

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.Compile/AlterTableCompileTests.cs