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.