Skip to content

Export reviews csv

hypha.apply.review.management.commands.export_reviews_csv

Command

Bases: BaseCommand

help class-attribute instance-attribute 

help = 'Export reviews stats to a csv file..'

handle 

handle(*args, **options)
Source code in hypha/apply/review/management/commands/export_reviews_csv.py 
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
def handle(self, *args, **options):
    with open("export_reviews.csv", "w", newline="") as csvfile:
        writer = csv.writer(csvfile, quoting=csv.QUOTE_ALL)
        writer.writerow(
            [
                "Review author",
                "Reviewer type",
                "Review date",
                "Submission",
                "Submission date",
                "Round/Lab/Fellowship",
            ]
        )
        for review in Review.objects.submitted():
            if review.submission.round:
                submission_type = review.submission.round
            else:
                submission_type = review.submission.page

            if review.author.reviewer.is_apply_staff:
                reviewer_type = "Staff"
            elif review.author.reviewer.is_reviewer:
                reviewer_type = "Reviewer"
            elif review.author.reviewer.is_partner:
                reviewer_type = "Partner"
            elif review.author.reviewer.is_community_reviewer:
                reviewer_type = "Community"

            writer.writerow(
                [
                    review.author,
                    reviewer_type,
                    review.created_at.strftime("%Y-%m-%d"),
                    review.submission.title,
                    review.submission.submit_time.strftime("%Y-%m-%d"),
                    submission_type,
                ]
            )