Changeset 9514 in genesis for tools

Timestamp:

Aug 9, 2011, 3:28:18 PM (13 years ago)

Author:

rick

Message:

Vieze hack of kijken of wind-export goed te maken is.

File:

• tools/gformat.py (modified) (1 diff)

tools/gformat.py

@@ -750 +750 @@
           f.write(generate_config(node, config, datadump))
           f.close()
+    elif sys.argv[1] == "wind-export":
+      items = dict()
+      for node in get_hostlist():
+        datadump = get_yaml(node)
+        sql = """INSERT IGNORE INTO nodes (name, name_ns, longitude, latitude)
+        VALUES ('%(nodename)s', '%(nodename)s', %(latitude)s, %(longitude)s);""" % datadump;
+        print sql
+        sql = """INSERT IGNORE INTO users_nodes (user_id, node_id, owner)
+        VALUES (
+          (SELECT id FROM users WHERE username = 'rvdzwet'),
+          (SELECT id FROM nodes WHERE name = '%(nodename)s'),
+          'Y');""" % datadump
+        print sql
+        #for config in files:
+        #  items['config'] = config
+        #  print "## Generating %(node)s %(config)s" % items
+        #  f = open("%(wdir)s/%(config)s" % items, "w")
+        #  f.write(generate_config(node, config, datadump))
+        #  f.close()
+      for node in get_hostlist():
+        datadump = get_yaml(node)
+        for iface_key in sorted([elem for elem in datadump.keys() if elem.startswith('iface_')]):
+          ifacedump = datadump[iface_key]
+          if ifacedump.has_key('mode') and ifacedump['mode'] == 'ap-wds':
+            ifacedump['nodename'] = datadump['nodename']
+            if not ifacedump.has_key('channel') or not ifacedump['channel']:
+              ifacedump['channel'] = 0
+            sql = """INSERT INTO links (node_id, type, ssid, protocol, channel, status)
+              VALUES ((SELECT id FROM nodes WHERE name = '%(nodename)s'), 'ap',
+              '%(ssid)s', 'IEEE 802.11b', %(channel)s, 'active');""" % ifacedump
+            print sql
     elif sys.argv[1] == "dns":
       make_dns(sys.argv[2] if len(sys.argv) > 2 else 'dns')