Deveel.Data.Sql.Views.QueryContextExtensions Class Reference

Static Public Member Functions
static bool	ViewExists (this IQueryContext context, ObjectName viewName)
static void	DefineView (this IQueryContext context, ViewInfo viewInfo, bool replaceIfExists)
static void	DefineView (this IQueryContext context, ObjectName viewName, IQueryPlanNode queryPlan, bool replaceIfExists)
static void	DropView (this IQueryContext context, ObjectName viewName)
static void	DropView (this IQueryContext context, ObjectName viewName, bool ifExists)
static void	DropViews (this IQueryContext context, IEnumerable< ObjectName > viewNames)
static void	DropViews (this IQueryContext context, IEnumerable< ObjectName > viewNames, bool onlyIfExists)
static View	GetView (this IQueryContext context, ObjectName viewName)
static IQueryPlanNode	GetViewQueryPlan (this IQueryContext context, ObjectName viewName)

Detailed Description

Definition at line 10 of file QueryContext.Views.cs.

Member Function Documentation

static void Deveel.Data.Sql.Views.QueryContextExtensions.DefineView ( this IQueryContext  context, ViewInfo  viewInfo, bool  replaceIfExists  )

inlinestatic

Definition at line 15 of file QueryContext.Views.cs.

                                                                                                           {
            var tablesInPlan = viewInfo.QueryPlan.DiscoverTableNames();
            foreach (var tableName in tablesInPlan) {
                if (!context.UserCanSelectFromTable(tableName))
                    throw new InvalidAccessException(context.UserName(), tableName);
            }

            if (context.ViewExists(viewInfo.ViewName)) {
                if (!replaceIfExists)
                    throw new InvalidOperationException(
                        String.Format("The view {0} already exists and the REPLCE clause was not specified.", viewInfo.ViewName));

                context.DropObject(DbObjectType.View, viewInfo.ViewName);
            }

            context.CreateObject(viewInfo);

            // The initial grants for a view is to give the user who created it
            // full access.
            using (var systemContext = context.ForSystemUser()) {
                systemContext.GrantToUserOnTable(viewInfo.ViewName, context.UserName(), Privileges.TableAll);
            }
        }

static void Deveel.Data.Sql.Views.QueryContextExtensions.DefineView ( this IQueryContext  context, ObjectName  viewName, IQueryPlanNode  queryPlan, bool  replaceIfExists  )

inlinestatic

Definition at line 39 of file QueryContext.Views.cs.

                                                                                                                                       {
            // We have to execute the plan to get the TableInfo that represents the
            // result of the view execution.
            var table = queryPlan.Evaluate(context);
            var tableInfo = table.TableInfo.Alias(viewName);

            var viewInfo = new ViewInfo(tableInfo, null, queryPlan);
            context.DefineView(viewInfo, replaceIfExists);
        }

static void Deveel.Data.Sql.Views.QueryContextExtensions.DropView ( this IQueryContext  context, ObjectName  viewName  )

inlinestatic

Definition at line 49 of file QueryContext.Views.cs.

                                                                                     {
            DropView(context, viewName, false);
        }

static void Deveel.Data.Sql.Views.QueryContextExtensions.DropView ( this IQueryContext  context, ObjectName  viewName, bool  ifExists  )

inlinestatic

Definition at line 53 of file QueryContext.Views.cs.

                                                                                                    {
            context.DropViews(new[] { viewName }, ifExists);
        }

static void Deveel.Data.Sql.Views.QueryContextExtensions.DropViews ( this IQueryContext  context, IEnumerable< ObjectName >  viewNames  )

inlinestatic

Definition at line 57 of file QueryContext.Views.cs.

                                                                                                    {
            DropViews(context, viewNames, false);
        }

static void Deveel.Data.Sql.Views.QueryContextExtensions.DropViews ( this IQueryContext  context, IEnumerable< ObjectName >  viewNames, bool  onlyIfExists  )

inlinestatic

Definition at line 61 of file QueryContext.Views.cs.

                                                                                                                       {
            var viewNameList = viewNames.ToList();
            foreach (var tableName in viewNameList) {
                if (!context.UserCanDropObject(DbObjectType.View, tableName))
                    throw new MissingPrivilegesException(context.UserName(), tableName, Privileges.Drop);
            }

            // If the 'only if exists' flag is false, we need to check tables to drop
            // exist first.
            if (!onlyIfExists) {
                // For each table to drop.
                foreach (var viewName in viewNameList) {
                    // If view doesn't exist, throw an error
                    if (!context.ViewExists(viewName)) {
                        throw new ObjectNotFoundException(viewName, String.Format("The view '{0}' does not exist and cannot be dropped.", viewName));
                    }
                }
            }

            foreach (var viewName in viewNameList) {
                // Does the table already exist?
                if (context.ViewExists(viewName)) {
                    // Drop table in the transaction
                    context.DropObject(DbObjectType.Table, viewName);

                    // Revoke all the grants on the table
                    context.RevokeAllGrantsOnView(viewName);
                }
            }
        }

static View Deveel.Data.Sql.Views.QueryContextExtensions.GetView ( this IQueryContext  context, ObjectName  viewName  )

inlinestatic

Definition at line 92 of file QueryContext.Views.cs.

                                                                                    {
            return context.GetObject(DbObjectType.View, viewName, AccessType.Read) as View;
        }

static IQueryPlanNode Deveel.Data.Sql.Views.QueryContextExtensions.GetViewQueryPlan ( this IQueryContext  context, ObjectName  viewName  )

inlinestatic

Definition at line 96 of file QueryContext.Views.cs.

                                                                                                       {
            var view = context.GetView(viewName);
            return view == null ? null : view.QueryPlan;
        }

static bool Deveel.Data.Sql.Views.QueryContextExtensions.ViewExists ( this IQueryContext  context, ObjectName  viewName  )

inlinestatic

Definition at line 11 of file QueryContext.Views.cs.

                                                                                       {
            return context.ObjectExists(DbObjectType.View, viewName);
        }

---

The documentation for this class was generated from the following file:

• /var/calculate/remote/distfiles/egit-src/deveeldb.git/src/deveeldb/Deveel.Data.Sql.Views/QueryContext.Views.cs