CreateViewTests.cs

Go to the documentation of this file.

using System;
using System.Linq;

using Deveel.Data.Sql.Statements;

using NUnit.Framework;

namespace Deveel.Data.Sql.Compile {
    [TestFixture]
    public class CreateViewTests : SqlCompileTestBase {
        [Test]
        public void WithColumns() {
            const string sql = "CREATE VIEW test_view (a, b, c) AS SELECT * FROM test";

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

            var statement = result.Statements.First();

            Assert.IsInstanceOf<CreateViewStatement>(statement);

            var createView = (CreateViewStatement) statement;
            Assert.AreEqual("test_view", createView.ViewName);
            Assert.IsNotEmpty(createView.ColumnNames);
            Assert.IsNotNull(createView.QueryExpression);
            Assert.IsFalse(createView.ReplaceIfExists);
        }

        [Test]
        public void WithoutColumns() {
            const string sql = "CREATE VIEW test_view AS SELECT a, c FROM test";

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

            var statement = result.Statements.First();

            Assert.IsInstanceOf<CreateViewStatement>(statement);

            var createView = (CreateViewStatement)statement;
            Assert.AreEqual("test_view", createView.ViewName);
            Assert.IsNull(createView.ColumnNames);
            Assert.IsNotNull(createView.QueryExpression);
            Assert.IsFalse(createView.ReplaceIfExists);
        }
    }
}