Merge "Calipso initial release for OPNFV"

1 files changed, 40 insertions, 0 deletions

diff --git a/app/test/fetch/db_fetch/test_data/db_access.py b/app/test/fetch/db_fetch/test_data/db_access.py
new file mode 100644
index 0000000..a4ad548
--- /dev/null
+++ b/app/test/fetch/db_fetch/test_data/db_access.py
@@ -0,0 +1,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"
+    }
+]