propel-convert-xml-schema generate null text as default values

Scheenshoot

I also use a kind of reverse engeneering with the database. This approach allows me to create/edit the database with triggers and stored procedures using my favorite visual tools, which is way more convenient for complex database than defining schema.yml by hand.

The best solution I found was a "patch" for the generated schema.xml file. The patch simply removes default="" and <parameter name="Default" value=""/> from the file.

This works well for me. PS: I believe this is Propel's issue.

It's propel's fault indeed. I tried to signal it to propel team (IRC & trac), but :

_ Trac need a valid acount to open a ticket and account creation is restricted _ On #propel irc chan they said me that the next big thing is propel 1.3 and that propel 1.2 has never existed and they'll never apply any patch on it.

So I have a Little patch to fix the problem @ schema generation time, could you apply it into symfony replository please ? :

Index: propel-generator/classes/propel/phing/PropelCreoleTransformTask.php
===================================================================
--- propel-generator/classes/propel/phing/PropelCreoleTransformTask.php (révision 7563)
+++ propel-generator/classes/propel/phing/PropelCreoleTransformTask.php (copie de travail)
@@ -504,7 +504,9 @@
                }
 
                if (($defValue = $column->getDefaultValue()) !== null) {
-                       $node->setAttribute("default", iconv($this->dbEncoding, 'utf-8', $defValue));
+                       if(!empty($defValue)) {
+                               $node->setAttribute("default", iconv($this->dbEncoding, 'utf-8', $defValue));
+                       }
                }
 
                if ($vendorNode = $this->createVendorInfoNode($column->getVendorSpecificInfo())) {

Replying to Fernando.Toledo:

i convert the schema from xml to yml. my schema.xml have default values as "" in some fields {{{ <column name="nombre" type="VARCHAR" size="128" required="true" default=""/> }}} in the converted schema.yml the field have an attribute "default:" {{{ nombre: type: VARCHAR size: 128 required: true default: }}} it's behavior make a "null" word as default value in the text input controls like the screenshot attached. i think that the parser must be ignore it. and no generate the "default:" attribute if the xml has "" (empty string).

This bug should be filled with the creole trac at creole.phpdb.org.

Please post this issue to Propel again. They're being much more responsive lately.

in symfony 1.2.8 i solve the issue related to null text modifying the following file:
lib/vendors/symfony/lib/plugins/sfPropelPlugin/lib/vendor/propel-generator/classes/propel/engine/builder/om/php5/PHP5ObjectBuilder.php

replacing the line 142:

$defaultValue = var_export($val, true);

with:

$defaultValue = $val === 'null' ? $val : var_export($val, true);

This is a patch but works for me, if your default value is 'null' as string it will be transformed in a PHP null value in your model.

This patch only modify the generated class model, not the generated yml or xml schema file.

Hope this help.