Changeset 732 for pykota/trunk/pykota/storages/sql.py
- Timestamp:
- 02/07/03 01:08:52 (21 years ago)
- Files:
-
- 1 modified
Legend:
- Unmodified
- Added
- Removed
-
pykota/trunk/pykota/storages/sql.py
r729 r732 15 15 # 16 16 # $Log$ 17 # Revision 1.13 2003/02/07 00:08:52 jalet 18 # Typos 19 # 17 20 # Revision 1.12 2003/02/06 23:20:03 jalet 18 21 # warnpykota doesn't need any user/group name argument, mimicing the … … 78 81 """Returns the list of usernames which uses a given printer.""" 79 82 result = self.doQuery("SELECT DISTINCT username FROM users WHERE id IN (SELECT userid FROM userpquota WHERE printerid IN (SELECT printerid FROM printers WHERE printername=%s));" % self.doQuote(printername)) 80 result = result.doParseResult(result)83 result = self.doParseResult(result) 81 84 if result is None : 82 85 return [] … … 87 90 """Returns the list of groups which uses a given printer.""" 88 91 result = self.doQuery("SELECT DISTINCT groupname FROM groups WHERE id IN (SELECT groupid FROM grouppquota WHERE printerid IN (SELECT printerid FROM printers WHERE printername=%s));" % self.doQuote(printername)) 89 result = result.doParseResult(result)92 result = self.doParseResult(result) 90 93 if result is None : 91 94 return []