static ViewColumnNode.IViewColumnNode BuildOrGetColumnNode(ViewTable vTable, Database.MetaColumn metaColumn, string columnName, Operation.ExpressionParsingContext expressionParsingContext)
{
var column = vTable.GetColumnByName(columnName);
if (column == null)
{
var columnNode = (ViewColumnNode.IViewColumnNode)Operation.ColumnCreator.CreateColumn(typeof(ViewColumnNodeTyped <>), metaColumn.Type);
ViewColumnNode viewColumnNode = new ViewColumnNode(vTable, metaColumn, expressionParsingContext);
columnNode.SetColumn(viewColumnNode);
vTable.SetColumn(metaColumn, columnNode.GetColumn());
return(columnNode);
}
// View table use expand column to decorate the IViewColumnNode with required functionality for expanding rows.
// So we need to get the underlying column, which is the IViewColumnNode we want.
if (column is IColumnDecorator)
{
column = (column as IColumnDecorator).GetBaseColumn();
}
if (column is ViewColumnNode.IViewColumnNode)
{
return((ViewColumnNode.IViewColumnNode)column);
}
else
{
throw new Exception("Expecting column '" + vTable.GetName() + "." + metaColumn.Name + "' to be a from a node data type (ViewColumnNode) but is of type '" + column.GetType().Name + "'");
}
}
public void Build(BuildingData buildingData, Node node, ViewTable vTable, ViewTable parent, Operation.ExpressionParsingContext parentExpressionParsingContext)
{
// build selects
vTable.SetupDataSelectSet(dataSelectSet.Build(vTable, buildingData.Schema, buildingData.BaseSchema));
// build columns
switch (type)
{
case Data.DataType.Node:
// these column are declarations
foreach (var colb in column)
{
MetaColumn metaColumn = buildingData.MetaTable.GetColumnByName(colb.name);
colb.BuildOrUpdateDeclaration(buildingData, vTable, ref metaColumn, vTable.ExpressionParsingContext);
}
// for node type we need to build all child node right away as they defines the entries in this viewtable
var validChildNodeIndices = new List <int>();
int iValidChild = 0;
for (int iChild = 0; iChild != child.Count; ++iChild)
{
var c = child[iChild];
if (c.EvaluateCondition(buildingData.Schema, vTable, vTable.ExpressionParsingContext))
{
validChildNodeIndices.Add(iChild);
c.BuildAsNode(buildingData, vTable, (long)iValidChild, vTable.ExpressionParsingContext);
++iValidChild;
}
}
if (iValidChild != child.Count)
{
vTable.ValidChildNodeIndices = validChildNodeIndices.ToArray();
}
else
{
vTable.ValidChildNodeIndices = null;
}
break;
case DataType.Select:
// these columns are instances of ViewColumn. They have the result of select statement as entries
foreach (var colb in column)
{
MetaColumn metaColumn = buildingData.MetaTable.GetColumnByName(colb.name);
var newColumn = colb.Build(buildingData, node, vTable, vTable.ExpressionParsingContext, ref metaColumn);
vTable.SetColumn(metaColumn, newColumn.GetColumn());
}
break;
}
}
public ViewTable Build(BuildingData buildingData, ViewTable parent, long row, ViewSchema vs, Database.Schema baseSchema, Operation.ExpressionParsingContext parentExpressionParsingContext)
{
// Check for usage error from data.
if (parent == null && String.IsNullOrEmpty(name))
{
DebugUtility.LogError("Table need a name");
return(null);
}
using (ScopeDebugContext.Func(() => { return("View '" + GetFullName() + "'"); }))
{
// Check for usage error from code.
DebugUtility.CheckCondition(parent == null || (parent.node == this.parent), "Parent ViewTable must points to the node's parent while building child node's ViewTable.");
ViewTable vTable = new ViewTable(vs, baseSchema, this, parentExpressionParsingContext);
// If has local select set, create it and add it to the expression parsing context hierarchy. see [Figure.1]
vTable.SetupLocalSelectSet(localSelectSet.Build(vTable, vs, baseSchema));
MetaTable metaTable = BuildOrGetMetaTable(parent, vTable);
if (buildingData.MetaTable == null)
{
buildingData.MetaTable = metaTable;
}
//declare columns
foreach (var colb in column)
{
MetaColumn metaColumn = metaTable.GetColumnByName(colb.name);
colb.BuildOrUpdateDeclaration(buildingData, vTable, ref metaColumn, vTable.ExpressionParsingContext);
}
if (data != null)
{
data.Build(buildingData, this, vTable, parent, parentExpressionParsingContext);
}
// Fix meta columns (that does not have a data type set) to their fallback value
foreach (var fb in buildingData.FallbackColumnType)
{
if (fb.Key.Type == null)
{
fb.Key.Type = fb.Value;
}
}
//Build missing column with default behavior
for (int i = 0; i != metaTable.GetColumnCount(); ++i)
{
var metaColumn = metaTable.GetColumnByIndex(i);
var column = vTable.GetColumnByIndex(i);
if (column == null)
{
if (metaColumn.DefaultMergeAlgorithm != null)
{
//when we have a merge algorithm, set the entries as the result of each group's merge value.
column = ViewColumn.Builder.BuildColumnNodeMerge(vTable, metaColumn, parentExpressionParsingContext);
}
vTable.SetColumn(metaColumn, column);
}
}
if (data != null && data.type == Data.DataType.Select && vTable.dataSelectSet.IsManyToMany())
{
DebugUtility.LogError("Cannot build a view using a many-to-many select statement. Specify a row value for your select statement where condition(s).");
MemoryProfilerAnalytics.AddMetaDatatoEvent <MemoryProfilerAnalytics.LoadViewXMLEvent>(7);
}
return(vTable);
}
}
public ViewTable Build(ViewTable parent, long row, ViewSchema vs, Database.Schema baseSchema, Operation.ExpressionParsingContext parentExpressionParsingContext)
{
// Check for usage error from data.
if (parent == null && String.IsNullOrEmpty(name))
{
DebugUtility.LogError(FormatErrorContextInfo(vs) + ": Table need a name");
return(null);
}
using (ScopeDebugContext.Func(() => { return("View '" + GetFullName() + "'"); }))
{
// Check for usage error from code.
DebugUtility.CheckCondition(parent == null || (parent.node == this.parent), FormatErrorContextInfo(vs) + ": Parent ViewTable must points to the node's parent while building child node's ViewTable.");
if (data == null)
{
//no data
return(null);
}
ViewTable vTable = new ViewTable(vs, baseSchema);
vTable.node = this;
vTable.parentExpressionParsingContext = parentExpressionParsingContext;
vTable.expressionParsingContext = parentExpressionParsingContext;
// If has local select set, create it and add it to the expression parsing context hierarchy. see [Figure.1]
vTable.localSelectSet = localSelectSet.Build(vTable, vs, baseSchema);
if (vTable.localSelectSet != null)
{
vTable.expressionParsingContext = new Operation.ExpressionParsingContext(vTable.expressionParsingContext, vTable.localSelectSet);
}
MetaTable metaTable = BuildOrGetMetaTable(parent, vTable);
//declare columns
foreach (var colb in column)
{
MetaColumn metaColumn = metaTable.GetColumnByName(colb.name);
bool hadMetaColumn = metaColumn != null;
colb.BuildOrUpdateDeclaration(ref metaColumn);
// add the metacolum to the metatable if it just got created
if (!hadMetaColumn)
{
metaTable.AddColumn(metaColumn);
}
}
data.Build(this, vTable, parent, vs, baseSchema, parentExpressionParsingContext, metaTable);
//Build missing column with default behavior
for (int i = 0; i != metaTable.GetColumnCount(); ++i)
{
var metaColumn = metaTable.GetColumnByIndex(i);
var column = vTable.GetColumnByIndex(i);
if (column == null)
{
if (metaColumn.DefaultMergeAlgorithm != null)
{
//when we have a merge algorithm, set the entries as the result of each group's merge value.
column = ViewColumn.Builder.BuildColumnNodeMerge(vTable, metaColumn, parentExpressionParsingContext);
}
vTable.SetColumn(metaColumn, column);
}
}
if (data.type == Data.DataType.Select && vTable.dataSelectSet.IsManyToMany())
{
DebugUtility.LogError("Cannot build the view table '" + vTable.GetName() + "' using a many-to-many select statement. Specify a row value for your select statement where condition(s).");
MemoryProfilerAnalytics.AddMetaDatatoEvent <MemoryProfilerAnalytics.LoadViewXMLEvent>(7);
}
return(vTable);
}
}
public void Build(Node node, ViewTable vTable, ViewTable parent, ViewSchema vs, Database.Schema baseSchema, Operation.ExpressionParsingContext parentExpressionParsingContext, MetaTable metaTable)
{
// build selects
vTable.dataSelectSet = dataSelectSet.Build(vTable, vs, baseSchema);
if (vTable.dataSelectSet != null)
{
// add the select set to the expression parsing context hierarchy. see [Figure.1]
vTable.expressionParsingContext = new Operation.ExpressionParsingContext(vTable.expressionParsingContext, vTable.dataSelectSet);
}
// build columns
switch (type)
{
case Data.DataType.Node:
// these column are declarations
foreach (var colb in column)
{
MetaColumn metaColumn = metaTable.GetColumnByName(colb.name);
bool hadMetaColumn = metaColumn != null;
colb.BuildOrUpdateDeclaration(ref metaColumn);
// add the metacolum to the metatable if it just got created
if (!hadMetaColumn)
{
metaTable.AddColumn(metaColumn);
}
}
// for node type we need to build all child node right away as they defines the entries in this viewtable
var validChildNodeIndices = new List <int>();
int iValidChild = 0;
for (int iChild = 0; iChild != child.Count; ++iChild)
{
var c = child[iChild];
if (c.EvaluateCondition(vs, vTable, vTable.expressionParsingContext))
{
validChildNodeIndices.Add(iChild);
c.BuildAsNode(vTable, (long)iValidChild, vs, baseSchema, vTable.expressionParsingContext);
++iValidChild;
}
}
if (iValidChild != child.Count)
{
vTable.ValidChildNodeIndices = validChildNodeIndices.ToArray();
}
else
{
vTable.ValidChildNodeIndices = null;
}
break;
case DataType.Select:
// these columns are instances of ViewColumn. They have the result of select statement as entries
foreach (var colb in column)
{
MetaColumn metaColumn = metaTable.GetColumnByName(colb.name);
bool hadMetaColumn = metaColumn != null;
var newColumn = colb.Build(node, vs, baseSchema, vTable, vTable.expressionParsingContext, ref metaColumn);
// add the metacolum to the metatable if it just got created
if (!hadMetaColumn)
{
metaTable.AddColumn(metaColumn);
}
vTable.SetColumn(metaColumn, newColumn.GetColumn());
}
break;
}
}