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)
