syncplcdb.py

   1 #!/usr/bin/python
   2
   3 import sys
   4 from monitor.wrapper import plc
   5 from monitor import database
   6 from monitor import config
   7
   8 def dsites_from_lsites(l_sites):
   9         d_sites = {}
  10         id2lb = {}
  11         for site in l_sites:
  12                 if not site['login_base'] in d_sites:
  13                         d_sites[site['login_base']] = site
  14                         id2lb[site['site_id']] = site['login_base']
  15                 else:
  16                         #print "Two sites have the same login_base value %s!" % site['login_base']
  17                         sys.exit(1)
  18         return (d_sites, id2lb)
  19
  20 def dsn_from_dsln(d_sites, id2lb, l_nodes):
  21         lb2hn = {}
  22         dsn = {}
  23         hn2lb = {}
  24         for node in l_nodes:
  25                 # this won't reach sites without nodes, which I guess isn't a problem.
  26                 if node['site_id'] in id2lb.keys():
  27                         login_base = id2lb[node['site_id']]
  28                 else:
  29                         print "%s has a foreign site_id %s" % (node['hostname'],
  30                                                                                                         node['site_id'])
  31                         continue
  32                         for i in id2lb:
  33                                 print i, " ", id2lb[i]
  34                         raise Exception, "Node has missing site id!! %s %d" %(node['hostname'], node['site_id'])
  35                 if not login_base in dsn:
  36                         lb2hn[login_base] = []
  37                         dsn[login_base] = {}
  38                         dsn[login_base]['plc'] = d_sites[login_base]
  39                         dsn[login_base]['monitor'] = {} # event log, or something
  40
  41                 hostname = node['hostname']
  42                 lb2hn[login_base].append(node)
  43                 dsn[login_base][hostname] = {}
  44                 dsn[login_base][hostname]['plc'] = node
  45                 dsn[login_base][hostname]['comon'] = {}
  46                 dsn[login_base][hostname]['monitor'] = {}
  47
  48                 hn2lb[hostname] = login_base
  49         return (dsn, hn2lb, lb2hn)
  50
  51 def create_netid2ip(l_nodes, l_nodenetworks):
  52         netid2ip = {}
  53         for node in l_nodes:
  54                 for netid in node['nodenetwork_ids']:
  55                         found = False
  56                         for nn in l_nodenetworks:
  57                                 if nn['nodenetwork_id'] == netid:
  58                                         found = True
  59                                         netid2ip[netid] = nn['ip']
  60                         if not found:
  61                                 print "ERROR! %s" % node
  62
  63         return netid2ip
  64
  65 l_sites = None
  66 l_nodes = None
  67 l_pcus = None
  68 l_nodenetworks = None
  69
  70 plcdb_hn2lb = None
  71 plcdb_lb2hn = None
  72 plcdb_netid2ip = None
  73
  74 def init():
  75         global l_sites
  76         global l_nodes
  77         global l_pcus
  78         global l_nodenetworks
  79         global plcdb_hn2lb
  80         global plcdb_lb2hn
  81         global plcdb_netid2ip
  82
  83         api = plc.getCachedAuthAPI()
  84         l_sites = api.GetSites({'peer_id':None},
  85                                                         ['login_base', 'site_id', 'abbreviated_name', 'latitude',
  86                                                         'longitude', 'max_slices', 'slice_ids', 'node_ids' ])
  87         l_nodes = api.GetNodes({'peer_id':None},
  88                                                         ['hostname', 'node_id', 'ports', 'site_id', 'version', 'last_updated',
  89                                                          'date_created', 'last_contact', 'pcu_ids', 'nodenetwork_ids'])
  90         l_pcus = api.GetPCUs()
  91         l_nodenetworks = api.GetNodeNetworks()
  92
  93         (d_sites,id2lb) = dsites_from_lsites(l_sites)
  94         (plcdb, hn2lb, lb2hn) = dsn_from_dsln(d_sites, id2lb, l_nodes)
  95         netid2ip = create_netid2ip(l_nodes, l_nodenetworks)
  96
  97         plcdb_hn2lb = hn2lb
  98         plcdb_lb2hn = lb2hn
  99         plcdb_netid2ip = netid2ip
 100
 101         return l_nodes
 102
 103 def create_plcdb():
 104
 105         # get sites, and stats
 106         l_sites = plc.getSites({'peer_id':None}, ['login_base', 'site_id', 'abbreviated_name', 'latitude', 'longitude',
 107                                                                                           'max_slices', 'slice_ids', 'node_ids' ])
 108         if len(l_sites) == 0:
 109                 sys.exit(1)
 110         (d_sites,id2lb) = dsites_from_lsites(l_sites)
 111
 112         # get nodes at each site, and
 113         l_nodes = plc.getNodes({'peer_id':None}, ['hostname', 'node_id', 'ports', 'site_id', 'version',
 114                                                   'last_updated', 'date_created', 'last_contact', 'pcu_ids', 'nodenetwork_ids'])
 115
 116         l_nodenetworks = plc.getNodeNetworks()
 117         (plcdb, hn2lb, lb2hn) = dsn_from_dsln(d_sites, id2lb, l_nodes)
 118         netid2ip = create_netid2ip(l_nodes, l_nodenetworks)
 119
 120         # save information for future.
 121         id2lb = id2lb
 122         hn2lb = hn2lb
 123         db = plcdb
 124
 125         if ('cachenodes' in dir(config) and config.cachenodes) or \
 126                 'cachenodes' not in dir(config):
 127                 database.dbDump("plcdb_hn2lb", hn2lb)
 128                 database.dbDump("plcdb_lb2hn", lb2hn)
 129                 database.dbDump("plcdb_netid2ip", netid2ip)
 130                 database.dbDump("l_plcnodenetworks", l_nodenetworks)
 131                 database.dbDump("l_plcnodes", l_nodes)
 132                 database.dbDump("l_plcsites", l_sites)
 133
 134         return l_nodes
 135
 136
 137 if __name__ == '__main__':
 138         create_plcdb()