def revisions(request):
"""Dashboard for reviewing revisions"""
if request.is_ajax():
username = request.GET.get('user', None)
locale = request.GET.get('locale', None)
topic = request.GET.get('topic', None)
display_start = int(request.GET.get('iDisplayStart', 0))
revisions = (Revision.objects.select_related('creator').all()
.order_by('-created'))
# apply filters, limits, and pages
if username:
revisions = (revisions
.filter(creator__username__istartswith=username))
if locale:
revisions = revisions.filter(document__locale=locale)
if topic:
revisions = revisions.filter(slug__icontains=topic)
total = revisions.count()
revisions = revisions[display_start:display_start + PAGE_SIZE]
# build the master JSON
revision_json = {
'iTotalRecords': total,
'iTotalDisplayRecords': total,
'aaData': []
}
for rev in revisions:
prev = rev.get_previous()
from_rev = str(prev.id if prev else rev.id)
doc_url = reverse('wiki.document', args=[rev.document.full_path], locale=rev.document.locale)
articleUrl = '<a href="%s" target="_blank">%s</a>' % (doc_url, jinja2.escape(rev.document.slug))
articleLocale = '<span class="dash-locale">%s</span>' % rev.document.locale
articleComment = '<span class="dashboard-comment">%s</span>' % format_comment(rev)
articleIsNew = '<span class="dashboard-new">New: </span>' if rev.based_on_id is None else ''
richTitle = articleIsNew + articleUrl + articleLocale + articleComment
revision_json['aaData'].append({
'id': rev.id,
'prev_id': from_rev,
'doc_url': doc_url,
'edit_url': reverse('wiki.edit_document', args=[rev.document.full_path], locale=rev.document.locale),
'compare_url': reverse('wiki.compare_revisions', args=[rev.document.full_path]) + '?from=%s&to=%s&raw=1' % (from_rev, str(rev.id)),
'revert_url': reverse('wiki.revert_document', args=[rev.document.full_path, rev.id]),
'history_url': reverse('wiki.document_revisions', args=[rev.document.full_path], locale=rev.document.locale),
'creator': '<a href="" class="creator">%s</a>' % jinja2.escape(rev.creator.username),
'title': rev.title,
'richTitle': richTitle,
'date': rev.created.strftime('%b %d, %y - %H:%M'),
'slug': rev.document.slug
})
result = json.dumps(revision_json)
return HttpResponse(result, mimetype='application/json')
return jingo.render(request, 'dashboards/revisions.html')
def revisions(request):
"""Dashboard for reviewing revisions"""
if request.is_ajax():
username = request.GET.get("user", None)
locale = request.GET.get("locale", None)
topic = request.GET.get("topic", None)
newusers = request.GET.get("newusers", None)
display_start = int(request.GET.get("iDisplayStart", 0))
revisions = Revision.objects.select_related("creator").order_by("-creator").defer("content")
# Build up a dict of the filter conditions, if any, then apply
# them all in one go.
query_kwargs = {}
if username:
query_kwargs["creator__username__istartswith"] = username
if locale:
query_kwargs["document__locale"] = locale
if topic:
query_kwargs["slug__icontains"] = topic
if newusers:
"""Users with the first edit not older than 7 days or
with fewer than 20 revisions at all"""
sql = """SELECT id, creator_id, MIN(created)
FROM wiki_revision
GROUP BY creator_id
HAVING COUNT(*) <= 20
OR MIN(created) >= DATE_SUB(NOW(), INTERVAL 7 DAY)"""
result = list(Revision.objects.raw(sql))
if result:
users = [u.creator_id for u in result]
query_kwargs["creator__id__in"] = users
else:
revisions = Revision.objects.none()
if query_kwargs:
revisions = revisions.filter(**query_kwargs)
total = Revision.objects.count()
else:
# If no filters, just do a straight count(). It's the same
# result, but much faster to compute.
total = Revision.objects.count()
if total >= display_start:
# Only bother with this if we're actually going to get
# some revisions from it. Otherwise it's a pointless but
# potentially complex query.
revisions = revisions[display_start : display_start + PAGE_SIZE]
# build the master JSON
revision_json = {"iTotalRecords": total, "iTotalDisplayRecords": total, "aaData": []}
for rev in revisions:
prev = rev.get_previous()
from_rev = str(prev.id if prev else rev.id)
doc_url = reverse("wiki.document", args=[rev.document.full_path], locale=rev.document.locale)
articleUrl = '<a href="%s" target="_blank">%s</a>' % (doc_url, jinja2.escape(rev.document.slug))
articleLocale = '<span class="dash-locale">%s</span>' % rev.document.locale
articleComment = '<span class="dashboard-comment">%s</span>' % format_comment(rev)
articleIsNew = ""
if rev.based_on_id is None and not rev.document.is_redirect:
articleIsNew = '<span class="dashboard-new">New: </span>'
richTitle = articleIsNew + articleUrl + articleLocale + articleComment
revision_json["aaData"].append(
{
"id": rev.id,
"prev_id": from_rev,
"doc_url": doc_url,
"edit_url": reverse(
"wiki.edit_document", args=[rev.document.full_path], locale=rev.document.locale
),
"compare_url": reverse(
"wiki.compare_revisions", args=[rev.document.full_path], locale=rev.document.locale
)
+ "?from=%s&to=%s&raw=1" % (from_rev, str(rev.id)),
"revert_url": reverse(
"wiki.revert_document", args=[rev.document.full_path, rev.id], locale=rev.document.locale
),
"history_url": reverse(
"wiki.document_revisions", args=[rev.document.full_path], locale=rev.document.locale
),
"creator": ('<a href="" class="creator">%s</a>' % jinja2.escape(rev.creator.username)),
"title": rev.title,
"richTitle": richTitle,
"date": rev.created.strftime("%b %d, %y - %H:%M"),
"slug": rev.document.slug,
"ban_link": ban_link(rev.creator, request.user),
}
)
result = json.dumps(revision_json)
return HttpResponse(result, mimetype="application/json")
return render(request, "dashboards/revisions.html")
def revisions(request):
"""Dashboard for reviewing revisions"""
if request.is_ajax():
username = request.GET.get('user', None)
locale = request.GET.get('locale', None)
topic = request.GET.get('topic', None)
newusers = request.GET.get('newusers', None)
display_start = int(request.GET.get('iDisplayStart', 0))
revisions = (Revision.objects.select_related('creator')
.order_by('-created')
.defer('content'))
# Build up a dict of the filter conditions, if any, then apply
# them all in one go.
query_kwargs = {}
if username:
query_kwargs['creator__username__istartswith'] = username
if locale:
query_kwargs['document__locale'] = locale
if topic:
query_kwargs['slug__icontains'] = topic
if newusers:
# Users with the first edit not older than 7 days or
# with fewer than 20 revisions at all
sql = """SELECT id, creator_id, MIN(created)
FROM wiki_revision
GROUP BY creator_id
HAVING COUNT(*) <= 20
OR MIN(created) >= DATE_SUB(NOW(), INTERVAL 7 DAY)"""
result = list(Revision.objects.raw(sql))
if result:
users = [u.creator_id for u in result]
query_kwargs['creator__id__in'] = users
else:
revisions = Revision.objects.none()
if query_kwargs:
revisions = revisions.filter(**query_kwargs)
total = revisions.count()
else:
# If no filters, just do a straight count(). It's the same
# result, but much faster to compute.
total = Revision.objects.count()
if total >= display_start:
# Only bother with this if we're actually going to get
# some revisions from it. Otherwise it's a pointless but
# potentially complex query.
revisions = revisions[display_start:display_start + PAGE_SIZE]
# build the master JSON
revision_json = {
'iTotalRecords': total,
'iTotalDisplayRecords': total,
'aaData': []
}
for rev in revisions:
prev = rev.get_previous()
from_rev = str(prev.id if prev else rev.id)
doc_url = reverse('wiki.document', args=[rev.document.full_path],
locale=rev.document.locale)
articleUrl = '<a href="%s" target="_blank">%s</a>' % (doc_url,
escape(rev.document.slug))
articleLocale = ('<span class="dash-locale">%s</span>'
% rev.document.locale)
articleComment = ('<span class="dashboard-comment">%s</span>'
% format_comment(rev))
articleIsNew = ''
if rev.based_on_id is None and not rev.document.is_redirect:
articleIsNew = '<span class="dashboard-new">New: </span>'
richTitle = (articleIsNew + articleUrl + articleLocale +
articleComment)
revision_json['aaData'].append({
'id': rev.id,
'prev_id': from_rev,
'doc_url': doc_url,
'edit_url': reverse('wiki.edit_document',
args=[rev.document.full_path], locale=rev.document.locale),
'compare_url': reverse('wiki.compare_revisions',
args=[rev.document.full_path], locale=rev.document.locale)
+ '?from=%s&to=%s&raw=1' % (from_rev, str(rev.id)),
'revert_url': reverse('wiki.revert_document',
args=[rev.document.full_path, rev.id],
locale=rev.document.locale),
'history_url': reverse('wiki.document_revisions',
args=[rev.document.full_path], locale=rev.document.locale),
'creator': ('<a href="" class="creator">%s</a>'
% escape(rev.creator.username)),
'title': rev.title,
'richTitle': richTitle,
'date': rev.created.strftime('%b %d, %y - %H:%M'),
'slug': rev.document.slug,
'ban_link': ban_link(rev.creator, request.user)
})
result = json.dumps(revision_json)
return HttpResponse(result, mimetype='application/json')
return render(request, 'dashboards/revisions.html')
def revisions(request):
"""Dashboard for reviewing revisions"""
if request.is_ajax():
username = request.GET.get('user', None)
locale = request.GET.get('locale', None)
topic = request.GET.get('topic', None)
newusers = request.GET.get('newusers', None)
display_start = int(request.GET.get('iDisplayStart', 0))
revisions = (Revision.objects.select_related('creator').all()
.order_by('-created'))
# apply filters, limits, and pages
if username:
revisions = (revisions
.filter(creator__username__istartswith=username))
if locale:
revisions = revisions.filter(document__locale=locale)
if topic:
revisions = revisions.filter(slug__icontains=topic)
if newusers:
"""Users with the first edit not older than 7 days or
with fewer than 20 revisions at all"""
sql = """SELECT id, creator_id, MIN(created)
FROM wiki_revision
GROUP BY creator_id
HAVING COUNT(*) <= 20
OR MIN(created) >= DATE_SUB(NOW(), INTERVAL 7 DAY)"""
result = list(Revision.objects.raw(sql))
if result:
users = [u.creator_id for u in result]
revisions = revisions.filter(creator__id__in=users)
else:
revisions = Revision.objects.none()
total = revisions.count()
revisions = revisions[display_start:display_start + PAGE_SIZE]
# build the master JSON
revision_json = {
'iTotalRecords': total,
'iTotalDisplayRecords': total,
'aaData': []
}
for rev in revisions:
prev = rev.get_previous()
from_rev = str(prev.id if prev else rev.id)
doc_url = reverse('wiki.document', args=[rev.document.full_path],
locale=rev.document.locale)
articleUrl = '<a href="%s" target="_blank">%s</a>' % (doc_url,
jinja2.escape(rev.document.slug))
articleLocale = ('<span class="dash-locale">%s</span>'
% rev.document.locale)
articleComment = ('<span class="dashboard-comment">%s</span>'
% format_comment(rev))
articleIsNew = ''
if rev.based_on_id is None and not rev.document.is_redirect:
articleIsNew = '<span class="dashboard-new">New: </span>'
richTitle = (articleIsNew + articleUrl + articleLocale +
articleComment)
revision_json['aaData'].append({
'id': rev.id,
'prev_id': from_rev,
'doc_url': doc_url,
'edit_url': reverse('wiki.edit_document',
args=[rev.document.full_path], locale=rev.document.locale),
'compare_url': reverse('wiki.compare_revisions',
args=[rev.document.full_path], locale=rev.document.locale)
+ '?from=%s&to=%s&raw=1' % (from_rev, str(rev.id)),
'revert_url': reverse('wiki.revert_document',
args=[rev.document.full_path, rev.id],
locale=rev.document.locale),
'history_url': reverse('wiki.document_revisions',
args=[rev.document.full_path], locale=rev.document.locale),
'creator': ('<a href="" class="creator">%s</a>'
% jinja2.escape(rev.creator.username)),
'title': rev.title,
'richTitle': richTitle,
'date': rev.created.strftime('%b %d, %y - %H:%M'),
'slug': rev.document.slug
})
result = json.dumps(revision_json)
return HttpResponse(result, mimetype='application/json')
return render(request, 'dashboards/revisions.html')
def revisions(request):
"""Dashboard for reviewing revisions"""
if request.is_ajax():
username = request.GET.get('user', None)
locale = request.GET.get('locale', None)
topic = request.GET.get('topic', None)
newusers = request.GET.get('newusers', None)
display_start = int(request.GET.get('iDisplayStart', 0))
revisions = (Revision.objects.select_related('creator').all().order_by(
'-created'))
# apply filters, limits, and pages
if username:
revisions = (revisions.filter(
creator__username__istartswith=username))
if locale:
revisions = revisions.filter(document__locale=locale)
if topic:
revisions = revisions.filter(slug__icontains=topic)
if newusers:
"""Users with the first edit not older than 7 days or
with fewer than 20 revisions at all"""
sql = """SELECT id, creator_id, MIN(created)
FROM wiki_revision
GROUP BY creator_id
HAVING COUNT(*) <= 20
OR MIN(created) >= DATE_SUB(NOW(), INTERVAL 7 DAY)"""
result = list(Revision.objects.raw(sql))
if result:
users = [u.creator_id for u in result]
revisions = revisions.filter(creator__id__in=users)
else:
revisions = Revision.objects.none()
total = revisions.count()
revisions = revisions[display_start:display_start + PAGE_SIZE]
# build the master JSON
revision_json = {
'iTotalRecords': total,
'iTotalDisplayRecords': total,
'aaData': []
}
for rev in revisions:
prev = rev.get_previous()
from_rev = str(prev.id if prev else rev.id)
doc_url = reverse('wiki.document',
args=[rev.document.full_path],
locale=rev.document.locale)
articleUrl = '<a href="%s" target="_blank">%s</a>' % (
doc_url, jinja2.escape(rev.document.slug))
articleLocale = ('<span class="dash-locale">%s</span>' %
rev.document.locale)
articleComment = ('<span class="dashboard-comment">%s</span>' %
format_comment(rev))
articleIsNew = ''
if rev.based_on_id is None and not rev.document.is_redirect:
articleIsNew = '<span class="dashboard-new">New: </span>'
richTitle = (articleIsNew + articleUrl + articleLocale +
articleComment)
revision_json['aaData'].append({
'id':
rev.id,
'prev_id':
from_rev,
'doc_url':
doc_url,
'edit_url':
reverse('wiki.edit_document',
args=[rev.document.full_path],
locale=rev.document.locale),
'compare_url':
reverse('wiki.compare_revisions',
args=[rev.document.full_path],
locale=rev.document.locale) + '?from=%s&to=%s&raw=1' %
(from_rev, str(rev.id)),
'revert_url':
reverse('wiki.revert_document',
args=[rev.document.full_path, rev.id],
locale=rev.document.locale),
'history_url':
reverse('wiki.document_revisions',
args=[rev.document.full_path],
locale=rev.document.locale),
'creator': ('<a href="" class="creator">%s</a>' %
jinja2.escape(rev.creator.username)),
'title':
rev.title,
'richTitle':
richTitle,
'date':
rev.created.strftime('%b %d, %y - %H:%M'),
'slug':
rev.document.slug
})
result = json.dumps(revision_json)
return HttpResponse(result, mimetype='application/json')
return jingo.render(request, 'dashboards/revisions.html')
def revisions(request):
"""Dashboard for reviewing revisions"""
if request.is_ajax():
username = request.GET.get('user', None)
locale = request.GET.get('locale', None)
topic = request.GET.get('topic', None)
newusers = request.GET.get('newusers', None)
display_start = int(request.GET.get('iDisplayStart', 0))
revisions = (Revision.objects.select_related('creator').order_by(
'-created').defer('content'))
# Build up a dict of the filter conditions, if any, then apply
# them all in one go.
query_kwargs = {}
if username:
query_kwargs['creator__username__istartswith'] = username
if locale:
query_kwargs['document__locale'] = locale
if topic:
query_kwargs['slug__icontains'] = topic
if newusers:
# Users with the first edit not older than 7 days or
# with fewer than 20 revisions at all
sql = """SELECT id, creator_id, MIN(created)
FROM wiki_revision
GROUP BY creator_id
HAVING COUNT(*) <= 20
OR MIN(created) >= DATE_SUB(NOW(), INTERVAL 7 DAY)"""
result = list(Revision.objects.raw(sql))
if result:
users = [u.creator_id for u in result]
query_kwargs['creator__id__in'] = users
else:
revisions = Revision.objects.none()
if query_kwargs:
revisions = revisions.filter(**query_kwargs)
total = revisions.count()
else:
# If no filters, just do a straight count(). It's the same
# result, but much faster to compute.
total = Revision.objects.count()
if total >= display_start:
# Only bother with this if we're actually going to get
# some revisions from it. Otherwise it's a pointless but
# potentially complex query.
revisions = revisions[display_start:display_start + PAGE_SIZE]
# build the master JSON
revision_json = {
'iTotalRecords': total,
'iTotalDisplayRecords': total,
'aaData': []
}
for rev in revisions:
prev = rev.get_previous()
from_rev = str(prev.id if prev else rev.id)
doc_url = reverse('wiki.document',
args=[rev.document.full_path],
locale=rev.document.locale)
articleUrl = '<a href="%s" target="_blank">%s</a>' % (
doc_url, escape(rev.document.slug))
articleLocale = ('<span class="dash-locale">%s</span>' %
rev.document.locale)
articleComment = ('<span class="dashboard-comment">%s</span>' %
format_comment(rev))
articleIsNew = ''
if rev.based_on_id is None and not rev.document.is_redirect:
articleIsNew = '<span class="dashboard-new">New: </span>'
richTitle = (articleIsNew + articleUrl + articleLocale +
articleComment)
revision_json['aaData'].append({
'id':
rev.id,
'prev_id':
from_rev,
'doc_url':
doc_url,
'edit_url':
reverse('wiki.edit_document',
args=[rev.document.full_path],
locale=rev.document.locale),
'compare_url':
reverse('wiki.compare_revisions',
args=[rev.document.full_path],
locale=rev.document.locale) + '?from=%s&to=%s&raw=1' %
(from_rev, str(rev.id)),
'revert_url':
reverse('wiki.revert_document',
args=[rev.document.full_path, rev.id],
locale=rev.document.locale),
'history_url':
reverse('wiki.document_revisions',
args=[rev.document.full_path],
locale=rev.document.locale),
'creator': ('<a href="" class="creator">%s</a>' %
escape(rev.creator.username)),
'title':
rev.title,
'richTitle':
richTitle,
'date':
rev.created.strftime('%b %d, %y - %H:%M'),
'slug':
rev.document.slug,
'ban_link':
ban_link(rev.creator, request.user)
})
result = json.dumps(revision_json)
return HttpResponse(result, mimetype='application/json')
return render(request, 'dashboards/revisions.html')
