1 ##############################################################################
2 # Copyright (c) 2015 Orange
3 # guyrodrigue.koffi@orange.com / koffirodrigue@gmail.com
4 # All rights reserved. This program and the accompanying materials
5 # are made available under the terms of the Apache License, Version 2.0
6 # which accompanies this distribution, and is available at
7 # http://www.apache.org/licenses/LICENSE-2.0
8 ##############################################################################
10 from datetime import datetime
11 from datetime import timedelta
14 from bson import objectid
16 from opnfv_testapi.common import config
17 from opnfv_testapi.common import message
18 from opnfv_testapi.common import raises
19 from opnfv_testapi.resources import handlers
20 from opnfv_testapi.resources import result_models
21 from opnfv_testapi.tornado_swagger import swagger
22 from opnfv_testapi.ui.auth import constants as auth_const
24 CONF = config.Config()
27 class GenericResultHandler(handlers.GenericApiHandler):
28 def __init__(self, application, request, **kwargs):
29 super(GenericResultHandler, self).__init__(application,
32 self.table = self.db_results
33 self.table_cls = result_models.TestResult
35 def get_int(self, key, value):
39 raises.BadRequest(message.must_int(key))
46 query['public'] = {'$not': {'$eq': 'false'}}
47 for k in self.request.query_arguments.keys():
48 v = self.get_query_argument(k)
49 if k == 'project' or k == 'pod' or k == 'case':
50 query[k + '_name'] = v
52 v = self.get_int(k, v)
54 period = datetime.now() - timedelta(days=v)
55 obj = {"$gte": str(period)}
56 query['start_date'] = obj
57 elif k == 'trust_indicator':
58 query[k + '.current'] = float(v)
60 date_range.update({'$gte': str(v)})
62 date_range.update({'$lt': str(v)})
64 openid = self.get_secure_cookie(auth_const.OPENID)
65 role = self.get_secure_cookie(auth_const.ROLE)
66 logging.info('role:%s', role)
69 if role != "reviewer":
70 query['user'] = openid
71 elif k != 'last' and k != 'page':
74 query['start_date'] = date_range
76 # if $lt is not provided,
77 # empty/None/null/'' start_date will also be returned
78 if 'start_date' in query and '$lt' not in query['start_date']:
79 query['start_date'].update({'$lt': str(datetime.now())})
84 class ResultsCLHandler(GenericResultHandler):
85 @swagger.operation(nickname="queryTestResults")
88 @description: Retrieve result(s) for a test project
90 @notes: Retrieve result(s) for a test project on a specific pod.
91 Available filters for this request are :
92 - project : project name
95 - version : platform version (Arno-R1, ...)
96 - installer : fuel/apex/compass/joid/daisy
97 - build_tag : Jenkins build tag name
98 - period : x last days, incompatible with from/to
99 - from : starting time in 2016-01-01 or 2016-01-01 00:01:23
100 - to : ending time in 2016-01-01 or 2016-01-01 00:01:23
101 - scenario : the test scenario (previously version)
102 - criteria : the global criteria status passed or failed
103 - trust_indicator : evaluate the stability of the test case
104 to avoid running systematically long and stable test case
105 - signed : get logined user result
107 GET /results/project=functest&case=vPing&version=Arno-R1 \
108 &pod=pod_name&period=15&signed
109 @return 200: all test results consist with query,
110 empty list if no result is found
111 @rtype: L{TestResults}
116 @param project: project name
117 @type project: L{string}
119 @required project: False
120 @param case: case name
121 @type case: L{string}
123 @required case: False
124 @param version: i.e. Colorado
125 @type version: L{string}
127 @required version: False
128 @param installer: fuel/apex/joid/compass
129 @type installer: L{string}
131 @required installer: False
132 @param build_tag: i.e. v3.0
133 @type build_tag: L{string}
135 @required build_tag: False
136 @param scenario: i.e. odl
137 @type scenario: L{string}
139 @required scenario: False
140 @param criteria: i.e. passed
141 @type criteria: L{string}
143 @required criteria: False
144 @param period: last days
145 @type period: L{string}
147 @required period: False
148 @param from: i.e. 2016-01-01 or 2016-01-01 00:01:23
149 @type from: L{string}
151 @required from: False
152 @param to: i.e. 2016-01-01 or 2016-01-01 00:01:23
156 @param last: last records stored until now
157 @type last: L{string}
159 @required last: False
160 @param page: which page to list
163 @required page: False
164 @param trust_indicator: must be float
165 @type trust_indicator: L{float}
166 @in trust_indicator: query
167 @required trust_indicator: False
168 @param signed: user results or all results
169 @type signed: L{string}
171 @required signed: False
173 limitations = {'sort': {'_id': -1}}
174 last = self.get_query_argument('last', 0)
176 last = self.get_int('last', last)
177 limitations.update({'last': last})
179 page = self.get_query_argument('page', None)
181 page = self.get_int('page', page)
182 limitations.update({'page': page,
183 'per_page': CONF.api_results_per_page})
185 self._list(query=self.set_query(), **limitations)
187 @swagger.operation(nickname="createTestResult")
190 @description: create a test result
191 @param body: result to be created
192 @type body: L{ResultCreateRequest}
194 @rtype: L{CreateResponse}
195 @return 200: result is created.
196 @raise 404: pod/project/testcase not exist
197 @raise 400: body/pod_name/project_name/case_name not provided
203 return {'name': self.json_args.get('pod_name')}
206 return {'name': self.json_args.get('project_name')}
208 def testcase_query():
209 return {'project_name': self.json_args.get('project_name'),
210 'name': self.json_args.get('case_name')}
212 miss_fields = ['pod_name', 'project_name', 'case_name']
213 carriers = [('pods', pod_query),
214 ('projects', project_query),
215 ('testcases', testcase_query)]
217 self._create(miss_fields=miss_fields, carriers=carriers)
220 class ResultsUploadHandler(ResultsCLHandler):
221 @swagger.operation(nickname="uploadTestResult")
224 @description: upload and create a test result
225 @param body: result to be created
226 @type body: L{ResultCreateRequest}
228 @rtype: L{CreateResponse}
229 @return 200: result is created.
230 @raise 404: pod/project/testcase not exist
231 @raise 400: body/pod_name/project_name/case_name not provided
233 logging.info('file upload')
234 fileinfo = self.request.files['file'][0]
235 is_public = self.get_body_argument('public')
236 logging.warning('public:%s', is_public)
237 logging.info('results is :%s', fileinfo['filename'])
238 logging.info('results is :%s', fileinfo['body'])
239 self.json_args = json.loads(fileinfo['body']).copy()
240 self.json_args['public'] = is_public
242 openid = self.get_secure_cookie(auth_const.OPENID)
244 self.json_args['user'] = openid
246 super(ResultsUploadHandler, self)._post()
249 class ResultsGURHandler(GenericResultHandler):
250 @swagger.operation(nickname='getTestResultById')
251 def get(self, result_id):
253 @description: get a single result by result_id
254 @rtype: L{TestResult}
255 @return 200: test result exist
256 @raise 404: test result not exist
259 query["_id"] = objectid.ObjectId(result_id)
260 self._get_one(query=query)
262 @swagger.operation(nickname="updateTestResultById")
263 def put(self, result_id):
265 @description: update a single result by _id
266 @param body: fields to be updated
267 @type body: L{ResultUpdateRequest}
270 @return 200: update success
271 @raise 404: result not exist
272 @raise 403: nothing to update
274 query = {'_id': objectid.ObjectId(result_id)}
276 self._update(query=query, db_keys=db_keys)