def get_context_data(self, *args, **kwargs):
context = super(All_projects_view, self).get_context_data(**kwargs)
request_dict = self.request.GET.dict()
hashtags = hashtag_queryset(request_dict)
# Context data for stats box
context = get_hashtags_context(self.request, hashtags, context)
return context
def time_csv(request):
request_dict = request.GET.dict()
response = HttpResponse(content_type='text/csv')
response[
'Content-Disposition'] = 'attachment; filename="hashtags_dates.csv"'
hashtags = hashtag_queryset(request_dict)
earliest_date = hashtags[len(hashtags) - 1].timestamp.date()
latest_date = hashtags.first().timestamp.date()
time_dic = {}
qs = hashtags.annotate(day=TruncDay('timestamp')).values('day').annotate(
edits=Count('rc_id')).order_by()
for item in qs:
time_dic[item['day'].date()] = item['edits']
writer = csv.writer(response)
writer.writerow([
# Translators: Date on which edit is made.
_('Date'),
# Translators: Edits done on wikimedia projects.
_('Edits')
])
while earliest_date <= latest_date:
if earliest_date in time_dic:
temp = time_dic.pop(earliest_date)
writer.writerow([earliest_date.strftime("%Y-%m-%d"), temp])
else:
writer.writerow([earliest_date.strftime("%Y-%m-%d"), 0])
earliest_date = earliest_date + timedelta(days=1)
return response
def get(self, request):
request_dict = request.GET.dict()
hashtags = hashtag_queryset(request_dict)
context = {'form': self.form_class(request.GET)}
context['hashtags'] = hashtags
if hashtags:
context = get_hashtags_context(request, hashtags, context)
return render(request, self.template_name, context=context)
def get_paginate_by(self, queryset):
request_dict = self.request.GET.dict()
hashtags = hashtag_queryset(request_dict)
users_count = hashtags.values('username').distinct().count()
# Paginate such that there are atmost 10 pages
if users_count > 300:
return math.ceil(users_count / 10)
else:
return 30
def top_user_statistics_data(request):
# Returns top 10 projects in decreasing order of number of edits.
request_dict = request.GET.dict()
usernames = []
edits_per_user = []
hashtags = hashtag_queryset(request_dict)
qs = results_count(hashtags, 'username', '-edits')[:10]
for item in qs:
usernames.append(item['username'])
edits_per_user.append(item['edits'])
data = {'usernames': usernames, 'edits_per_user': edits_per_user}
return JsonResponse(data)
def top_project_statistics_data(request):
# Returns top 10 projects in decreasing order of number of edits.
# We will need this info as x-axis and y-axis when rendering chart.
request_dict = request.GET.dict()
projects = []
edits_per_project = []
hashtags = hashtag_queryset(request_dict)
qs = results_count(hashtags, 'domain', '-edits')[:10]
for item in qs:
projects.append(item['domain'])
edits_per_project.append(item['edits'])
data = {'projects': projects, 'edits_per_project': edits_per_project}
return JsonResponse(data)
def projects_csv(request):
request_dict = request.GET.dict()
response = HttpResponse(content_type='text/csv')
response['Content-Disposition'] = 'attachment; filename="hashtags_projects.csv"'
hashtags = hashtag_queryset(request_dict)
projects_qs = results_count(hashtags, 'domain', '-edits')
writer = csv.writer(response)
writer.writerow([
# Translators: Wikimedia projects
_('Project'),
# Translators: Edits done on wikimedia projects.
_('Edits')])
for project in projects_qs:
writer.writerow([project['domain'], project['edits']])
return response
def users_csv(request):
request_dict = request.GET.dict()
response = HttpResponse(content_type='text/csv')
response['Content-Disposition'] = 'attachment; filename="hashtags_users.csv"'
hashtags = hashtag_queryset(request_dict)
users_qs = results_count(hashtags, 'username', 'username')
writer = csv.writer(response)
writer.writerow([
# Translators: User of the hashtag
_('User'),
# Translators: Edits done on wikimedia projects.
_('Edits')])
for user in users_qs:
writer.writerow([user['username'], user['edits']])
return response
def time_statistics_data(request):
request_dict = request.GET.dict()
edits_array = []
time_array = []
hashtags = hashtag_queryset(request_dict)
earliest_date = hashtags[len(hashtags) - 1].timestamp.date()
latest_date = hashtags.first().timestamp.date()
date_range = latest_date - earliest_date
# key value pairs of date unit and number of edits
time_dic = {}
# Split by days
if date_range.days < 90:
qs = hashtags.annotate(
day=TruncDay('timestamp')).values('day').annotate(
edits=Count('rc_id')).order_by()
for item in qs:
time_dic[item['day'].date()] = item['edits']
while earliest_date <= latest_date:
time_array.append(earliest_date.strftime("%Y-%m-%d"))
#If there are edits on a day, append number of edits else append 0
if earliest_date in time_dic:
temp = time_dic.pop(earliest_date)
edits_array.append(temp)
else:
edits_array.append(0)
earliest_date = earliest_date + timedelta(days=1)
# Split by months
elif date_range.days >= 90 and date_range.days < 1095:
qs = hashtags.annotate(
month=TruncMonth('timestamp')).values('month').annotate(
edits=Count('rc_id')).order_by()
for item in qs:
time_dic[item['month'].date()] = item['edits']
earliest_date = earliest_date.replace(day=1)
latest_date = latest_date.replace(day=1)
while earliest_date <= latest_date:
time_array.append(earliest_date.strftime("%b-%Y"))
if earliest_date in time_dic:
temp = time_dic.pop(earliest_date)
edits_array.append(temp)
else:
edits_array.append(0)
earliest_date = earliest_date + relativedelta(months=+1)
# Split by years
else:
qs = hashtags.annotate(
year=TruncYear('timestamp')).values('year').annotate(
edits=Count('rc_id')).order_by()
for item in qs:
time_dic[item['year'].date()] = item['edits']
earliest_date = earliest_date.replace(day=1, month=1)
latest_date = latest_date.replace(day=1, month=1)
while earliest_date <= latest_date:
time_array.append(earliest_date.strftime("%Y"))
if earliest_date in time_dic:
temp = time_dic.pop(earliest_date)
edits_array.append(temp)
else:
edits_array.append(0)
earliest_date = earliest_date + relativedelta(years=+1)
data = {'edits_array': edits_array, 'time_array': time_array}
return JsonResponse(data)
def get_queryset(self):
request_dict = self.request.GET.dict()
hashtags = hashtag_queryset(request_dict)
projects_qs = results_count(hashtags, 'domain', '-edits')
return projects_qs
def get_queryset(self):
request_dict = self.request.GET.dict()
hashtags = hashtag_queryset(request_dict)
users_qs = results_count(hashtags, 'username', 'username')
return users_qs
