def nb_uploaders_indicator(self, name):
"""FDC indicator with count of uploaders.
This indicator is filled with values during q1, q2, q3, q4 and total.
Args:
name (str): name of the fdc_indicator
Returns:
fdc_indicator with the number of file for each quarter and total over the whole period
"""
if self.nb_uploaders is None:
self.nb_uploaders = [
self.quarters[i].get_nb_uploaders() for i in range(4)
]
cat = self.category.replace(" ", "_")
query = wmflabs_queries.count_uploaders_in_category()
self.cursor.execute(query, (cat, self.fdc_round.full_period()['start'],
self.fdc_round.full_period()['end']))
total = long(self.cursor.fetchone()[0])
return fdc_indicator(name,
q1=self.nb_uploaders[0],
q2=self.nb_uploaders[1],
q3=self.nb_uploaders[2],
q4=self.nb_uploaders[3],
value=total)
def nb_uploaders_indicator(self, name):
"""FDC indicator with count of uploaders.
This indicator is filled with values during q1, q2, q3, q4 and total.
Args:
name (str): name of the fdc_indicator
Returns:
fdc_indicator with the number of file for each quarter and total over the whole period
"""
if self.nb_uploaders is None:
self.nb_uploaders = [
self.quarters[i].get_nb_uploaders() for i in range(4)]
cat = self.category.replace(" ", "_")
query = wmflabs_queries.count_uploaders_in_category()
self.cursor.execute(query, (cat, self.fdc_round.full_period()['start'], self.fdc_round.full_period()['end']))
total = long(self.cursor.fetchone()[0])
return fdc_indicator(name,
q1=self.nb_uploaders[0],
q2=self.nb_uploaders[1],
q3=self.nb_uploaders[2],
q4=self.nb_uploaders[3],
value=total)
def get_nb_uploaders(self):
"""Amount of uploaders on the period."""
query = wmflabs_queries.count_uploaders_in_category(self.catsql, self.timestamp1, self.timestamp2)
self.cursor.execute(query)
return long(self.cursor.fetchone()[0])
def get_nb_uploaders(self):
"""Amount of uploaders on the period."""
query = wmflabs_queries.count_uploaders_in_category()
self.cursor.execute(query, (self.catsql, self.timestamp1, self.timestamp2))
return long(self.cursor.fetchone()[0])
