summaryrefslogtreecommitdiffstats
path: root/utils/test
diff options
context:
space:
mode:
authorSerenaFeng <feng.xiaowei@zte.com.cn>2016-06-07 16:09:19 +0800
committerSerenaFeng <feng.xiaowei@zte.com.cn>2016-06-08 10:45:56 +0800
commit559102692edcf56b1769d9cee7b5ff1e7332894e (patch)
tree51102ce5c68c507455a64c2bd300905bd91c6de3 /utils/test
parent5ac39a0e6c542ac2857d4d877c0df02598cf9b4f (diff)
add mongodb update script in testAPI
add file update.py JIRA: FUNCTEST-298 Change-Id: I419e9b72464ac04562f5550409561d269d9f0d36 Signed-off-by: SerenaFeng <feng.xiaowei@zte.com.cn>
Diffstat (limited to 'utils/test')
-rw-r--r--utils/test/result_collection_api/update/changes.py25
-rw-r--r--utils/test/result_collection_api/update/update.py86
-rw-r--r--utils/test/result_collection_api/update/utils.py6
3 files changed, 116 insertions, 1 deletions
diff --git a/utils/test/result_collection_api/update/changes.py b/utils/test/result_collection_api/update/changes.py
new file mode 100644
index 000000000..42ab67b22
--- /dev/null
+++ b/utils/test/result_collection_api/update/changes.py
@@ -0,0 +1,25 @@
+##############################################################################
+# Copyright (c) 2016 ZTE Corporation
+# feng.xiaowei@zte.com.cn
+# 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
+##############################################################################
+collections_old2New = {
+ 'pod': 'pods',
+ 'test_projects': 'projects',
+ 'test_testcases': 'testcases',
+ 'test_results': 'results'
+}
+
+fields_old2New = {
+ 'test_results': [({}, {'creation_date': 'start_date'})]
+}
+
+docs_old2New = {
+ 'test_results': [
+ ({'criteria': 'failed'}, {'criteria': 'FAILED'}),
+ ({'criteria': 'passed'}, {'criteria': 'PASS'})
+ ]
+}
diff --git a/utils/test/result_collection_api/update/update.py b/utils/test/result_collection_api/update/update.py
new file mode 100644
index 000000000..8b385a0b3
--- /dev/null
+++ b/utils/test/result_collection_api/update/update.py
@@ -0,0 +1,86 @@
+##############################################################################
+# Copyright (c) 2016 ZTE Corporation
+# feng.xiaowei@zte.com.cn
+# 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 argparse
+
+from pymongo import MongoClient
+
+from utils import main, parse_mongodb_url
+from changes import collections_old2New, fields_old2New, docs_old2New
+
+parser = argparse.ArgumentParser(description='Update MongoDBs')
+
+parser.add_argument('-u', '--url',
+ type=str,
+ required=False,
+ default='mongodb://127.0.0.1:27017/',
+ help='Mongo DB URL for Backups')
+
+parser.add_argument('-d', '--db',
+ type=str,
+ required=False,
+ default='test_results_collection',
+ help='database for the update.')
+
+
+def assert_collections(a_dict):
+ if a_dict is not None:
+ collections = eval_db('collection_names')
+ no_collections = []
+ for collection in a_dict.keys():
+ if collection not in collections:
+ no_collections.append(collection)
+ assert len(no_collections) == 0, \
+ 'collections {} not exist'.format(no_collections)
+
+
+def rename_collections(a_dict):
+ if a_dict is not None:
+ for collection, new_name in a_dict.iteritems():
+ eval_collection(collection, 'rename', new_name)
+
+
+def rename_fields(a_dict):
+ collection_update(a_dict, '$rename')
+
+
+def change_docs(a_dict):
+ collection_update(a_dict, '$set')
+
+
+def eval_db(method, *args, **kwargs):
+ return eval('db.%s(*args, **kwargs)' % method)
+
+
+def eval_collection(collection, method, *args, **kwargs):
+ return eval('db.%s.%s(*args, **kwargs)' % (collection, method))
+
+
+def collection_update(a_dict, operator):
+ if a_dict is not None:
+ for collection, updates in a_dict.iteritems():
+ for (query, doc) in updates:
+ doc_dict = {operator: doc}
+ eval_collection(collection, 'update', query,
+ doc_dict, upsert=False, multi=True)
+
+
+def update(args):
+ parse_mongodb_url(args.url)
+ client = MongoClient(args.url)
+ global db
+ db = client[args.db]
+ assert_collections(docs_old2New)
+ assert_collections(fields_old2New)
+ assert_collections(collections_old2New)
+ change_docs(docs_old2New)
+ rename_fields(fields_old2New)
+ rename_collections(collections_old2New)
+
+if __name__ == '__main__':
+ main(update, parser)
diff --git a/utils/test/result_collection_api/update/utils.py b/utils/test/result_collection_api/update/utils.py
index ef93f33cf..a18ff0389 100644
--- a/utils/test/result_collection_api/update/utils.py
+++ b/utils/test/result_collection_api/update/utils.py
@@ -16,10 +16,14 @@ def get_abspath(path):
return os.path.abspath(path)
-def url_parse(url):
+def parse_mongodb_url(url):
url = urlparse.urlparse(url)
assert url.scheme == 'mongodb', 'URL must be a MongoDB URL'
+ return url
+
+def url_parse(url):
+ url = parse_mongodb_url(url)
return url.username, url.password, url.hostname, url.port