DataNucleus

Email Archive: datanucleus-commits (read-only)

2008:	_Jan	_Feb	_Mar (97)	_Apr (765)	_May (572)	_Jun (488)	_Jul (427)	_Aug (666)	_Sep (277)	_Oct (381)	_Nov (422)	_Dec (332)
2009:	_Jan (416)	_Feb (461)	_Mar (506)	_Apr (398)	_May (380)	_Jun (368)	_Jul (383)	_Aug (238)	_Sep (151)	_Oct (213)	_Nov (237)	_Dec (203)
2010:	_Jan (246)	_Feb (290)	_Mar (442)	_Apr (353)	_May (236)	_Jun (369)	_Jul (136)	_Aug (5)	_Sep (55)	_Oct (370)	_Nov (383)	_Dec (292)
2011:	_Jan (358)	_Feb (456)	_Mar (254)	_Apr (135)	_May (208)	_Jun (178)	_Jul (215)	_Aug (103)	_Sep (94)	_Oct (152)	_Nov (114)	_Dec (106)
2012:	_Jan (189)	_Feb (196)	_Mar (160)	_Apr (132)	_May (129)	_Jun (203)	_Jul (338)	_Aug (168)	_Sep (94)	_Oct (299)	_Nov (264)	_Dec (147)
2013:	_Jan (189)	_Feb (184)	_Mar (170)	_Apr (128)	_May (196)	_Jun	_Jul	_Aug	_Sep	_Oct	_Nov	_Dec

[DataNucleus-commits] SF.net SVN: datanucleus:[2528] platform/store.excel/trunk/src/java/org/ datanucleus/store/excel/fieldmanager/StoreFieldManager.java

From: <andy_jefferson@us...> - 2008-08-11 14:02

Revision: 2528
          http://datanucleus.svn.sourceforge.net/datanucleus/?rev=2528&view=rev
Author:   andy_jefferson
Date:     2008-08-11 14:02:04 +0000 (Mon, 11 Aug 2008)

Log Message:
-----------
[NUCEXCEL-10] Cater for null Object field value

Modified Paths:
--------------
    platform/store.excel/trunk/src/java/org/datanucleus/store/excel/fieldmanager/StoreFieldManager.java

Modified: platform/store.excel/trunk/src/java/org/datanucleus/store/excel/fieldmanager/StoreFieldManager.java
===================================================================
--- platform/store.excel/trunk/src/java/org/datanucleus/store/excel/fieldmanager/StoreFieldManager.java	2008-08-11 07:31:31 UTC (rev 2527)
+++ platform/store.excel/trunk/src/java/org/datanucleus/store/excel/fieldmanager/StoreFieldManager.java	2008-08-11 14:02:04 UTC (rev 2528)
@@ -26,6 +26,7 @@
 import org.apache.poi.hssf.usermodel.HSSFRichTextString;
 import org.apache.poi.hssf.usermodel.HSSFRow;
 import org.datanucleus.StateManager;
+import org.datanucleus.metadata.AbstractMemberMetaData;
 import org.datanucleus.store.excel.ExcelUtils;
 import org.datanucleus.store.fieldmanager.FieldManager;
 import org.datanucleus.store.types.ObjectStringConverter;
@@ -64,8 +65,29 @@
     {
         short index = ExcelUtils.getColumnIndexForFieldOfClass(sm.getClassMetaData(), fieldNumber);
         HSSFCell cell = row.createCell(index);
-        if (value instanceof Date)
+        if (value == null)
         {
+            AbstractMemberMetaData mmd = 
+                sm.getClassMetaData().getMetaDataForManagedMemberAtAbsolutePosition(fieldNumber);
+            if (Number.class.isAssignableFrom(mmd.getType()))
+            {
+                cell.setCellValue(0.0);
+            }
+            else if (Date.class.isAssignableFrom(mmd.getType()))
+            {
+                cell.setCellValue((Date)null);
+            }
+            else if (Calendar.class.isAssignableFrom(mmd.getType()))
+            {
+                cell.setCellValue((Calendar)null);
+            }
+            else
+            {
+                // Do nothing
+            }
+        }
+        else if (value instanceof Date)
+        {
             cell.setCellValue((Date)value);
         }
         else if (value instanceof Calendar)


This was sent by the SourceForge.net collaborative development platform, the world's largest Open Source development site.

[DataNucleus-commits] SF.net SVN: datanucleus:[4118] platform/store.excel/trunk/src/java/org/ datanucleus/store/excel/fieldmanager/StoreFieldManager.java

From: <andy_jefferson@us...> - 2008-11-30 07:58

Revision: 4118
          http://datanucleus.svn.sourceforge.net/datanucleus/?rev=4118&view=rev
Author:   andy_jefferson
Date:     2008-11-30 07:58:53 +0000 (Sun, 30 Nov 2008)

Log Message:
-----------
[NUCEXCEL-20] Add casts for POI deprecation changes

Modified Paths:
--------------
    platform/store.excel/trunk/src/java/org/datanucleus/store/excel/fieldmanager/StoreFieldManager.java

Modified: platform/store.excel/trunk/src/java/org/datanucleus/store/excel/fieldmanager/StoreFieldManager.java
===================================================================
--- platform/store.excel/trunk/src/java/org/datanucleus/store/excel/fieldmanager/StoreFieldManager.java	2008-11-30 07:44:34 UTC (rev 4117)
+++ platform/store.excel/trunk/src/java/org/datanucleus/store/excel/fieldmanager/StoreFieldManager.java	2008-11-30 07:58:53 UTC (rev 4118)
@@ -50,7 +50,7 @@
     public void storeStringField(int fieldNumber, String value)
     {
         short index = (short)ExcelUtils.getColumnIndexForFieldOfClass(sm.getClassMetaData(), fieldNumber);
-        HSSFCell cell = row.createCell(index);
+        HSSFCell cell = row.createCell((int)index);
         if (value == null)
         {
             row.removeCell(cell);
@@ -64,7 +64,7 @@
     public void storeObjectField(int fieldNumber, Object value)
     {
         short index = (short)ExcelUtils.getColumnIndexForFieldOfClass(sm.getClassMetaData(), fieldNumber);
-        HSSFCell cell = row.createCell(index);
+        HSSFCell cell = row.createCell((int)index);
         if (value == null)
         {
             AbstractMemberMetaData mmd = 
@@ -114,56 +114,56 @@
     public void storeBooleanField(int fieldNumber, boolean value)
     {
         short index = (short)ExcelUtils.getColumnIndexForFieldOfClass(sm.getClassMetaData(), fieldNumber);
-        HSSFCell cell = row.createCell(index);
+        HSSFCell cell = row.createCell((int)index);
         cell.setCellValue(value);
     }
 
     public void storeByteField(int fieldNumber, byte value)
     {
         short index = (short)ExcelUtils.getColumnIndexForFieldOfClass(sm.getClassMetaData(), fieldNumber);
-        HSSFCell cell = row.createCell(index);
+        HSSFCell cell = row.createCell((int)index);
         cell.setCellValue(value);
     }
 
     public void storeCharField(int fieldNumber, char value)
     {
         short index = (short)ExcelUtils.getColumnIndexForFieldOfClass(sm.getClassMetaData(), fieldNumber);
-        HSSFCell cell = row.createCell(index);
+        HSSFCell cell = row.createCell((int)index);
         cell.setCellValue(value);
     }
 
     public void storeDoubleField(int fieldNumber, double value)
     {
         short index = (short)ExcelUtils.getColumnIndexForFieldOfClass(sm.getClassMetaData(), fieldNumber);
-        HSSFCell cell = row.createCell(index);
+        HSSFCell cell = row.createCell((int)index);
         cell.setCellValue(value);
     }
 
     public void storeFloatField(int fieldNumber, float value)
     {
         short index = (short)ExcelUtils.getColumnIndexForFieldOfClass(sm.getClassMetaData(), fieldNumber);
-        HSSFCell cell = row.createCell(index);
+        HSSFCell cell = row.createCell((int)index);
         cell.setCellValue(value);
     }
 
     public void storeIntField(int fieldNumber, int value)
     {
         short index = (short)ExcelUtils.getColumnIndexForFieldOfClass(sm.getClassMetaData(), fieldNumber);
-        HSSFCell cell = row.createCell(index);
+        HSSFCell cell = row.createCell((int)index);
         cell.setCellValue(value);
     }
 
     public void storeLongField(int fieldNumber, long value)
     {
         short index = (short)ExcelUtils.getColumnIndexForFieldOfClass(sm.getClassMetaData(), fieldNumber);
-        HSSFCell cell = row.createCell(index);
+        HSSFCell cell = row.createCell((int)index);
         cell.setCellValue(value);
     }
 
     public void storeShortField(int fieldNumber, short value)
     {
         short index = (short)ExcelUtils.getColumnIndexForFieldOfClass(sm.getClassMetaData(), fieldNumber);
-        HSSFCell cell = row.createCell(index);
+        HSSFCell cell = row.createCell((int)index);
         cell.setCellValue(value);
     }
 


This was sent by the SourceForge.net collaborative development platform, the world's largest Open Source development site.

[DataNucleus-commits] SF.net SVN: datanucleus:[8880] platform/store.excel/trunk/src/java/org/ datanucleus/store/excel/fieldmanager/StoreFieldManager.java

From: <andy_jefferson@us...> - 2010-02-19 12:47

Revision: 8880
          http://datanucleus.svn.sourceforge.net/datanucleus/?rev=8880&view=rev
Author:   andy_jefferson
Date:     2010-02-19 12:47:04 +0000 (Fri, 19 Feb 2010)

Log Message:
-----------
if using string/long converter, return

Modified Paths:
--------------
    platform/store.excel/trunk/src/java/org/datanucleus/store/excel/fieldmanager/StoreFieldManager.java

Modified: platform/store.excel/trunk/src/java/org/datanucleus/store/excel/fieldmanager/StoreFieldManager.java
===================================================================
--- platform/store.excel/trunk/src/java/org/datanucleus/store/excel/fieldmanager/StoreFieldManager.java	2010-02-19 12:46:45 UTC (rev 8879)
+++ platform/store.excel/trunk/src/java/org/datanucleus/store/excel/fieldmanager/StoreFieldManager.java	2010-02-19 12:47:04 UTC (rev 8880)
@@ -130,6 +130,7 @@
                     if (longConv != null)
                     {
                         cell.setCellValue(longConv.toLong(value));
+                        return;
                     }
                 }
                 else
@@ -138,10 +139,12 @@
                     {
                         CreationHelper createHelper = row.getSheet().getWorkbook().getCreationHelper();
                         cell.setCellValue(createHelper.createRichTextString(strConv.toString(value)));
+                        return;
                     }
                     else if (longConv != null)
                     {
                         cell.setCellValue(longConv.toLong(value));
+                        return;
                     }
                 }
 


This was sent by the SourceForge.net collaborative development platform, the world's largest Open Source development site.

[DataNucleus-commits] SF.net SVN: datanucleus:[13023] platform/store.excel/trunk/src/java/org/ datanucleus/store/excel/fieldmanager/StoreFieldManager.java

From: <andy_jefferson@us...> - 2011-06-01 13:49

Revision: 13023
          http://datanucleus.svn.sourceforge.net/datanucleus/?rev=13023&view=rev
Author:   andy_jefferson
Date:     2011-06-01 13:49:29 +0000 (Wed, 01 Jun 2011)

Log Message:
-----------
[NUCEXCEL-50] Fix reachability issue of overwriting of rows

Modified Paths:
--------------
    platform/store.excel/trunk/src/java/org/datanucleus/store/excel/fieldmanager/StoreFieldManager.java

Modified: platform/store.excel/trunk/src/java/org/datanucleus/store/excel/fieldmanager/StoreFieldManager.java
===================================================================
--- platform/store.excel/trunk/src/java/org/datanucleus/store/excel/fieldmanager/StoreFieldManager.java	2011-06-01 13:21:01 UTC (rev 13022)
+++ platform/store.excel/trunk/src/java/org/datanucleus/store/excel/fieldmanager/StoreFieldManager.java	2011-06-01 13:49:29 UTC (rev 13023)
@@ -34,6 +34,7 @@
 import org.datanucleus.metadata.AbstractClassMetaData;
 import org.datanucleus.metadata.AbstractMemberMetaData;
 import org.datanucleus.metadata.ColumnMetaData;
+import org.datanucleus.metadata.IdentityType;
 import org.datanucleus.metadata.Relation;
 import org.datanucleus.store.ExecutionContext;
 import org.datanucleus.store.ObjectProvider;
@@ -56,6 +57,23 @@
     {
         this.op = op;
         this.row = row;
+
+        // Add PK field(s) cell, so that the row is detected by ExcelUtils.getNumberOfRowsInSheetOfWorkbook
+        AbstractClassMetaData cmd = op.getClassMetaData();
+        if (cmd.getIdentityType() == IdentityType.APPLICATION)
+        {
+            int[] pkFieldNumbers = cmd.getPKMemberPositions();
+            for (int j=0;j<pkFieldNumbers.length;j++)
+            {
+                int colNumber = (int)ExcelUtils.getColumnIndexForFieldOfClass(cmd, pkFieldNumbers[j]);
+                row.createCell(colNumber);
+            }
+        }
+        else if (op.getClassMetaData().getIdentityType() == IdentityType.DATASTORE)
+        {
+            int datastoreIdColNumber = (int)ExcelUtils.getColumnIndexForFieldOfClass(cmd, -1);
+            row.createCell(datastoreIdColNumber);
+        }
     }
 
     protected int getColumnIndexForMember(int memberNumber)
@@ -206,6 +224,11 @@
                 CreationHelper createHelper = row.getSheet().getWorkbook().getCreationHelper();
                 cell.setCellValue(createHelper.createRichTextString(((Enum)value).name()));
             }
+            /*else if (byte[].class == mmd.getType())
+            {
+                String strValue = new String(Base64.encode((byte[]) value));
+                cell.setCellValue(strValue);
+            }*/
             else
             {
                 // Try to persist using converters


This was sent by the SourceForge.net collaborative development platform, the world's largest Open Source development site.