コード例 #1
0
        private static IEnumerable <TerminalUsage> GetModelClauseAndPivotTableReferences(OracleReference columnReference, bool onlyAliasOrigin)
        {
            var usages = new List <TerminalUsage>();

            if (columnReference.Owner == null)
            {
                return(usages);
            }

            var normalizedName = columnReference.NormalizedName;
            var modelClauseAndPivotTableColumnReferences = columnReference.Owner.AllColumnReferences
                                                           .Where(c => c.ColumnNodeObjectReferences.Count == 1 &&
                                                                  c != columnReference &&
                                                                  c.Placement.In(StatementPlacement.Model, StatementPlacement.PivotClause) &&
                                                                  String.Equals(c.SelectListColumn?.NormalizedName, normalizedName));

            foreach (var innerReference in modelClauseAndPivotTableColumnReferences)
            {
                var definition = new TerminalUsage {
                    Terminal = innerReference.SelectListColumn.AliasNode, Option = DisplayOptions.Definition
                };
                usages.Add(definition);

                if (!innerReference.SelectListColumn.IsDirectReference)
                {
                    continue;
                }

                if (innerReference.SelectListColumn.HasExplicitAlias)
                {
                    var usage = new TerminalUsage {
                        Terminal = innerReference.ColumnNode, Option = DisplayOptions.Usage
                    };
                    usages.Add(usage);
                }

                var objectReference = (OracleDataObjectReference)innerReference.ColumnNodeObjectReferences.First();
                foreach (var innerObjectReference in objectReference.IncludeInnerReferences)
                {
                    usages.AddRange(GetChildQueryBlockColumnReferences(innerObjectReference, innerReference, onlyAliasOrigin));
                }
            }

            if (columnReference.Owner.ModelReference != null)
            {
                foreach (var modelColumn in columnReference.Owner.ModelReference.ColumnDefinitions.Where(c => !c.IsDirectReference && c.AliasNode != null && String.Equals(c.NormalizedName, normalizedName)))
                {
                    var definition = new TerminalUsage {
                        Terminal = modelColumn.AliasNode, Option = DisplayOptions.Definition
                    };
                    usages.Add(definition);
                }
            }

            return(usages);
        }
コード例 #2
0
        private static IEnumerable <TerminalUsage> GetColumnUsagesInternal(OracleStatementSemanticModel semanticModel, StatementGrammarNode columnNode, bool onlyAliasOrigin)
        {
            var usages          = Enumerable.Empty <TerminalUsage>();
            var columnReference = semanticModel.AllReferenceContainers
                                  .SelectMany(c => c.ColumnReferences)
                                  .FirstOrDefault(c => (c.ColumnNode == columnNode || c.SelectListColumn?.AliasNode == columnNode) && c.ColumnNodeObjectReferences.Count == 1 && c.ColumnNodeColumnReferences.Count == 1);

            OracleSelectListColumn selectListColumn;

            if (columnReference != null)
            {
                var objectReference        = columnReference.ColumnNodeObjectReferences.First();
                var sourceColumnReferences = objectReference.Owner == null ? objectReference.Container.ColumnReferences : objectReference.Owner.AllColumnReferences;
                var columnReferences       = sourceColumnReferences.Where(c => IsValidReference(c, columnReference, objectReference)).ToArray();
                usages = columnReferences.Select(c => new TerminalUsage {
                    Terminal = c.ColumnNode, Option = DisplayOptions.Usage
                });

                if (objectReference is OraclePivotTableReference pivotTableReference)
                {
                    var pivotColumnAliases = pivotTableReference.PivotColumns
                                             .Where(c => c.AliasNode != null && String.Equals(c.NormalizedName, columnReference.NormalizedName))
                                             .Select(c => new TerminalUsage {
                        Terminal = c.AliasNode, Option = DisplayOptions.Definition
                    });

                    usages = usages.Concat(pivotColumnAliases);
                }

                bool searchChildren;
                if (String.Equals(columnNode.Id, Terminals.Identifier))
                {
                    searchChildren = true;

                    selectListColumn = columnReference.SelectListColumn;
                    if (selectListColumn == null)
                    {
                        selectListColumn = columnReferences.FirstOrDefault(c => c.SelectListColumn != null && c.SelectListColumn.IsDirectReference && c.SelectListColumn.HasExplicitDefinition)?.SelectListColumn;
                    }
                    else if (!selectListColumn.IsDirectReference)
                    {
                        selectListColumn = null;
                    }

                    if (selectListColumn != null && !onlyAliasOrigin && selectListColumn.HasExplicitAlias)
                    {
                        var definition = new TerminalUsage {
                            Terminal = selectListColumn.AliasNode, Option = DisplayOptions.Definition
                        };
                        usages = usages.Concat(new[] { definition });
                    }
                }
                else
                {
                    selectListColumn = columnReference.Owner.Columns.Single(c => c.AliasNode == columnNode);
                    var nodeList = Enumerable.Repeat(new TerminalUsage {
                        Terminal = selectListColumn.AliasNode, Option = DisplayOptions.Definition
                    }, 1);
                    searchChildren = selectListColumn.IsDirectReference;

                    usages = searchChildren ? usages.Concat(nodeList) : nodeList;
                }

                usages = usages.Concat(GetModelClauseAndPivotTableReferences(columnReference, onlyAliasOrigin));

                if (searchChildren)
                {
                    usages = usages.Concat(GetChildQueryBlockColumnReferences(objectReference, columnReference, onlyAliasOrigin));
                }
            }
            else
            {
                var queryBlock = semanticModel.GetQueryBlock(columnNode);
                selectListColumn = queryBlock.Columns.SingleOrDefault(c => c.AliasNode == columnNode || c.ExplicitAliasNode == columnNode);

                var usageOption = DisplayOptions.Usage;
                if (selectListColumn?.ExplicitAliasNode == columnNode)
                {
                    usageOption = DisplayOptions.Definition;

                    if (queryBlock.IsRecursive && queryBlock.FollowingConcatenatedQueryBlock != null)
                    {
                        var oracleDataObjectReference = queryBlock.FollowingConcatenatedQueryBlock.ObjectReferences.FirstOrDefault(o => o.QueryBlocks.Count == 1 && o.QueryBlocks.First() == queryBlock.FollowingConcatenatedQueryBlock);
                        usages =
                            queryBlock.FollowingConcatenatedQueryBlock.AllColumnReferences
                            .Where(c => String.Equals(c.NormalizedName, selectListColumn.NormalizedName) && c.ColumnNodeColumnReferences.Count == 1 && c.ColumnNodeObjectReferences.Count == 1 && c.ColumnNodeObjectReferences.First() == oracleDataObjectReference)
                            .Select(c => CreateStandardTerminalUsage(c.ColumnNode));
                    }
                }

                var usage = new TerminalUsage {
                    Terminal = columnNode, Option = usageOption
                };
                usages = usages.Concat(Enumerable.Repeat(usage, 1));

                if (selectListColumn == null)
                {
                    if (queryBlock.ModelReference != null)
                    {
                        selectListColumn = queryBlock.ModelReference.ColumnDefinitions.SingleOrDefault(c => c.AliasNode == columnNode);
                        if (selectListColumn != null)
                        {
                            columnReference = queryBlock.ModelReference.DimensionReferenceContainer.ColumnReferences
                                              .Concat(queryBlock.ModelReference.MeasuresReferenceContainer.ColumnReferences)
                                              .Concat(queryBlock.AllColumnReferences)
                                              .FirstOrDefault(c => String.Equals(c.NormalizedName, selectListColumn.NormalizedName));

                            if (columnReference != null)
                            {
                                return(GetColumnUsagesInternal(semanticModel, columnReference.ColumnNode, onlyAliasOrigin));
                            }
                        }
                    }
                    else
                    {
                        var pivotTableColumn =
                            queryBlock.ObjectReferences.OfType <OraclePivotTableReference>()
                            .SelectMany(pt => pt.PivotColumns.Select(c => new { PivotTable = pt, Column = c }))
                            .SingleOrDefault(ptc => ptc.Column.AliasNode == columnNode);

                        if (pivotTableColumn != null)
                        {
                            selectListColumn = pivotTableColumn.Column;
                            var pivotUsages = queryBlock.AllColumnReferences
                                              .Where(c => c.ValidObjectReference == pivotTableColumn.PivotTable && c.HasExplicitDefinition && String.Equals(c.NormalizedName, selectListColumn.NormalizedName))
                                              .Select(c => new TerminalUsage {
                                Terminal = c.ColumnNode, Option = DisplayOptions.Usage
                            });

                            usages = usages.Concat(pivotUsages);
                        }
                    }
                }
                else
                {
                    var orderByReferenceUsages = queryBlock.ColumnReferences
                                                 .Where(c => c.Placement == StatementPlacement.OrderBy && c.ValidObjectReference == queryBlock.SelfObjectReference && String.Equals(c.NormalizedName, selectListColumn.NormalizedName))
                                                 .Select(c => new TerminalUsage {
                        Terminal = c.ColumnNode, Option = DisplayOptions.Usage
                    });
                    usages = usages.Concat(orderByReferenceUsages);
                }
            }

            var parentUsages = GetParentQueryBlockUsages(selectListColumn);

            if (onlyAliasOrigin)
            {
                var columnName = columnNode.Token.Value.ToQuotedIdentifier();
                parentUsages = parentUsages.TakeWhile(u => String.Equals(u.Terminal.Token.Value.ToQuotedIdentifier(), columnName));
            }

            usages = usages.Concat(parentUsages);

            return(usages);
        }
コード例 #3
0
		private static IEnumerable<TerminalUsage> GetColumnUsagesInternal(OracleStatementSemanticModel semanticModel, StatementGrammarNode columnNode, bool onlyAliasOrigin)
		{
			var usages = Enumerable.Empty<TerminalUsage>();
			var columnReference = semanticModel.AllReferenceContainers
				.SelectMany(c => c.ColumnReferences)
				.FirstOrDefault(c => (c.ColumnNode == columnNode || c.SelectListColumn?.AliasNode == columnNode) && c.ColumnNodeObjectReferences.Count == 1 && c.ColumnNodeColumnReferences.Count == 1);

			OracleSelectListColumn selectListColumn;
			if (columnReference != null)
			{
				var objectReference = columnReference.ColumnNodeObjectReferences.First();
				var sourceColumnReferences = objectReference.Owner == null ? objectReference.Container.ColumnReferences : objectReference.Owner.AllColumnReferences;
				var columnReferences = sourceColumnReferences.Where(c => IsValidReference(c, columnReference, objectReference)).ToArray();
				usages = columnReferences.Select(c => new TerminalUsage { Terminal = c.ColumnNode, Option = DisplayOptions.Usage });

				var pivotTableReference = objectReference as OraclePivotTableReference;
				if (pivotTableReference != null)
				{
					var pivotColumnAliases = pivotTableReference.PivotColumns
						.Where(c => c.AliasNode != null && String.Equals(c.NormalizedName, columnReference.NormalizedName))
						.Select(c => new TerminalUsage { Terminal = c.AliasNode, Option = DisplayOptions.Definition });

					usages = usages.Concat(pivotColumnAliases);
				}

				bool searchChildren;
				if (String.Equals(columnNode.Id, Terminals.Identifier))
				{
					searchChildren = true;

					selectListColumn = columnReference.SelectListColumn;
					if (selectListColumn == null)
					{
						selectListColumn = columnReferences.FirstOrDefault(c => c.SelectListColumn != null && c.SelectListColumn.IsDirectReference && c.SelectListColumn.HasExplicitDefinition)?.SelectListColumn;
					}
					else if (!selectListColumn.IsDirectReference)
					{
						selectListColumn = null;
					}

					if (selectListColumn != null && !onlyAliasOrigin && selectListColumn.HasExplicitAlias)
					{
						var definition = new TerminalUsage { Terminal = selectListColumn.AliasNode, Option = DisplayOptions.Definition };
						usages = usages.Concat(new[] { definition });
					}
				}
				else
				{
					selectListColumn = columnReference.Owner.Columns.Single(c => c.AliasNode == columnNode);
					var nodeList = Enumerable.Repeat(new TerminalUsage { Terminal = selectListColumn.AliasNode, Option = DisplayOptions.Definition }, 1);
					searchChildren = selectListColumn.IsDirectReference;

					usages = searchChildren ? usages.Concat(nodeList) : nodeList;
				}

				usages = usages.Concat(GetModelClauseAndPivotTableReferences(columnReference, onlyAliasOrigin));

				if (searchChildren)
				{
					usages = usages.Concat(GetChildQueryBlockColumnReferences(objectReference, columnReference, onlyAliasOrigin));
				}
			}
			else
			{
				var queryBlock = semanticModel.GetQueryBlock(columnNode);
				selectListColumn = queryBlock.Columns.SingleOrDefault(c => c.AliasNode == columnNode || c.ExplicitAliasNode == columnNode);

				var usageOption = DisplayOptions.Usage;
				if (selectListColumn?.ExplicitAliasNode == columnNode)
				{
					usageOption = DisplayOptions.Definition;

					if (queryBlock.IsRecursive && queryBlock.FollowingConcatenatedQueryBlock != null)
					{
						var oracleDataObjectReference = queryBlock.FollowingConcatenatedQueryBlock.ObjectReferences.FirstOrDefault(o => o.QueryBlocks.Count == 1 && o.QueryBlocks.First() == queryBlock.FollowingConcatenatedQueryBlock);
						usages =
							queryBlock.FollowingConcatenatedQueryBlock.AllColumnReferences
								.Where(c => String.Equals(c.NormalizedName, selectListColumn.NormalizedName) && c.ColumnNodeColumnReferences.Count == 1 && c.ColumnNodeObjectReferences.Count == 1 && c.ColumnNodeObjectReferences.First() == oracleDataObjectReference)
								.Select(c => CreateStandardTerminalUsage(c.ColumnNode));
					}
				}

				var usage = new TerminalUsage { Terminal = columnNode, Option = usageOption };
				usages = usages.Concat(Enumerable.Repeat(usage, 1));

				if (selectListColumn == null)
				{
					if (queryBlock.ModelReference != null)
					{
						selectListColumn = queryBlock.ModelReference.ColumnDefinitions.SingleOrDefault(c => c.AliasNode == columnNode);
						if (selectListColumn != null)
						{
							columnReference = queryBlock.ModelReference.DimensionReferenceContainer.ColumnReferences
								.Concat(queryBlock.ModelReference.MeasuresReferenceContainer.ColumnReferences)
								.Concat(queryBlock.AllColumnReferences)
								.FirstOrDefault(c => String.Equals(c.NormalizedName, selectListColumn.NormalizedName));

							if (columnReference != null)
							{
								return GetColumnUsagesInternal(semanticModel, columnReference.ColumnNode, onlyAliasOrigin);
							}
						}
					}
					else
					{
						var pivotTableColumn =
							queryBlock.ObjectReferences.OfType<OraclePivotTableReference>()
								.SelectMany(pt => pt.PivotColumns.Select(c => new { PivotTable = pt, Column = c }))
								.SingleOrDefault(ptc => ptc.Column.AliasNode == columnNode);

						if (pivotTableColumn != null)
						{
							selectListColumn = pivotTableColumn.Column;
							var pivotUsages = queryBlock.AllColumnReferences
								.Where(c => c.ValidObjectReference == pivotTableColumn.PivotTable && c.HasExplicitDefinition && String.Equals(c.NormalizedName, selectListColumn.NormalizedName))
								.Select(c => new TerminalUsage { Terminal = c.ColumnNode, Option = DisplayOptions.Usage });

							usages = usages.Concat(pivotUsages);
						}
					}
				}
				else
				{
					var orderByReferenceUsages = queryBlock.ColumnReferences
						.Where(c => c.Placement == StatementPlacement.OrderBy && c.ValidObjectReference == queryBlock.SelfObjectReference && String.Equals(c.NormalizedName, selectListColumn.NormalizedName))
						.Select(c => new TerminalUsage { Terminal = c.ColumnNode, Option = DisplayOptions.Usage });
					usages = usages.Concat(orderByReferenceUsages);
				}
			}

			var parentUsages = GetParentQueryBlockUsages(selectListColumn);
			if (onlyAliasOrigin)
			{
				var columnName = columnNode.Token.Value.ToQuotedIdentifier();
				parentUsages = parentUsages.TakeWhile(u => String.Equals(u.Terminal.Token.Value.ToQuotedIdentifier(), columnName));
			}

			usages = usages.Concat(parentUsages);

			return usages;
		}
コード例 #4
0
		private static IEnumerable<TerminalUsage> GetModelClauseAndPivotTableReferences(OracleReference columnReference, bool onlyAliasOrigin)
		{
			var usages = new List<TerminalUsage>();
			if (columnReference.Owner == null)
			{
				return usages;
			}

			var normalizedName = columnReference.NormalizedName;
			var modelClauseAndPivotTableColumnReferences = columnReference.Owner.AllColumnReferences
				.Where(c => c.ColumnNodeObjectReferences.Count == 1 &&
				            c != columnReference &&
				            c.Placement.In(StatementPlacement.Model, StatementPlacement.PivotClause) &&
				            String.Equals(c.SelectListColumn?.NormalizedName, normalizedName));

			foreach (var innerReference in modelClauseAndPivotTableColumnReferences)
			{
				var definition = new TerminalUsage { Terminal = innerReference.SelectListColumn.AliasNode, Option = DisplayOptions.Definition };
				usages.Add(definition);

				if (!innerReference.SelectListColumn.IsDirectReference)
				{
					continue;
				}

				if (innerReference.SelectListColumn.HasExplicitAlias)
				{
					var usage = new TerminalUsage { Terminal = innerReference.ColumnNode, Option = DisplayOptions.Usage };
					usages.Add(usage);
				}

				var objectReference = (OracleDataObjectReference)innerReference.ColumnNodeObjectReferences.First();
				foreach (var innerObjectReference in objectReference.IncludeInnerReferences)
				{
					usages.AddRange(GetChildQueryBlockColumnReferences(innerObjectReference, innerReference, onlyAliasOrigin));
				}
			}

			if (columnReference.Owner.ModelReference != null)
			{
				foreach (var modelColumn in columnReference.Owner.ModelReference.ColumnDefinitions.Where(c => !c.IsDirectReference && c.AliasNode != null && String.Equals(c.NormalizedName, normalizedName)))
				{
					var definition = new TerminalUsage { Terminal = modelColumn.AliasNode, Option = DisplayOptions.Definition };
					usages.Add(definition);
				}
			}

			return usages;
		}