Deveel.Data.Sql.Compile.CreateTableTests Class Reference

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

Public Member Functions
void	SimpleTable ()
void	WithIdentityColumn ()
void	WithColumnDefault ()
void	WithConstraints ()
void	WithColumnConstraints ()

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

Member Function Documentation

void Deveel.Data.Sql.Compile.CreateTableTests.SimpleTable ( )

inline

Definition at line 13 of file CreateTableTests.cs.

                                  {
            const string sql = "CREATE TABLE test (a INT NOT NULL, b VARCHAR NULL)";

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

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

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

            var createTable = (CreateTableStatement) statement;

            Assert.IsNotNullOrEmpty(createTable.TableName);
            Assert.AreEqual("test", createTable.TableName);
            Assert.IsFalse(createTable.Temporary);
            Assert.IsFalse(createTable.IfNotExists);

            Assert.AreEqual(2, createTable.Columns.Count);
            Assert.AreEqual("a", createTable.Columns[0].ColumnName);
            Assert.IsTrue(createTable.Columns[0].IsNotNull);

            Assert.AreEqual("b", createTable.Columns[1].ColumnName);
            Assert.IsFalse(createTable.Columns[1].IsNotNull);
        }

void Deveel.Data.Sql.Compile.CreateTableTests.WithColumnConstraints ( )

inline

Definition at line 116 of file CreateTableTests.cs.

                                            {
            const string sql = "CREATE TABLE test (id INT NOT NULL PRIMARY KEY)";

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

            Assert.IsInstanceOf<CreateTableStatement>(result.Statements.ElementAt(0));
            Assert.IsInstanceOf<AlterTableStatement>(result.Statements.ElementAt(1));

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

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

            var createTable = (CreateTableStatement) statement;

            Assert.IsNotNullOrEmpty(createTable.TableName);
            Assert.AreEqual("test", createTable.TableName);
        }

void Deveel.Data.Sql.Compile.CreateTableTests.WithColumnDefault ( )

inline

Definition at line 69 of file CreateTableTests.cs.

                                        {
            const string sql = "CREATE TABLE test (a VARCHAR DEFAULT 'one')";

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

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

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

            var createTable = (CreateTableStatement) statement;

            Assert.IsNotNullOrEmpty(createTable.TableName);
            Assert.AreEqual("test", createTable.TableName);

            Assert.AreEqual(1, createTable.Columns.Count);
            Assert.IsNotNull(createTable.Columns[0].DefaultExpression);
            Assert.IsInstanceOf<SqlConstantExpression>(createTable.Columns[0].DefaultExpression);
        }

void Deveel.Data.Sql.Compile.CreateTableTests.WithConstraints ( )

inline

Definition at line 93 of file CreateTableTests.cs.

                                      {
            const string sql = "CREATE TABLE test (id INT NOT NULL, UNIQUE(id))";

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

            Assert.IsInstanceOf<CreateTableStatement>(result.Statements.ElementAt(0));
            Assert.IsInstanceOf<AlterTableStatement>(result.Statements.ElementAt(1));

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

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

            var createTable = (CreateTableStatement) statement;

            Assert.IsNotNullOrEmpty(createTable.TableName);
            Assert.AreEqual("test", createTable.TableName);
        }

void Deveel.Data.Sql.Compile.CreateTableTests.WithIdentityColumn ( )

inline

Definition at line 42 of file CreateTableTests.cs.

                                         {
            const string sql = "CREATE TABLE test (id INT IDENTITY, name VARCHAR NOT NULL)";

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

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

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

            var createTable = (CreateTableStatement) statement;

            Assert.IsNotNullOrEmpty(createTable.TableName);
            Assert.AreEqual("test", createTable.TableName);
            Assert.IsFalse(createTable.Temporary);
            Assert.IsFalse(createTable.IfNotExists);

            Assert.AreEqual(2, createTable.Columns.Count);
            Assert.IsTrue(createTable.Columns[0].IsIdentity);
            Assert.IsNotNull(createTable.Columns[0].DefaultExpression);
            Assert.IsInstanceOf<SqlFunctionCallExpression>(createTable.Columns[0].DefaultExpression);
        }

---

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