public void ViewFromBuilder()
{
var viewName = ObjectName.Parse("APP.text_view1");
AdminQuery.CreateView(viewName, query => query
.AllColumns()
.From(from => from.Table("test_table"))
.Where(SqlExpression.Equal(SqlExpression.Reference(new ObjectName("a")), SqlExpression.Constant(1))));
}
public void SimpleView()
{
var query = (SqlQueryExpression)SqlExpression.Parse("SELECT * FROM test_table WHERE a = 1");
var viewName = ObjectName.Parse("APP.text_view1");
AdminQuery.CreateView(viewName, query);
// TODO: Assert the view exists
}