Deveel.Data.DropViewTests.CreateTestView C# (CSharp) Method

        private static void CreateTestView(IQuery query)
        {
            var tn1 = ObjectName.Parse("APP.test_table1");
            query.Access().CreateTable(table => table
                .Named(tn1)
                .WithColumn("id", PrimitiveTypes.Integer())
                .WithColumn("name", PrimitiveTypes.String())
                .WithColumn("date", PrimitiveTypes.DateTime()));

            query.Session.Access().AddPrimaryKey(tn1, "id");

            var exp = SqlExpression.Parse("SELECT * FROM APP.test_table1");
            query.CreateView(ObjectName.Parse("APP.test_view1"), (SqlQueryExpression)exp);
        }