Changeset 1718
- Timestamp:
- 09/15/04 08:58:25 (20 years ago)
- Location:
- pykota/trunk
- Files:
-
- 2 modified
Legend:
- Unmodified
- Added
- Removed
-
pykota/trunk/bin/dumpykota
r1717 r1718 24 24 # 25 25 # $Log$ 26 # Revision 1.3 2004/09/15 06:58:25 jalet 27 # User groups membership and printer groups membership can now be dumped too 28 # 26 29 # Revision 1.2 2004/09/14 22:29:12 jalet 27 30 # First version of dumpykota. Works fine but only with PostgreSQL backend … … 65 68 - gquotas : dump user groups quotas. 66 69 - payments : dumps user payments. 70 - pmembers : dumps printer groups members. 71 - umembers : dumps user groups members. 67 72 68 73 NB : the -d | --data command line option … … 106 111 "gpquotas", 107 112 "payments", 113 "pmembers", 114 "umembers", 108 115 ] : 109 116 raise PyKotaToolError, _("Invalid modifier [%s] for --data command line option, see help.") % datatype … … 117 124 118 125 entries = getattr(self.storage, "extract%s" % datatype.title())() 119 getattr(self, "dump%s" % format.title())(entries) 126 if entries is not None : 127 getattr(self, "dump%s" % format.title())(entries) 120 128 return 0 121 129 -
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