← Back to branch summary

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

« back to all changes in this revision

Viewing changes to lib/common/db.py

  • Committer: wagrant
  • Date: 2008-08-10 11:25:42 UTC
  • Revision ID: svn-v3-trunk0:2b9c9e99-6f39-0410-b283-7f802c844ae2:trunk:1008
groups: Pretty up a bit. Remove buttons that did nothing and won't for
        months. Also actually list the members of one's own groups.

Show diffs side-by-side

added added

removed removed

Lines of Context:
lib/common/db.py
1047
1047
        """Returns the logins of all students in a project group
1048
1048
        """
1049
1049
        query = """\
1050
 
SELECT login
 
1050
SELECT login.login as login, login.fullname as fullname
1051
1051
FROM login, group_member
1052
1052
WHERE login.loginid = group_member.loginid AND
1053
 
    group_member.groupid = %d;"""%groupid
 
1053
    group_member.groupid = %d
 
1054
ORDER BY login.login;"""%groupid
1054
1055
        if dry:
1055
1056
            return query
1056
1057
        return self.db.query(query).dictresult()