Changeset 780 for WAeUP_SRP/trunk/WAeUPTables.py

Timestamp:

2 Nov 2006, 10:56:46 (18 years ago)

Author:

joachim

Message:

view PUME result finalized,
export of PINs started

File:

• WAeUP_SRP/trunk/WAeUPTables.py (modified) (3 diffs)

WAeUP_SRP/trunk/WAeUPTables.py

@@ -21 +21 @@
 from Globals import InitializeClass
 from Products.ZCatalog.ZCatalog import ZCatalog
+from AccessControl import ClassSecurityInfo
+from Products.CMFCore.permissions import ModifyPortalContent
+
+import DateTime
+import csv,re
+import logging
+import Globals
+p_home = Globals.package_home(globals())
+i_home = Globals.INSTANCE_HOME
 
 from interfaces import IWAeUPTable
@@ -37 +46 @@
     
     implements(IWAeUPTable)
+    security = ClassSecurityInfo()
         
     def addRecord(self, **data):
@@ -71 +81 @@
         self.catalog_object(dict2ob(record_data), uid)
 
+    security.declareProtected(ModifyPortalContent,"exportAllRecords")
+    def exportAllRecords(self):
+        "export a WAeUPTable"
+        #import pdb;pdb.set_trace()
+        fields = [field for field in self.schema()]
+        format = ','.join(['"%%(%s)s"' % fn for fn in fields])
+        csv = []
+        csv.append(','.join(['"%s"' % fn for fn in fields]))
+        for uid in self._catalog.uids:
+            records = self.searchResults({"%s" % self.key : uid})
+            if len(records) > 1:
+                # Can not happen, but anyway...
+                raise ValueError("More than one record with uid %s" % uid)
+            if len(records) == 0:
+                raise KeyError("No record for uid %s" % uid)
+            rec = records[0]
+            csv.append(format % rec)
+        current = DateTime.DateTime().strftime("%d-%m-%y_%H_%M_%S")
+        open("%s/import/%s-%s.csv" % (i_home,self.getId(),current),"w+").write('\n'.join(csv))
+        
+            
 class AccommodationTable(WAeUPTable):