Add new project status column to accepted students csv export.
authorPawel Solyga <Pawel.Solyga@gmail.com>
Tue, 14 Jul 2009 15:17:10 +0200
changeset 2642 1bb33f56a3f4
parent 2641 7ad3af6d30bd
child 2643 222be0eb4aab
Add new project status column to accepted students csv export.
scripts/stats.py
--- a/scripts/stats.py	Tue Jul 14 13:10:56 2009 +0200
+++ b/scripts/stats.py	Tue Jul 14 15:17:10 2009 +0200
@@ -425,13 +425,16 @@
   print "Fetched %d Student Projects." % student_projects_amount
   print "Fetching Student entities from Student Projects."
   accepted_students = {}
-  student_organization = {}
+  student_extra_data = {}
   counter = 0
+  
   for sp_key in student_projects.keys():
     key = student_projects[sp_key].student.key().name()
     accepted_students[key] = student_projects[sp_key].student
     org_name = student_projects[sp_key].scope.name
-    student_organization[key] = org_name
+    student_extra_data[key] = {}
+    student_extra_data[key]['organization'] = org_name
+    student_extra_data[key]['project_status'] = student_projects[sp_key].status
     counter += 1
     print str(counter) + '/' + str(student_projects_amount) + ' ' + key + ' (' + org_name + ')'
   print "All Student entities fetched."
@@ -446,11 +449,14 @@
   print "Preparing Students data for export."
   students_data = [accepted_students[i].toDict(students_key_order) for i in accepted_students.keys()]
   
-  print "Adding organization name to Students data."
+  print "Adding organization name and project status to Students data."
   for student in students_data:
-    student['organization'] = student_organization[program_key_name + '/' + student['link_id']]
+    extra_data = student_extra_data[program_key_name + '/' + student['link_id']]
+    student['organization'] = extra_data['organization']
+    student['project_status'] = extra_data['project_status']
   
   students_key_order.append('organization')
+  students_key_order.append('project_status')
   
   saveDataToCSV(csv_filename, students_data, students_key_order)
   print "Accepted Students exported to %s file." % csv_filename