Changeset 283 for trunk/grails-app/services/dbnp/importer/ImporterService.groovy

Timestamp:

Mar 18, 2010, 10:17:02 AM (13 years ago)

Author:

tabma

Message:

• final step in the wizard, implemented method in the ImporterService? to persist the entities into the database

File:

• trunk/grails-app/services/dbnp/importer/ImporterService.groovy (modified) (4 diffs)

trunk/grails-app/services/dbnp/importer/ImporterService.groovy

@@ -151 +151 @@
     * @param sheetindex sheet to use when using multiple sheets
     * @param rowindex first row to start with reading the actual data (NOT the header)
+    * @return two dimensional array containing records (with entities)
     * 
     * @see dbnp.importer.MappingColumn
@@ -163 +164 @@
         }
 
-        table.each {
+        /*table.each {
             it.each { entity ->
                 entity.giveFields().each { field ->
@@ -170 +171 @@
                 println
             }
-        }
-    }
+        }*/
+
+        return table    
+    }
+    
+    /**
+     * @param datamatrix two dimensional array containing entities with values read from Excel file
+     */    
+    def savedata(datamatrix) {
+        datamatrix.each { record ->
+            record.each { entity ->
+                switch (entity.getClass()) {
+                    case Study   :  print "Persisting Study `" + entity.title + "`: "
+                                    entity.save()
+                                    println "OK"
+                                    break
+                    case Subject :  print "Persisting Subject `" + entity.name + "`: "
+                                    entity.save()
+                                    println "OK"
+                                    break
+                    case Event   :  print "Persisting Event `" + entity.eventdescription + "`: "
+                                    entity.save()
+                                    println "OK"
+                                    break
+                    case Protocol:  print "Persisting Protocol `" + entity.name + "`: "
+                                    entity.save()
+                                    println "OK"
+                                    break
+                    case Sample  :  print "Persisting Sample `" + entity.name +"`: "
+                                    entity.save()
+                                    println "OK"
+                                    break
+                    default      :  println "Skipping persistance of `" + entity.getclass() +"`"
+                                    break
+                }
+            }
+        }
+    }
+
     /**
      * This method created a record (array) containing entities with values
+     *
+     * @param template_id template identifier
+     * @param excelrow POI based Excel row containing the cells
+     * @param mcmap map containing MappingColumn objects
      */
     def createRecord(template_id, HSSFRow excelrow, mcmap) {
@@ -181 +223 @@
 
         def study = new Study(title:"New study", template:template)
-        def subject = new Subject(title:"New subject", template:template)
-        def event = new Event(title:"New event", template:template)
-        def protocol = new Protocol(title:"New protocol", template:template)
-        def sample = new Sample(title:"New sample", template:template)
-
-        /*record.add(study)
-        record.add(subject)
-        record.add(event)
-        record.add(protocol)
-        record.add(sample)*/
+        def subject = new Subject(name:"New subject", template:template)
+        def event = new Event(eventdescription:"New event", template:template)
+        def protocol = new Protocol(name:"New protocol", template:template)
+        def sample = new Sample(name:"New sample", template:template)
 
         for (HSSFCell cell: excelrow) {