aboutsummaryrefslogtreecommitdiffstats
path: root/app/discover/fetchers/db/db_fetch_az_network_hosts.py
blob: 09043ea95f9081051f52bec1e1fa28b2da62b050 (plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
###############################################################################
# Copyright (c) 2017 Koren Lev (Cisco Systems), Yaron Yogev (Cisco Systems)   #
# and others                                                                  #
#                                                                             #
# All rights reserved. This program and the accompanying materials            #
# are made available under the terms of the Apache License, Version 2.0       #
# which accompanies this distribution, and is available at                    #
# http://www.apache.org/licenses/LICENSE-2.0                                  #
###############################################################################
import json

from discover.fetchers.db.db_access import DbAccess


class DbFetchAZNetworkHosts(DbAccess):

  def get(self, id):
    query = """
      SELECT DISTINCT host, host AS id, configurations
      FROM neutron.agents
      WHERE agent_type = 'Metadata agent'
    """
    results = self.get_objects_list(query, "host")
    for r in results:
      self.set_host_details(r)
    return results

  def set_host_details(self, r):
    config = json.loads(r["configurations"])
    r["ip_address"] = config["nova_metadata_ip"]
    r["host_type"] = "Network Node"