Changeset 9072

Timestamp:

Apr 18, 2011, 3:12:48 PM (14 years ago)

Author:

dennisw

Message:

dataimport.py - werkt soort van, import data naar gheat_meting en gheat_accespoint, rest volgt. SSID's zonder naam worden tijdelijk geskipped wegens 'None' problemen.

File:

• src/django_gheat/gheat/dataimport.py (modified) (2 diffs)

src/django_gheat/gheat/dataimport.py

@@ -3 +3 @@
 import settings
 setup_environ(settings)
-#from xml.dom.minidom import parse
 from gheat.models import *
 from lxml import etree
 
-doc = etree.parse('/home/dennis/Desktop/test.netxml')
-test = doc.findall('wireless-network')
+datasource = etree.parse('/home/dennis/Desktop/test2.netxml')
+doc = datasource.findall('wireless-network')
 
-for wnetwork in test:
+for wnetwork in doc:
+    enc = wnetwork.find('SSID/encryption')
+    if enc != None: enc = 'true'
+    else: enc = 'false'
+    ssid = wnetwork.find('SSID/essid')
+    if ssid != None: ssid = ssid.text
+    else: ssid = 'hidden'
     bssid = wnetwork.find('BSSID')
-    print bssid.text
-    manuf = wnetwork.find('manuf')
-    print manuf.text
-
-#    attr = wnetwork.attrib
-#    print(attr['BSSID'])
-#    print(attr['lon'])
-
-#    for bssid in wnetwork.getElementsByTagName('BSSID'):
-#        bssid = bssid.firstChild.nodeValue
-#        print bssid
-#    for manuf in wnetwork.getElementsByTagName('manuf'):
-#        manuf = manuf.firstChild.nodeValue
-#        print manuf
-#    for enc in wnetwork.getElementsByTagName('encryption'):
-#        enc = enc.firstChild.nodeValue
-#        print enc
-#    for ssid in wnetwork.getElementsByTagName('ssid'):
-#        ssid = ssid.firstChild.nodeValue
-#        print ssid
-#    for lat in wnetwork.getElementsByTagName('min-lat'):
-#        lat = lat.firstChild.nodeValue
-#        print lat
-#    for lon in wnetwork.getElementsByTagName('min-lon'):
-#        lon = lon.firstChild.nodeValue
-#        print lon
+    if bssid != None: bssid = bssid.text
+    lat = wnetwork.find('gps-info/min-lat')
+    if lat != None: lat = lat.text
+    lon = wnetwork.find('gps-info/min-lon')
+    if lon != None: lon = lon.text
+    if ssid is None: continue
+    print enc, ssid, bssid, lat, lon 
 
 #    g = Gebruiker.objects.get_or_create(naam= , email= )
@@ -45 +31 @@
 #    mr = MeetRondje.objects.create(datum= , naam= , gebruiker_id=g.id , apparatuur_id=a.id )
 #    mr.save()
-#    ap = Accespoint.objects.get_or_create(mac= , ssid= , encryptie= )
-#    ap.save()
-#    m = Meting.objects.create(meetrondje_id=mr.id, accespoint_id=ap.id, latitude= , longitude= , signaal= )
-#    m.save()
+    ap = Accespoint(mac=bssid, ssid=ssid, encryptie=enc)
+    ap.save()
+    m = Meting(meetrondje_id=1, accespoint_id=ap.id, latitude=lat, longitude=lon, signaal=100)
+    m.save()