1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54
|
#!/usr/bin/env python
from vtk import *
# Network Database
database = vtkSQLDatabase.CreateFromURL("psql://bnwylie@tlp-ds.sandia.gov:5432/sunburst")
database.Open("")
vertex_query_string = """
select d.ip, d.name, i.country_name,i.region_name,i.city_name,i.latitude, i.longitude
from dnsnames d, ipligence i where ip4(d.ip)<<= ip_range;
"""
edge_query_string = """
select src, dst, dport from tcpsummary where dport != 80
"""
vertex_query = database.GetQueryInstance()
vertex_query.SetQuery(vertex_query_string)
edge_query = database.GetQueryInstance()
edge_query.SetQuery(edge_query_string)
vertex_table = vtkRowQueryToTable()
vertex_table.SetQuery(vertex_query)
edge_table = vtkRowQueryToTable()
edge_table.SetQuery(edge_query)
# Make a graph
graph = vtkTableToGraph()
graph.AddInputConnection(0,edge_table.GetOutputPort())
graph.AddInputConnection(1,vertex_table.GetOutputPort())
graph.AddLinkVertex("src", "ip", False)
graph.AddLinkVertex("dst", "ip", False)
graph.AddLinkEdge("src", "dst")
view = vtkGraphLayoutView()
view.AddRepresentationFromInputConnection(graph.GetOutputPort())
view.SetVertexLabelArrayName("ip")
view.SetVertexLabelVisibility(True)
view.SetEdgeColorArrayName("dport")
view.SetColorEdges(True)
theme = vtkViewTheme.CreateMellowTheme()
view.ApplyViewTheme(theme)
view.GetRenderWindow().SetSize(600, 600)
view.ResetCamera()
view.Render()
view.GetInteractor().Start()
|