+def counters(request):
+ form = forms.SearchForm()
+
+ books = models.Book.objects.count()
+ books_nonempty = models.Book.objects.exclude(html_file='').count()
+ books_empty = models.Book.objects.filter(html_file='').count()
+ books_root = models.Book.objects.filter(parent=None).count()
+
+ media = models.BookMedia.objects.count()
+ media_types = models.BookMedia.objects.values('type').\
+ annotate(count=Count('type')).\
+ order_by('type')
+ for mt in media_types:
+ size = 0
+ deprecated = missing_project = 0
+ for b in models.BookMedia.objects.filter(type=mt['type']):
+ size += b.file.size
+ if b.type in ('mp3', 'ogg'):
+ if not b.source_sha1:
+ deprecated += 1
+ if not 'project' in b.get_extra_info_value():
+ missing_project += 1
+ mt['size'] = size
+ mt['deprecated'] = deprecated
+ mt['missing_project'] = missing_project
+
+ return render_to_response('catalogue/counters.html',
+ locals(), context_instance=RequestContext(request))
+
+