def unique_cell_histogram(self, ago=1): day, max_day = daily_task_days(ago) try: with self.db_session() as session: value = histogram_query(session, Cell, day, max_day) add_stat(session, 'unique_cell', day, value) session.commit() return 1 except Exception as exc: # pragma: no cover self.heka_client.raven('error') raise self.retry(exc=exc)
def wifi_histogram(self, ago=1): day, max_day = daily_task_days(ago) try: with self.db_session() as session: value = histogram_query(session, WifiMeasure, day, max_day) add_stat(session, 'wifi', day, value) session.commit() return 1 except IntegrityError as exc: logger.exception('error') return 0 except Exception as exc: # pragma: no cover raise self.retry(exc=exc)
def wifi_histogram(self, ago=1): day, max_day = daily_task_days(ago) try: with self.db_session() as session: value = histogram_query(session, WifiMeasure, day, max_day) add_stat(session, 'wifi', day, value) session.commit() return 1 except IntegrityError as exc: self.heka_client.raven('error') return 0 except Exception as exc: # pragma: no cover raise self.retry(exc=exc)
def wifi_histogram(ago=1): day, max_day = daily_task_days(ago) try: with wifi_histogram.db_session() as session: value = histogram_query(session, WifiMeasure, max_day) session.add(make_stat('wifi', day, value)) session.commit() return 1 except IntegrityError as exc: # TODO log error return 0 except Exception as exc: # pragma: no cover raise wifi_histogram.retry(exc=exc)
def wifi_histogram(self, ago=1): day, max_day = daily_task_days(ago) try: with self.db_session() as session: value = histogram_query(session, WifiMeasure, day, max_day) add_stat(session, "wifi", day, value) session.commit() return 1 except IntegrityError as exc: self.heka_client.raven("error") return 0 except Exception as exc: # pragma: no cover raise self.retry(exc=exc)
def unique_cell_histogram(self, ago=1): day, max_day = daily_task_days(ago) try: with self.db_session() as session: value = histogram_query(session, Cell, max_day) session.add(make_stat('unique_cell', day, value)) session.commit() return 1 except IntegrityError as exc: logger.exception('error') return 0 except Exception as exc: # pragma: no cover raise self.retry(exc=exc)
def unique_wifi_histogram(ago=1): day, max_day = daily_task_days(ago) try: with unique_wifi_histogram.db_session() as session: query = session.query(func.count(distinct(WifiMeasure.key))) query = query.filter(WifiMeasure.created < max_day) value = query.first()[0] session.add(make_stat('unique_wifi', day, value)) session.commit() return 1 except IntegrityError as exc: # TODO log error return 0 except Exception as exc: # pragma: no cover raise unique_wifi_histogram.retry(exc=exc)
def unique_cell_histogram(ago=1): day, max_day = daily_task_days(ago) try: with unique_cell_histogram.db_session() as session: query = session.query( CellMeasure.radio, CellMeasure.mcc, CellMeasure.mnc, CellMeasure.lac, CellMeasure.cid).\ group_by(CellMeasure.radio, CellMeasure.mcc, CellMeasure.mnc, CellMeasure.lac, CellMeasure.cid) query = query.filter(CellMeasure.created < max_day) value = query.count() session.add(make_stat('unique_cell', day, value)) session.commit() return 1 except IntegrityError as exc: # TODO log error return 0 except Exception as exc: # pragma: no cover raise unique_cell_histogram.retry(exc=exc)