in api/pages/ci/top-buildcount.py [0:0]
def run(API, environ, indata, session):
# We need to be logged in for this!
if not session.user:
raise API.exception(403, "You must be logged in to use this API endpoint! %s")
now = time.time()
# First, fetch the view if we have such a thing enabled
viewList = []
if indata.get('view'):
viewList = session.getView(indata.get('view'))
if indata.get('subfilter'):
viewList = session.subFilter(indata.get('subfilter'), view = viewList)
dateTo = indata.get('to', int(time.time()))
dateFrom = indata.get('from', dateTo - (86400*30*6)) # Default to a 6 month span
####################################################################
####################################################################
dOrg = session.user['defaultOrganisation'] or "apache"
query = {
'query': {
'bool': {
'must': [
{'range':
{
'date': {
'from': time.strftime("%Y/%m/%d %H:%M:%S", time.gmtime(dateFrom)),
'to': time.strftime("%Y/%m/%d %H:%M:%S", time.gmtime(dateTo))
}
}
},
{
'term': {
'organisation': dOrg
}
}
]
}
}
}
# Source-specific or view-specific??
if indata.get('source'):
query['query']['bool']['must'].append({'term': {'sourceID': indata.get('source')}})
elif viewList:
query['query']['bool']['must'].append({'terms': {'sourceID': viewList}})
query['aggs'] = {
'by_job': {
'terms': {
'field': 'jobURL.keyword',
'size': 5000,
},
'aggs': {
'duration': {
'sum': {
'field': 'duration'
}
},
'ci': {
'terms': {
'field': 'ci.keyword',
'size': 1
}
},
'name': {
'terms': {
'field': 'job.keyword',
'size': 1
}
}
}
}
}
res = session.DB.ES.search(
index=session.DB.dbname,
doc_type="ci_build",
size = 0,
body = query
)
jobs = []
for doc in res['aggregations']['by_job']['buckets']:
job = doc['key']
builds = doc['doc_count']
duration = doc['duration']['value']
ci = doc['ci']['buckets'][0]['key']
jobname = doc['name']['buckets'][0]['key']
jobs.append([builds, duration, jobname, ci])
topjobs = sorted(jobs, key = lambda x: int(x[0]), reverse = True)
tophash = {}
for v in topjobs:
tophash["%s (%s)" % (v[2], v[3])] = v[0]
JSON_OUT = {
'counts': tophash,
'okay': True,
'responseTime': time.time() - now,
}
yield json.dumps(JSON_OUT)