def run()

in api/pages/mail/timeseries.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
    
    which = 'committer_email'
    role = 'committer'
    if indata.get('author', False):
        which = 'author_email'
        role = 'author'
    
    interval = indata.get('interval', 'month')
    
    
    ####################################################################
    ####################################################################
    dOrg = session.user['defaultOrganisation'] or "apache"
    query = {
                'query': {
                    'bool': {
                        'must': [
                            {'range':
                                {
                                    'date': {
                                        'from': time.strftime("%Y/%m/%d 00:00:00", time.gmtime(dateFrom)),
                                        'to': time.strftime("%Y/%m/%d 23:59:59", 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}})
    if indata.get('email'):
        query['query']['bool']['should'] = [{'term': {'sender': indata.get('email')}}]
        query['query']['bool']['minimum_should_match'] = 1
    
    # Get number of committers, this period
    query['aggs'] = {
            'timeseries': {
                'date_histogram': {
                    'field': 'date',
                    'interval': interval
                },
                'aggs': {
                    'email': {
                        'sum': {
                            'field': 'emails'
                        }
                    },
                    'topics': {
                        'sum': {
                            'field': 'topics'
                        }
                    },
                    'authors': {
                        'sum': {
                            'field': 'authors'
                        }
                    }
                }
            }
        }
    res = session.DB.ES.search(
            index=session.DB.dbname,
            doc_type="mailstats",
            size = 0,
            body = query
        )
    
    timeseries = []
    for bucket in res['aggregations']['timeseries']['buckets']:
        ts = int(bucket['key'] / 1000)
        timeseries.append({
            'date': ts,
            'emails': bucket['email']['value'],
            'topics': bucket['topics']['value'],
            'authors': bucket['authors']['value']
        })
    
    JSON_OUT = {
        'widgetType': {
            'chartType': 'bar'  # Recommendation for the UI
        },
        'timeseries': timeseries,
        'interval': interval,
        'okay': True,
        'responseTime': time.time() - now
    }
    yield json.dumps(JSON_OUT)