Deveel.Data.Sql.Statements.CreateViewStatement Class Reference

Inheritance diagram for Deveel.Data.Sql.Statements.CreateViewStatement:

Classes
class	Prepared

Public Member Functions
	CreateViewStatement (string viewName, SqlQueryExpression queryExpression)
	CreateViewStatement (string viewName, IEnumerable< string > columnNames, SqlQueryExpression queryExpression)
Public Member Functions inherited from Deveel.Data.Sql.Statements.SqlStatement
ITable	Execute (IRequest context)
	Prepares and evaluates this statement into a tabular result. More...

Properties
string	ViewName [get, private set]
IEnumerable< string >	ColumnNames [get, private set]
SqlQueryExpression	QueryExpression [get, private set]
bool	ReplaceIfExists [get, set]
Properties inherited from Deveel.Data.Sql.Statements.SqlStatement
SqlQuery	SourceQuery [get, set]
	Gets the SqlQuery that is the origin of this statement. More...
bool	IsFromQuery [get, private set]
	Gets a boolean value indicating if this object was formed from the parsing of a SqlQuery or if it was manually created. More...
Properties inherited from Deveel.Data.Sql.Statements.IStatement
SqlQuery	SourceQuery [get]

Private Member Functions
IStatement IPreparableStatement.	Prepare (IRequest context)

Additional Inherited Members
Static Public Member Functions inherited from Deveel.Data.Sql.Statements.SqlStatement
static IEnumerable< SqlStatement >	Parse (string sqlSource)
	Parses a given string into one of more statements. More...
static IEnumerable< SqlStatement >	Parse (IContext context, string sqlSource)
	Parses a given string into one of more statements. More...
static IEnumerable< SqlStatement >	Parse (IContext context, SqlQuery query)
Protected Member Functions inherited from Deveel.Data.Sql.Statements.SqlStatement
	SqlStatement ()
	SqlStatement (ObjectData data)
virtual void	ExecuteStatement (ExecutionContext context)
virtual void	GetData (SerializeData data)
Package Functions inherited from Deveel.Data.Sql.Statements.SqlStatement
void	SetSource (SqlQuery query)

Detailed Description

Definition at line 29 of file CreateViewStatement.cs.

Constructor & Destructor Documentation

Deveel.Data.Sql.Statements.CreateViewStatement.CreateViewStatement ( string  viewName, SqlQueryExpression  queryExpression  )

inline

Definition at line 30 of file CreateViewStatement.cs.

            : this(viewName, null, queryExpression) {
        }

Deveel.Data.Sql.Statements.CreateViewStatement.CreateViewStatement ( string  viewName, IEnumerable< string >  columnNames, SqlQueryExpression  queryExpression  )

inline

Definition at line 34 of file CreateViewStatement.cs.

                                                                                                                         {
            if (viewName == null)
                throw new ArgumentNullException("viewName");
            if (queryExpression == null)
                throw new ArgumentNullException("queryExpression");

            ViewName = viewName;
            ColumnNames = columnNames;
            QueryExpression = queryExpression;
        }

Member Function Documentation

IStatement IPreparableStatement. Deveel.Data.Sql.Statements.CreateViewStatement.Prepare ( IRequest  context )

inlineprivate

Implements Deveel.Data.Sql.Statements.IPreparableStatement.

Definition at line 53 of file CreateViewStatement.cs.

                                                                  {
            var viewName = context.Query.ResolveTableName(ViewName);

            var queryFrom = QueryExpressionFrom.Create(context, QueryExpression);
            var queryPlan = context.Query.Context.QueryPlanner().PlanQuery(new QueryInfo(context, QueryExpression));

            var colList = ColumnNames == null ? new string[0] : ColumnNames.ToArray();

            // Wrap the result around a SubsetNode to alias the columns in the
            // table correctly for this view.
            int sz = colList.Length;
            var originalNames = queryFrom.GetResolvedColumns();
            var newColumnNames = new ObjectName[originalNames.Length];

            if (sz > 0) {
                if (sz != originalNames.Length)
                    throw new InvalidOperationException("Column list is not the same size as the columns selected.");

                for (int i = 0; i < sz; ++i) {
                    var colName = colList[i];
                    newColumnNames[i] = new ObjectName(viewName, colName);
                }
            } else {
                sz = originalNames.Length;
                for (int i = 0; i < sz; ++i) {
                    newColumnNames[i] = new ObjectName(viewName, originalNames[i].Name);
                }
            }

            // Check there are no repeat column names in the table.
            for (int i = 0; i < sz; ++i) {
                var columnName = newColumnNames[i];
                for (int n = i + 1; n < sz; ++n) {
                    if (newColumnNames[n].Equals(columnName))
                        throw new InvalidOperationException(String.Format("Duplicate column name '{0}' in view. A view may not contain duplicate column names.", columnName));
                }
            }

            // Wrap the plan around a SubsetNode plan
            queryPlan = new SubsetNode(queryPlan, originalNames, newColumnNames);

            return new Prepared(viewName, QueryExpression, queryPlan, ReplaceIfExists);
        }

Property Documentation

IEnumerable<string> Deveel.Data.Sql.Statements.CreateViewStatement.ColumnNames

getprivate set

Definition at line 47 of file CreateViewStatement.cs.

SqlQueryExpression Deveel.Data.Sql.Statements.CreateViewStatement.QueryExpression

getprivate set

Definition at line 49 of file CreateViewStatement.cs.

bool Deveel.Data.Sql.Statements.CreateViewStatement.ReplaceIfExists

getset

Definition at line 51 of file CreateViewStatement.cs.

string Deveel.Data.Sql.Statements.CreateViewStatement.ViewName

getprivate set

Definition at line 45 of file CreateViewStatement.cs.

---

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

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