Changeset 1718 for pykota/trunk/pykota
- Timestamp:
- 09/15/04 08:58:25 (20 years ago)
- Files:
-
- 1 modified
Legend:
- Unmodified
- Added
- Removed
-
pykota/trunk/pykota/storages/sql.py
r1717 r1718 22 22 # 23 23 # $Log$ 24 # Revision 1.46 2004/09/15 06:58:25 jalet 25 # User groups membership and printer groups membership can now be dumped too 26 # 24 27 # Revision 1.45 2004/09/14 22:29:13 jalet 25 28 # First version of dumpykota. Works fine but only with PostgreSQL backend … … 104 107 """Extracts all grouppquota records.""" 105 108 result = self.doRawSearch("SELECT groups.groupname,printers.printername,grouppquota.* FROM groups,printers,grouppquota WHERE groups.id=grouppquota.groupid AND printers.id=grouppquota.printerid") 109 return self.prepareRawResult(result) 110 111 def extractUmembers(self) : 112 """Extracts all user groups members.""" 113 result = self.doRawSearch("SELECT groups.groupname, users.username, groupsmembers.* FROM groups,users,groupsmembers WHERE users.id=groupsmembers.userid AND groups.id=groupsmembers.groupid") 114 return self.prepareRawResult(result) 115 116 def extractPmembers(self) : 117 """Extracts all printer groups members.""" 118 result = self.doRawSearch("SELECT p1.printername as pgroupname, p2.printername as printername, printergroupsmembers.* FROM printers p1, printers p2, printergroupsmembers WHERE p1.id=printergroupsmembers.groupid AND p2.id=printergroupsmembers.printerid") 106 119 return self.prepareRawResult(result) 107 120