aboutsummaryrefslogtreecommitdiffstats
path: root/app/test/fetch/db_fetch/test_data/db_access.py
blob: d7b10e529382f7466da21d4c3564a7a0701ebd6e (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
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",
            "pwd": "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"
    }
]