Changeset 6524

Timestamp:

Dec 30, 2008, 11:01:23 PM (16 years ago)

Author:

RIck van der Zwet

Message:

• As requested during exodus presentation, CSV exports of nodes and interfaces

Location:

trunk/exodus

Files:

• templates/exodus-template.html (modified) (1 diff)
• templates/viewCSVlist.html (copied) (copied from trunk/exodus/templates/viewNodelist.html ) (1 diff, 1 prop)
• urls.py (modified) (1 diff)
• views.py (modified) (2 diffs)

trunk/exodus/templates/exodus-template.html ¶

@@ -18 +18 @@
           &nbsp;&nbsp;<A class="menu" href="{% url advanced_admin exodus %}">Admin</a><br>
           &nbsp;&nbsp;<A class="menu" href="{% url exodus.views.viewNodelist %}">Node List</a><br>
+          &nbsp;&nbsp;<A class="menu" href="{% url csvIndex %}">CSV Exports</a><br>
           </div>
         </td>

trunk/exodus/templates/viewCSVlist.html ¶

@@ -3 +3 @@
 {% block content %}
 
-<P class="blue"> Node List </P>
-
-{% if nodes %}
+<P class="blue"> CSV Export List </P>
         <table border="3" cellpadding="1">
-        {% for node in nodes %}
                 <tr>
-                        <td class="list" ><a class="list"href="{% url exodus.views.viewNode node.name %}">{{ node.name }}</a></td>
-                        {% for configFile in configFiles %}
-                                <td><a href="{% url exodus.views.configFile "freebsd-5.0" node.name configFile %}">{{ configFile }}</a></td>
-                        {% endfor %}
+                        <td class="list" ><a class="list" href="{% url exodus.views.viewNodesCSVlist %}">nodes.csv</a></td>
                 </tr>
-
-    {% endfor %}
+                <tr>
+                        <td class="list" ><a class="list" href="{% url exodus.views.viewInterfacesCSVlist %}">interfaces.csv</a></td>
+                </tr>
         </table>
-{% else %}
-    <p class="blue"> No nodes are available </p>
-{% endif %}
-
 {% endblock %}
 

trunk/exodus/urls.py ¶

@@ -15 +15 @@
     (r'^view/node/(?P<node>.+)/$', 'exodus.views.viewNode'),
     (r'^nagios/$', 'exodus.views.nagios'),
+
+    # CSV 'export' views
+    url(r'^view/csv/$', 'exodus.urls.direct_to_template', {'template': 'viewCSVlist.html'}, "csvIndex"),
+    (r'^view/csv/nodes.csv$', 'exodus.views.viewNodesCSVlist'),
+    (r'^view/csv/interfaces.csv$', 'exodus.views.viewInterfacesCSVlist'),
 
     # config urls

trunk/exodus/views.py ¶

@@ -1 +1 @@
 # (c) Roland van Laar 2006
 
+import csv
+from django.http import HttpResponse
 from django.shortcuts import render_to_response
 from django.template import RequestContext
 from socket import gethostname 
+
 
 from exodus.models import Node
@@ -22 +25 @@
         'resolv.conf' )
     return render_to_response('viewNodelist.html', {'nodes' : nodes, 
-            'configFiles' : configFiles}) 
+            'configFiles' : configFiles})
+
+def viewNodesCSVlist(request):
+    response = HttpResponse(mimetype='text/csv')
+    response['Content-Disposition'] = 'attachment; filename=nodes.csv'
+    nodes = Node.objects.all()
+
+    writer = csv.writer(response)
+    writer.writerow(['name', 'location', 'longitude', 'latitude', 'masterip'])
+    for node in nodes:
+        writer.writerow([node.name, node.location.description, node.location.longitude, node.location.latitude, node.masterip])
+
+    return response
+
+
+def viewInterfacesCSVlist(request):
+    response = HttpResponse(mimetype='text/csv')
+    response['Content-Disposition'] = 'attachment; filename=interfaces.csv'
+    nodes = Node.objects.all()
+
+    writer = csv.writer(response)
+    writer.writerow(["iface","node","type","ssid","channel","antenna","polar","direction","mode","ip","netmask","linknode", "linkiface"])
+    for node in nodes:
+        for nic in node.interface_set.all():
+            if nic == nic.link:
+                mode = 'master'
+            else:
+                mode = 'slave'
+            writer.writerow([nic.iface, node.name, nic.type, nic.ssid, nic.channel,
+                nic.antenna, nic.get_polar_display(), nic.get_direction_display(),
+                mode, nic.ip, nic.netmask, nic.link.node, nic.link.iface])
+    return response
 
 def configFile(request, version, node, file):