Changeset 3602 for WAeUP_SRP/base

Timestamp:

5 Aug 2008, 20:03:27 (16 years ago)

Author:

Henrik Bettermann

Message:

first tools for transcripts (untested)

File:

• WAeUP_SRP/base/WAeUPTables.py (modified) (1 diff)

WAeUP_SRP/base/WAeUPTables.py

@@ -1611 +1611 @@
 ###)
 
+    def getAllCourses(self,student_id): ###(
+        query = Eq('student_id',student_id)
+        course_results = self.course_results.evalAdvancedQuery(query)
+        for brain in course_results:
+            d = {}
+
+            for field in self.schema():
+                d[field] = getattr(brain,field,'')
+
+            d['weight'] = ''
+            d['grade'] = ''
+            d['score'] = ''
+
+            if str(brain.credits).isdigit():
+                credits = int(brain.credits)
+                score = getattr(brain,'score',0)
+                if score and str(score).isdigit() and int(score) > 0:
+                    score = int(score)
+                    grade,weight = self.getGradesFromScore(score)
+                    d['weight'] = weight
+                    d['grade'] = grade
+                    d['score'] = score
+            d['coe'] = ''
+            if brain.core_or_elective:
+                d['coe'] = 'Core'
+            elif brain.core_or_elective == False:
+                d['coe'] = 'Elective'
+            id = code = d['id'] = brain.code
+            d['code'] = code
+            res = self.courses_catalog.evalAdvancedQuery(Eq('code',code))
+            if res:
+                course = res[0]
+                d['title'] = course.title
+                # The courses_catalog contains strings and integers in its semester field.
+                # Maybe this can be fixed by reindexing the catalog. The schema of course says 'CPS Int Field'.
+                d['semester'] = str(course.semester)
+            else:
+                d['title'] = "Course has been removed from course list"
+                d['semester'] = ''
+            if brain.carry_over:
+                d['coe'] = 'CO'
+            courses.append(d)
+        return courses
+    ###)
+
+InitializeClass(CourseResults)
+###)
+
 class OnlinePaymentsImport(WAeUPTable): ###(