File: psql_database.py

package info (click to toggle)
paraview 5.9.0-2
  • links: PTS, VCS
  • area: main
  • in suites: bullseye
  • size: 367,928 kB
  • sloc: cpp: 2,870,477; ansic: 1,329,317; python: 132,607; xml: 98,045; sh: 5,265; java: 4,541; yacc: 4,385; f90: 3,099; perl: 2,363; lex: 1,950; javascript: 1,574; objc: 143; makefile: 135; tcl: 59; pascal: 50; fortran: 27
file content (54 lines) | stat: -rw-r--r-- 1,407 bytes parent folder | download | duplicates (10)
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()