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"
|