Changeset 947

Timestamp:

27 Nov 2006, 09:39:30 (18 years ago)

Author:

joachim

Message:

import all Pin-Batches from dir import/pins

File:

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

WAeUP_SRP/trunk/ScratchCards.py

@@ -13 +13 @@
 import DateTime
 import Globals
+import logging
+import os,csv,re
+import Globals
+MAX_TRANS = 1000
 p_home = Globals.package_home(globals())
 i_home = Globals.INSTANCE_HOME
@@ -29 +33 @@
         return "Pin Batches"
 
+    security.declareProtected(ModifyPortalContent,"importPinBatch") ###(
+    def importPinBatch(self):
+        """import PinBatch"""
+        name = "PINS"
+        logger = logging.getLogger('%s_import' % name)
+        logger.info('Start loading from %s.csv' % name)
+        pins_section = self.portal_url.getPortalObject().campus.pins
+        p_pins = self.portal_pins
+        base_dir = "%s/import/pins" % (i_home)
+        files = os.listdir(base_dir)
+        for fn in files:
+            pins = csv.DictReader(open("%s/import/%s" % (i_home,fn),"rb"))
+            n = 0
+            for pin in pins:
+                if n == 0:
+                    bid = "%(Serial)s_%(Pin)s" % pin
+                    pins_section.invokeFactory('ScratchCardBatch', bid)
+                    batch = getattr(pins_section,bid)
+                    dict = {}
+                    prefix = pin['Serial']
+                    dict['prefix'] = pin['Serial'] 
+                    batch_no = pin['Pin']
+                    dict['batch_no'] = int(batch_no)
+                    dict['cost'] = float(pin['Cost'])
+                    dict['sold_by'] = pin['Sold']
+                    #import pdb;pdb.set_trace()
+                    n += 1
+                    continue
+                p_pins.addRecord(pin=pin['Pin'],serial=n,student="",prefix_batch="%s%s" % (prefix, batch_no))
+                n += 1
+            dict['no_of_pins'] = n - 1
+            batch.getContent().edit(mapping=dict)
+            logger.info('Added %s with %d Pins' % (bid,n-1))
+        return self.REQUEST.RESPONSE.redirect("%s" % self.REQUEST.get('URL1'))
+    ###)
 
 InitializeClass(ScratchCardBatchesFolder)
@@ -84 +123 @@
     ###)
 
+
     security.declareProtected(ModifyPortalContent,"getUnusedPins")
     def getUnusedPins(self):