def get_results(self): results = [] total_db_documents = Document.objects.only('pk',).count() results.extend([ _('Documents in database: %d') % total_db_documents, ]) try: total_storage_documents, storage_used_space = storage_count() results.append(_('Documents in storage: %d') % total_storage_documents) results.append(_('Space used in storage: %(base_2)s (base 2), %(base_10)s (base 10), %(bytes)d bytes') % { 'base_2': pretty_size(storage_used_space), 'base_10': pretty_size_10(storage_used_space), 'bytes': storage_used_space }) except NotImplementedError: pass results.extend([ _('Document pages in database: %d') % DocumentPage.objects.only('pk',).count(), ]) return results
def get_statistics(): total_db_documents = Document.objects.only('pk',).count() paragraphs = [ _(u'Document types: %d') % DocumentType.objects.count(), _(u'Documents in database: %d') % total_db_documents, ] try: total_storage_documents, storage_used_space = storage_count() paragraphs.append(_(u'Documents in storage: %d') % total_storage_documents) paragraphs.append(_(u'Space used in storage: %(base_2)s (base 2), %(base_10)s (base 10), %(bytes)d bytes') % { 'base_2': pretty_size(storage_used_space), 'base_10': pretty_size_10(storage_used_space), 'bytes': storage_used_space }) except NotImplementedError: pass paragraphs.extend( [ _(u'Document pages in database: %d') % DocumentPage.objects.only('pk',).count(), _(u'Minimum amount of pages per document: %(page_count__min)d') % DocumentVersion.objects.annotate(page_count=Count('documentpage')).aggregate(Min('page_count')), _(u'Maximum amount of pages per document: %(page_count__max)d') % DocumentVersion.objects.annotate(page_count=Count('documentpage')).aggregate(Max('page_count')), _(u'Average amount of pages per document: %(page_count__avg)f') % DocumentVersion.objects.annotate(page_count=Count('documentpage')).aggregate(Avg('page_count')), ] ) #[(day_count['date_added'].strftime('%Y-%m-%d'), day_count['id__count']) for day_count in Document.objects.values('date_added').annotate(Count("id"))] return { 'title': _(u'Document statistics'), 'paragraphs': paragraphs }
def get_statistics(): total_db_documents = Document.objects.only('pk',).count() paragraphs = [ _(u'Document types: %d') % DocumentType.objects.count(), _(u'Documents in database: %d') % total_db_documents, ] try: total_storage_documents, storage_used_space = storage_count() paragraphs.append(_(u'Documents in storage: %d') % total_storage_documents) paragraphs.append(_(u'Space used in storage: %(base_2)s (base 2), %(base_10)s (base 10), %(bytes)d bytes') % { 'base_2': pretty_size(storage_used_space), 'base_10': pretty_size_10(storage_used_space), 'bytes': storage_used_space }) except NotImplementedError: pass document_stats = DocumentVersion.objects.annotate(page_count=Count('documentpage')).aggregate(Min('page_count'), Max('page_count'), Avg('page_count')) paragraphs.extend( [ _(u'Document pages in database: %d') % DocumentPage.objects.only('pk',).count(), _(u'Minimum amount of pages per document: %d') % (document_stats['page_count__max'] or 0), _(u'Maximum amount of pages per document: %d') % (document_stats['page_count__max'] or 0), _(u'Average amount of pages per document: %f') % (document_stats['page_count__avg'] or 0), ] ) return { 'title': _(u'Document statistics'), 'paragraphs': paragraphs }
def get_statistics(): total_db_documents = Document.objects.only('pk', ).count() paragraphs = [ _(u'Document types: %d') % DocumentType.objects.count(), _(u'Documents in database: %d') % total_db_documents, ] try: total_storage_documents, storage_used_space = storage_count() paragraphs.append( _(u'Documents in storage: %d') % total_storage_documents) paragraphs.append( _(u'Space used in storage: %(base_2)s (base 2), %(base_10)s (base 10), %(bytes)d bytes' ) % { 'base_2': pretty_size(storage_used_space), 'base_10': pretty_size_10(storage_used_space), 'bytes': storage_used_space }) except NotImplementedError: pass document_stats = DocumentVersion.objects.annotate( page_count=Count('documentpage')).aggregate(Min('page_count'), Max('page_count'), Avg('page_count')) paragraphs.extend([ _(u'Document pages in database: %d') % DocumentPage.objects.only('pk', ).count(), _(u'Minimum amount of pages per document: %d') % (document_stats['page_count__min'] or 0), _(u'Maximum amount of pages per document: %d') % (document_stats['page_count__max'] or 0), _(u'Average amount of pages per document: %f') % (document_stats['page_count__avg'] or 0), ]) return {'title': _(u'Document statistics'), 'paragraphs': paragraphs}
def get_statistics(): total_db_documents = Document.objects.only('pk', ).count() paragraphs = [ _(u'Document types: %d') % DocumentType.objects.count(), _(u'Documents in database: %d') % total_db_documents, ] try: total_storage_documents, storage_used_space = storage_count() paragraphs.append( _(u'Documents in storage: %d') % total_storage_documents) paragraphs.append( _(u'Space used in storage: %(base_2)s (base 2), %(base_10)s (base 10), %(bytes)d bytes' ) % { 'base_2': pretty_size(storage_used_space), 'base_10': pretty_size_10(storage_used_space), 'bytes': storage_used_space }) except NotImplementedError: pass paragraphs.extend([ _(u'Document pages in database: %d') % DocumentPage.objects.only('pk', ).count(), _(u'Minimum amount of pages per document: %(page_count__min)d') % DocumentVersion.objects.annotate( page_count=Count('documentpage')).aggregate(Min('page_count')), _(u'Maximum amount of pages per document: %(page_count__max)d') % DocumentVersion.objects.annotate( page_count=Count('documentpage')).aggregate(Max('page_count')), _(u'Average amount of pages per document: %(page_count__avg)f') % DocumentVersion.objects.annotate( page_count=Count('documentpage')).aggregate(Avg('page_count')), ]) #[(day_count['date_added'].strftime('%Y-%m-%d'), day_count['id__count']) for day_count in Document.objects.values('date_added').annotate(Count("id"))] return {'title': _(u'Document statistics'), 'paragraphs': paragraphs}
def get_statistics(): total_db_documents = Document.objects.only("pk").count() paragraphs = [ _(u"Document types: %d") % DocumentType.objects.count(), _(u"Documents in database: %d") % total_db_documents, ] try: total_storage_documents, storage_used_space = storage_count() paragraphs.append(_(u"Documents in storage: %d") % total_storage_documents) paragraphs.append( _(u"Space used in storage: %(base_2)s (base 2), %(base_10)s (base 10), %(bytes)d bytes") % { "base_2": pretty_size(storage_used_space), "base_10": pretty_size_10(storage_used_space), "bytes": storage_used_space, } ) except NotImplementedError: pass paragraphs.extend( [ _(u"Document pages in database: %d") % DocumentPage.objects.only("pk").count(), _(u"Minimum amount of pages per document: %(page_count__min)d") % DocumentVersion.objects.annotate(page_count=Count("documentpage")).aggregate(Min("page_count")), _(u"Maximum amount of pages per document: %(page_count__max)d") % DocumentVersion.objects.annotate(page_count=Count("documentpage")).aggregate(Max("page_count")), _(u"Average amount of pages per document: %(page_count__avg)f") % DocumentVersion.objects.annotate(page_count=Count("documentpage")).aggregate(Avg("page_count")), ] ) # [(day_count['date_added'].strftime('%Y-%m-%d'), day_count['id__count']) for day_count in Document.objects.values('date_added').annotate(Count("id"))] return {"title": _(u"Document statistics"), "paragraphs": paragraphs}