def handle_get_perspectives_option(): cookie = rest.login_holmes() perspectivesList = rest.get_perspectives(cookie) print 'Total perspectives: %s' % len(perspectivesList) if len(perspectivesList) > 0: print 'Perspectives list:', for item in perspectivesList: perspective = '"' + item['name'] + '"' print perspective,
nodePath = [] leafNodeId = -1 if debug: print "nodeId = %s" % nodeId if debug: print "entityId = %s" % entityId rootNodeId = get_node_path(nodeId, nodePath) if debug: print "rootNodeId = %s" % rootNodeId if debug: print "nodePath = %s " % nodePath queryPerspective = '-e select name from perspective where root_node_id = %s' % rootNodeId perspectiveLine = subprocess.Popen(["mysql", '-B', '-uroot', '-Dglbsce', queryPerspective], stdout=subprocess.PIPE).stdout perspectiveLine.readline() #ignoring first line (column names) perspectiveName = perspectiveLine.readline().rstrip('\n') registeredPerspectives = rest.get_perspectives(cookie) for registeredPerspective in registeredPerspectives: if registeredPerspective['name'] == perspectiveName.decode('utf-8'): break if nodePath: currentNode = nodePath.pop() if debug: print "currentNode: %s" % currentNode registeredNodes = rest.get_nodes_from_parent(registeredPerspective['id'], registeredPerspective['rootnode_id'], 'root', cookie) for registeredNode in registeredNodes: if registeredNode['text'] == currentNode.decode('utf-8'): leafNodeId = search_leaf_node_id(nodePath, registeredPerspective['id'], registeredNode['id'], cookie) else: leafNodeId = rootNodeId if debug: print "leafNodeId = %s" % leafNodeId
childNodeIdDatabase = childNodeLine.split('\t')[1].rstrip('\n') childNodeObj = { "description": "", "perspectiveId": nodeObj['perspectiveId'], "parentNodeId": nodeIdRegistered, "name": childNodeName } insert_node_subtree(childNodeObj, childNodeIdDatabase, cookie) childNodeLine = childNodeFile.readline() data = [] inputPerspectives = perspectives.DATA cookie = rest.login_holmes() registeredPerspectives = rest.get_perspectives(cookie) for x in inputPerspectives: print x for y in registeredPerspectives: if x['name'] == y['name']: cmd = "-e select name, node_id from node where parent_node_id = (select root_node_id from perspective where name = '%s')" % y[ 'name'] nodes = subprocess.Popen( ["mysql", '-B', '-uroot', '-Ddidata', cmd], stdout=subprocess.PIPE).stdout nodes.readline() #ignoring first line (column name) node = nodes.readline() while node: nodeName = node.split('\t')[0] nodeIdDatabase = node.split('\t')[1].rstrip('\n')