Index: tools/gformat.py
===================================================================
--- tools/gformat.py	(revision 9479)
+++ tools/gformat.py	(revision 9514)
@@ -750,4 +750,35 @@
           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')