/
Reading from Janusgraph DB

Reading from Janusgraph DB

Feb 13, 2023

Services, resources, tosca type definitions, users etc are all stored by SDC in a janusgraph DB in the sdctitan table in the cassandra DB. The following details how the information stored in the janusgraph can be viewed

  1. Run janusgraph server

    1. This  can be used to start up a janusgraph server can then be used to read from the DB​​​

      • ​set your ip address in the docker-compose file​​

        • If you are using a local DB use the following command to get your local ip

          • ip route get 8.8.8.8 | awk '/src/{ print $7 }'

      • ​docker-compose -f docker-compose-cql-es.yml up

  2. ​Start gemlin​​

    1. Login to the janusgraph server

      • docker exec -it jce-janusgraph bash

    2. Start gremlin

      • bin/gremlin.sh

  3. ​Read

    1. Connect to the graph

      • :remote connect tinkerpop.server conf/remote.yaml

    2. Use gremlin query commands to execute queries to the DB, for example (note the ":>" is part of the command):

      • :> g.V() - list all vertices

      • ​​​​:> g.V().has('name', 'myService') - list vertices with name 'myService'

      • :> g.V().has('name', 'myService').valueMap() - show details of vertices with name 'myService'

      • :> g.V().has('name', 'myService').properties() - properties of vertices with name 'myService'

      • :> g.V().has('name', 'myService').properties('metadata').value() - value of the property "metadata" of vertices with name 'myService'

      • :> g.V().has('nodeLabel', 'dataType') - data type vertices

        • :> g.V().has('nodeLabel', 'dataType').count() - total of data type vertices

        • :> g.V().has('name', 'ericsson.datatypes.nfv.InstantiateVnfOperationAdditionalParameters').properties()

      • node types (VFCs)

        • All node types

          • :> g.V().has('nodeLabel', 'node_type')

        • All nodes that derives from tosca.nodes.Root

          • :> g.V().has('nodeLabel', 'node_type').has('toscaResourceName', 'tosca.nodes.Root').in('DERIVED_FROM')

      • ​model

        • Model with given name

          • :> g.V().has('name', 'ETSI SOL001 v2.5.1')​​

        • Model with given id

          • :> g.V().has('uid', 'model.ETSI SOL001 v2.5.1')

        • All models

          • :> g.V().has('nodeLabel', 'model')

        • All Service Templates (Service, VF, PNF, etc.) that is associated to the model​

          • :> ​g.V().has('uid', 'model.ETSI SOL001 v2.5.1').out('MODEL_ELEMENT').has('nodeLabel', 'topology_template')

  4. Export

    1. The entire graph can be exported for viewing with a compatible tool by using the following gremlin command which exports to a file with the given name

      • :> graph.io(graphml()).writeGraph("export.xml")​​

  5. View

    1. ​Cytoscape can be used to view the exported graph. It can be downloded from:

    2. Once running, select the below to import the graph:

      • ​File -> Import -> Network From File ​