Changeset 749

Timestamp:

01/20/08 21:05:17 (11 months ago)

Author:

laurentj

Message:

fixed bug 432: jDbTools, mysql driver : in some version of PHP/mysql, the default value on a field is not always an empty string or a null value

Files:

• branches/1.0.x/lib/jelix/plugins/db/mysql/mysql.dbtools.php (modified) (1 diff)
• branches/1.0.x/lib/jelix/plugins/db/mysql/mysql.dbtools.php (modified) (1 diff)
• branches/1.0.x/lib/jelix/plugins/db/mysql/mysql.dbtools.php (modified) (1 diff)
• trunk/lib/jelix/plugins/db/mysql/mysql.dbtools.php (modified) (1 diff)
• trunk/lib/jelix/plugins/db/mysql/mysql.dbtools.php (modified) (1 diff)
• trunk/lib/jelix/plugins/db/mysql/mysql.dbtools.php (modified) (1 diff)

branches/1.0.x/lib/jelix/plugins/db/mysql/mysql.dbtools.php

@@ -63 +63 @@
-            $field->notNull = ($line->Null == 'NO');
-            $field->primary = ($line->Key == 'PRI');
+            $field->autoIncrement  = ($line->Extra == 'auto_increment');
-            $field->hasDefault = ($line->Default != '' || !($line->Default == null && $field->notNull));
-
-
+
+
+
+
+
-            $results[$line->Field] = $field;
-        }

branches/1.0.x/lib/jelix/plugins/db/mysql/mysql.dbtools.php

@@ -63 +63 @@
-            $field->notNull = ($line->Null == 'NO');
-            $field->primary = ($line->Key == 'PRI');
+            $field->autoIncrement  = ($line->Extra == 'auto_increment');
-            $field->hasDefault = ($line->Default != '' || !($line->Default == null && $field->notNull));
-
-
+
+
+
+
+
-            $results[$line->Field] = $field;
-        }

branches/1.0.x/lib/jelix/plugins/db/mysql/mysql.dbtools.php

@@ -63 +63 @@
-            $field->notNull = ($line->Null == 'NO');
-            $field->primary = ($line->Key == 'PRI');
+            $field->autoIncrement  = ($line->Extra == 'auto_increment');
-            $field->hasDefault = ($line->Default != '' || !($line->Default == null && $field->notNull));
-
-
+
+
+
+
+
-            $results[$line->Field] = $field;
-        }

trunk/lib/jelix/plugins/db/mysql/mysql.dbtools.php

@@ -63 +63 @@
-            $field->notNull = ($line->Null == 'NO');
-            $field->primary = ($line->Key == 'PRI');
+            $field->autoIncrement  = ($line->Extra == 'auto_increment');
-            $field->hasDefault = ($line->Default != '' || !($line->Default == null && $field->notNull));
-
-
+
+
+
+
+
-            $results[$line->Field] = $field;
-        }

trunk/lib/jelix/plugins/db/mysql/mysql.dbtools.php

@@ -63 +63 @@
-            $field->notNull = ($line->Null == 'NO');
-            $field->primary = ($line->Key == 'PRI');
+            $field->autoIncrement  = ($line->Extra == 'auto_increment');
-            $field->hasDefault = ($line->Default != '' || !($line->Default == null && $field->notNull));
-
-
+
+
+
+
+
-            $results[$line->Field] = $field;
-        }

trunk/lib/jelix/plugins/db/mysql/mysql.dbtools.php

@@ -63 +63 @@
-            $field->notNull = ($line->Null == 'NO');
-            $field->primary = ($line->Key == 'PRI');
+            $field->autoIncrement  = ($line->Extra == 'auto_increment');
-            $field->hasDefault = ($line->Default != '' || !($line->Default == null && $field->notNull));
-
-
+
+
+
+
+
-            $results[$line->Field] = $field;
-        }