Changeset 2605

Timestamp:

01/28/10 11:14:37 (2 years ago)

Author:

mswertz

Message:

enhancement: CURRENT_TIMESTAMP default translates to auto="true"

File:

• molgenis/3.3/src/org/molgenis/model/JDBCModelExtractor.java (modified) (1 diff)

molgenis/3.3/src/org/molgenis/model/JDBCModelExtractor.java

@@ -161 +161 @@
                                         f.setType(Field.Type.getType(fieldInfo.getInt("DATA_TYPE")));
                                         f.setDefaultValue(fieldInfo.getString("COLUMN_DEF"));
+                                        
+                                        //accomodate mysql CURRENT_TIMESTAMP
+                                        if("CURRENT_TIMESTAMP".equals(f.getDefaultValue()) && 
+                                                        (f.getType().equals(Field.Type.DATETIME) || f.getType().equals(Field.Type.DATE)))
+                                        {
+                                                f.setDefaultValue(null);
+                                                f.setAuto(true);
+                                        }
+                                        
                                         if(fieldInfo.getString("REMARKS") != null && !"".equals(fieldInfo.getString("REMARKS").trim()) )f.setDescription(fieldInfo.getString("REMARKS"));
                                         if (fieldInfo.getBool("NULLABLE")) f.setNillable(true);