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
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
|
#!/usr/bin/python
#
# Authors:
# - peter.bandzi@cisco.com
# - morgan.richomme@orange.com
#
# src: Peter Bandzi
# https://github.com/pbandzi/parse-robot/blob/master/convert_robot_to_json.py
#
# Copyright (c) 2015 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
#
# 0.1: This script boots the VM1 and allocates IP address from Nova
# Later, the VM2 boots then execute cloud-init to ping VM1.
# After successful ping, both the VMs are deleted.
# 0.2: measure test duration and publish results under json format
# 0.3: adapt push 2 DB after Test API refacroting
#
#
import getopt
import json
import sys
import time
import xmltodict
import functest.utils.functest_utils as functest_utils
def usage():
print """Usage:
python odlreport2db.py --xml=<output.xml> --pod=<pod name>
--installer=<installer> --database=<database url>
--scenario=<scenario>
-x, --xml xml file generated by robot test
-p, --pod POD name where the test come from
-i, --installer
-s, --scenario
-h, --help this message
"""
sys.exit(2)
def populate_detail(test):
detail = {}
detail['test_name'] = test['@name']
detail['test_status'] = test['status']
detail['test_doc'] = test['doc']
return detail
def parse_test(tests, details):
try:
for test in tests:
details.append(populate_detail(test))
except TypeError:
# tests is not iterable
details.append(populate_detail(tests))
return details
def parse_suites(suites):
data = {}
details = []
try:
for suite in suites:
data['details'] = parse_test(suite['test'], details)
except TypeError:
# suites is not iterable
data['details'] = parse_test(suites['test'], details)
return data
def main(argv):
(xml_file, pod, installer, scenario) = None, None, None, None
try:
opts, args = getopt.getopt(argv,
'x:p:i:s:h',
['xml=', 'pod=',
'installer=',
'scenario=',
'help'])
except getopt.GetoptError:
usage()
for opt, arg in opts:
if opt in ('-h', '--help'):
usage()
elif opt in ('-x', '--xml'):
xml_file = arg
elif opt in ('-p', '--pod'):
pod = arg
elif opt in ('-i', '--installer'):
installer = arg
elif opt in ('-s', '--scenario'):
scenario = arg
else:
usage()
if not all(x is not None for x in (xml_file, pod, installer, scenario)):
usage()
with open(xml_file, "r") as myfile:
xml_input = myfile.read().replace('\n', '')
# dictionary populated with data from xml file
all_data = xmltodict.parse(xml_input)['robot']
try:
data = parse_suites(all_data['suite']['suite'])
data['description'] = all_data['suite']['@name']
data['version'] = all_data['@generator']
data['test_project'] = "functest"
data['case_name'] = "odl"
data['pod_name'] = pod
data['installer'] = installer
json.dumps(data, indent=4, separators=(',', ': '))
# example:
# python odlreport2db.py -x ~/Pictures/Perso/odl/output3.xml
# -i fuel
# -p opnfv-jump-2
# -s os-odl_l2-ha
# success criteria for ODL = 100% of tests OK
status = "FAIL"
# TODO as part of the tests are executed before in the bash
# start and stoptime have no real meaning
start_time = time.time()
stop_time = start_time
tests_passed = 0
tests_failed = 0
for v in data['details']:
if v['test_status']['@status'] == "PASS":
tests_passed += 1
else:
tests_failed += 1
if (tests_failed < 1):
status = "PASS"
functest_utils.push_results_to_db(data['test_project'],
data['case_name'],
None,
start_time,
stop_time,
status,
data)
except:
print("Error pushing ODL results into DB '%s'" % sys.exc_info()[0])
if __name__ == "__main__":
main(sys.argv[1:])
|
