← Back to branch summary

~azzar1/unity/add-show-desktop-key

« back to all changes in this revision

Viewing changes to ivle/db.py

  • Committer: me at id
  • Date: 2009-01-15 06:11:32 UTC
  • mto: This revision was merged to the branch mainline in revision 1090.
  • Revision ID: svn-v3-trunk0:2b9c9e99-6f39-0410-b283-7f802c844ae2:branches%2Fstorm:1164
ivle.db: Remove get_enrolment and get_subjects_status. They're unused.

Show diffs side-by-side

added added

removed removed

Lines of Context:
ivle/db.py
915
915
        return self.db.query(query).dictresult()
916
916
 
917
917
 
918
 
    def get_enrolment(self, login, dry=False):
919
 
        """
920
 
        Get all offerings (in IVLE) the student is enrolled in.
921
 
        Returns a list of dicts (all values strings), with the keys:
922
 
        offeringid, subj_code, subj_name, subj_short_name, year, semester, url
923
 
        """
924
 
        query = """\
925
 
SELECT offering.offeringid, subj_code, subj_name, subj_short_name,
926
 
       semester.year, semester.semester, subject.url
927
 
FROM login, enrolment, offering, subject, semester
928
 
WHERE enrolment.offeringid=offering.offeringid
929
 
  AND login.loginid=enrolment.loginid
930
 
  AND offering.subject=subject.subjectid
931
 
  AND semester.semesterid=offering.semesterid
932
 
  AND enrolment.active
933
 
  AND login=%s;""" % _escape(login)
934
 
        if dry:
935
 
            return query
936
 
        return self.db.query(query).dictresult()
937
 
 
938
918
    def get_enrolment_groups(self, login, offeringid, dry=False):
939
919
        """
940
920
        Get all groups the user is member of in the given offering.
954
934
            return query
955
935
        return self.db.query(query).dictresult()
956
936
 
957
 
    def get_subjects_status(self, login, dry=False):
958
 
        """
959
 
        Get all subjects in IVLE, split into lists of enrolled and unenrolled
960
 
        subjects.
961
 
        Returns a tuple of lists (enrolled, unenrolled) of dicts
962
 
        (all values strings) with the keys:
963
 
        subj_code, subj_name, subj_short_name, url
964
 
        """
965
 
        enrolments = self.get_enrolment(login)
966
 
        all_subjects = self.get_subjects()
967
 
 
968
 
        enrolled_set = set(x['subj_code'] for x in enrolments)
969
 
 
970
 
        enrolled_subjects = [x for x in all_subjects
971
 
                             if x['subj_code'] in enrolled_set]
972
 
        unenrolled_subjects = [x for x in all_subjects
973
 
                               if x['subj_code'] not in enrolled_set]
974
 
        enrolled_subjects.sort(key=lambda x: x['subj_code'])
975
 
        unenrolled_subjects.sort(key=lambda x: x['subj_code'])
976
 
        return (enrolled_subjects, unenrolled_subjects)
977
 
 
978
937
 
979
938
    # PROJECT GROUPS
980
939
    def get_groups_by_user(self, login, offeringid=None, dry=False):