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
|
###############################################################################
# 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 #
###############################################################################
DB_CONFIG = {
"host": "10.56.20.239",
"name": "mysql",
"password": "102QreDdiD5sKcvNf9qbHrmr",
"port": 3307.0,
"user": "root",
"schema": "nova"
}
QUERY_WITHOUT_ID = """
SELECT id, name
FROM nova.aggregates
WHERE deleted = 0
"""
QUERY_WITH_ID = """
SELECT CONCAT('aggregate-', a.name, '-', host) AS id, host AS name
FROM nova.aggregate_hosts ah
JOIN nova.aggregates a ON a.id = ah.aggregate_id
WHERE ah.deleted = 0 AND aggregate_id = %s
"""
ID = "2"
OBJECT_TYPE = "host aggregate"
OBJECTS_LIST = [
{
"id": 1,
"name": "osdna-agg"
}
]
|
