Пример #1
0
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,
Пример #2
0
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')