Changeset 10038 for main/waeup.kofa/trunk

Timestamp:

18 Mar 2013, 10:56:41 (12 years ago)

Author:

Henrik Bettermann

Message:

Add web service method which gets the ids and matric numbers of students registered for a certain course in a certain session.

Location:

main/waeup.kofa/trunk/src/waeup/kofa/students

Files:

• tests/test_webservices.py (modified) (2 diffs)
• webservices.py (modified) (3 diffs)

main/waeup.kofa/trunk/src/waeup/kofa/students/tests/test_webservices.py

@@ -20 +20 @@
         study_level.level_verdict = "A"
         study_level.level = 100
+        study_level.validated_by = u"my adviser"
         student['studycourse'].addStudentStudyLevel(
             self.certificate, study_level)
@@ -146 +147 @@
         self.assertEqual(self.browser.contents, RESPONSE_XML)
         return
+
+    def test_get_students_by_course(self):
+        self.setup_student(self.student)
+        server = ServerProxy('http://mgr:mgrpw@localhost/app')
+        result = server.get_students_by_course('CRS1', '2010')
+        self.assertEqual(result, None)
+        result = server.get_students_by_course('CRS1', '2012')
+        self.assertEqual(result, ['K1000000|234|my adviser'])
+        result = server.get_students_by_course('CRS1')
+        self.assertEqual(result, ['K1000000|234|my adviser'])
+        return

main/waeup.kofa/trunk/src/waeup/kofa/students/webservices.py

@@ -18 +18 @@
 
 import grok
-from zope.component import getUtility
+from zope.component import getUtility, queryUtility
 from zope.catalog.interfaces import ICatalog
 from waeup.kofa.interfaces import IUniversity
@@ -62 +62 @@
     @grok.require('waeup.xmlrpc')
     def get_courses_by_session(self, student_id=None, session=None):
-        """Get the course tickets registered by a student in a certain session.
+        """What COURSES are registered by student X in session Y?
 
         """
@@ -88 +88 @@
             return None
         return coursetickets
+
+    @grok.require('waeup.xmlrpc')
+    def get_students_by_course(self, course=None, session=None):
+        """What STUDENTS registered (student id / matric no)
+        for course Z in session Y?
+
+        (a) Authorized by course adviser.
+        (b) Not authorized by course adviser.
+        """
+        try:
+            session = int(session)
+        except (TypeError, ValueError):
+            pass
+        sessionsearch = True
+        if session in (None, ''):
+            sessionsearch = False
+        cat = queryUtility(ICatalog, name='coursetickets_catalog')
+        if sessionsearch:
+            coursetickets = cat.searchResults(
+                session=(session, session),
+                code=(course, course))
+        else:
+            coursetickets = cat.searchResults(
+                code=(course, course))
+        if not coursetickets:
+            return None
+        hitlist = []
+        for ticket in coursetickets:
+            hitlist.append('%s|%s|%s' % (
+                ticket.student.student_id,
+                ticket.student.matric_number,
+                ticket.__parent__.validated_by))
+        return list(set(hitlist))