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
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
|
###############################################################################
# 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 mysql.connector
from discover.configuration import Configuration
from discover.fetcher import Fetcher
from utils.string_utils import jsonify
class DbAccess(Fetcher):
conn = None
query_count_per_con = 0
# connection timeout set to 30 seconds,
# due to problems over long connections
TIMEOUT = 30
def __init__(self):
super().__init__()
self.config = Configuration()
self.conf = self.config.get("mysql")
self.connect_to_db()
cursor = DbAccess.conn.cursor(dictionary=True)
try:
# check if DB schema 'neutron' exists
cursor.execute("SELECT COUNT(*) FROM neutron.agents")
for row in cursor:
pass
self.neutron_db = "neutron"
except (AttributeError, mysql.connector.errors.ProgrammingError):
self.neutron_db = "ml2_neutron"
def db_connect(self, _host, _port, _user, _password, _database):
if DbAccess.conn:
return
try:
connector = mysql.connector
DbAccess.conn = connector.connect(host=_host, port=_port,
connection_timeout=self.TIMEOUT,
user=_user,
password=_password,
database=_database,
raise_on_warnings=True)
DbAccess.conn.ping(True) # auto-reconnect if necessary
except:
self.log.critical("failed to connect to MySQL DB")
return
DbAccess.query_count_per_con = 0
def connect_to_db(self, force=False):
if DbAccess.conn:
if not force:
return
self.log.info("DbAccess: ****** forcing reconnect, " +
"query count: %s ******",
DbAccess.query_count_per_con)
DbAccess.conn = None
self.conf = self.config.get("mysql")
cnf = self.conf
cnf['schema'] = cnf['schema'] if 'schema' in cnf else 'nova'
self.db_connect(cnf["host"], cnf["port"],
cnf["user"], cnf["password"],
cnf["schema"])
def get_objects_list_for_id(self, query, object_type, id):
self.connect_to_db(DbAccess.query_count_per_con >= 25)
DbAccess.query_count_per_con += 1
self.log.debug("query count: %s, running query:\n%s\n",
str(DbAccess.query_count_per_con), query)
cursor = DbAccess.conn.cursor(dictionary=True)
try:
if id:
cursor.execute(query, [str(id)])
else:
cursor.execute(query)
except (AttributeError, mysql.connector.errors.OperationalError) as e:
self.log.error(e)
self.connect_to_db(True)
# try again to run the query
cursor = DbAccess.conn.cursor(dictionary=True)
if id:
cursor.execute(query, [str(id)])
else:
cursor.execute(query)
rows = []
for row in cursor:
rows.append(row)
return rows
def get_objects_list(self, query, object_type):
return self.get_objects_list_for_id(query, object_type, None)
def get_objects(self, qry, type, id):
return jsonify(self.get_objects_list(qry, type))
def get(self, id):
# return list of available fetch types
ret = {
"description": "List of available fetch calls for this interface",
"types": {
"regions": "Regions of this environment",
"projects": "Projects (tenants) of this environment",
"availability_zones": "Availability zones",
"aggregates": "Host aggregates",
"aggregate_hosts": "Hosts in aggregate X (parameter: id)",
"az_hosts": "Host in availability_zone X (parameter: id)"
}
}
return jsonify(ret)
def exec(self, query, table, field, values):
try:
cursor = DbAccess.conn.cursor(dictionary=True)
cursor.execute(query, [table, field, values])
except (AttributeError, mysql.connector.errors.OperationalError) as e:
self.log.error(e)
self.connect_to_db(True)
# try again to run the query
cursor = DbAccess.conn.cursor(dictionary=True)
cursor.execute(query, [table, field, values])
rows = []
for row in cursor:
rows.append(row)
return rows
def set(self, table, field, values):
query = """INSERT INTO %s %s VALUES %s"""
return self.exec(query, table, field, values)
def delete(self, table, field, values):
query = """DELETE FROM %s WHERE %s=%s"""
return self.exec(query, table, field, values)
|
