Пример #1
0
		public async Task<IHttpActionResult> GetDependencyTree(string objName)
        {
			try
            {
                var callTree = new CallTreeData();

                // Validation - require query
                if (string.IsNullOrEmpty(objName))
                    return Ok(callTree);

                // Try get graph from cache
                DbGraph graph = cachedGraph;

                // Load graph if not cached
                if (graph == null)
                {
                    graph = await graphService.GenerateGraph();
                    cachedGraph = graph; // Persist to cache
                }

				// Get call tree from object if found
				var obj = await graphService.GetCallTree(objName);
				if (obj != null) {
					var dic = new Dictionary<string, string[]>();
					buildDependencyDic(obj, dic);

					foreach (var entry in dic)
                    {
						// Add object entry
						callTree.objects.Add(entry.Key, entry.Value);

						// Add meta data entry for object
						var item = graph.Objects.FirstOrDefault(o => o.Name == entry.Key);
						if (item != null)
							callTree.metadata.Add(entry.Key, new ObjectData { type = item.ObjectTypeKey });
					}
				}

				return Ok(callTree);
			} 
			catch (Exception ex) 
			{
				return InternalServerError(ex);
			}
        }
Пример #2
0
        public async Task<DbGraph> GenerateGraph()
        {
            //get schema
            var schema = await getSchema();
            List<DbObjectInfo> objectInfos = schema.Objects;
            List<DbObjectReferenceRow> refTable = schema.References;

            List<DbObject> graph = new List<DbObject>();

            //collect all db objects
            foreach (var obj in objectInfos)
            {
                //ensure isnt already inserted
                var source = graph.FirstOrDefault(r => r.Name == obj.fullName);
                if (source == null)
                {
                    source = Mapper.Map(obj);
                    graph.Add(source);
                }
            }

            //merge into mapped lists
            foreach (var reference in refTable)
            {
                //try get both source and target from graph
                var source = graph.FirstOrDefault(r => r.Name == reference.fromFullName);
                var target = graph.FirstOrDefault(r => r.Name == reference.toFullName);

                //ensure both from and to objects exist in object list
				//and that the source isnt referencing the target (causes infinite loop)
                if (source == null || target == null || source.Name == target.Name)
                    continue;

                //create reference from source to target and vice versa
                if (!source.DependsOn.Any(r => r.Name == target.Name))
                {
                    source.DependsOn.Add(target);
                    target.DependedOnBy.Add(source);
                }
                
            }

            var graphObj = new DbGraph
            {
                Objects = graph,
                CapturedUtc = DateTime.UtcNow,
            };

            return graphObj;
        }