Deveel.Data.Sql.Views.QueryExtensions Class Reference

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

Detailed Description

Definition at line 26 of file QueryExtensions.cs.

Member Function Documentation

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

inlinestatic

Definition at line 31 of file QueryExtensions.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.Direct()) {
                systemContext.GrantToUserOnTable(viewInfo.ViewName, context.UserName(), Privileges.TableAll);
            }
        }

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

inlinestatic

Definition at line 55 of file QueryExtensions.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.QueryExtensions.DropView ( this IQuery  context, ObjectName  viewName  )

inlinestatic

Definition at line 65 of file QueryExtensions.cs.

                                                                              {
            DropView(context, viewName, false);
        }

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

inlinestatic

Definition at line 69 of file QueryExtensions.cs.

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

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

inlinestatic

Definition at line 73 of file QueryExtensions.cs.

                                                                                             {
            DropViews(context, viewNames, false);
        }

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

inlinestatic

Definition at line 77 of file QueryExtensions.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.QueryExtensions.GetView ( this IQuery  context, ObjectName  viewName  )

inlinestatic

Definition at line 108 of file QueryExtensions.cs.

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

static IQueryPlanNode Deveel.Data.Sql.Views.QueryExtensions.GetViewQueryPlan ( this IQuery  context, ObjectName  viewName  )

inlinestatic

Definition at line 112 of file QueryExtensions.cs.

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

static bool Deveel.Data.Sql.Views.QueryExtensions.ViewExists ( this IQuery  context, ObjectName  viewName  )

inlinestatic

Definition at line 27 of file QueryExtensions.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/QueryExtensions.cs