[html-formfu] Model::DBIC inserts empty strings instead of NULL values

[Dmitry Bigunyak]

I like the idea about 'null_if_empty' option. I think it will work just 
fine for me. :) Is it possible to include this small fix to the next 
release?


15.06.2011 15:08, Peter Shangov пишет:
> OK, my oversight.
>
> H::FF::M::DBIC does roughly the following check to determine whether a field's value should be set to NULL:
>
>    if ( $is_nullable&&  $data_type =~ m/^timestamp|date|int|float|numeric/i ) { ... }
>
> I am not sure why the second check is there, but I am sure there is a good reason for it, so I would not change it.
>
> If an option 'null_if_empty' is added for fields, and it forces the field's value to be set to NULL regardless of the data type, would that work for you?
>
> Cheers,
>
> --
> Peter
>
>
> ----- Original Message -----
>> From: Dmitry Bigunyak<icestar at inbox.ru>
>> To: "HTML Form Creation, Rendering and Validation Framework"<html-formfu at lists.scsys.co.uk>
>> Cc:
>> Sent: Wednesday, 15 June 2011, 12:22
>> Subject: Re: [html-formfu] Model::DBIC inserts empty strings instead of NULL values
>>
>> Hi Peter,
>> In my initial post I've written about this option:
>>>   I thought about using ignore_if_empty option, but I lose ability to
>> unset the column value to NULL with it.
>>
>> thanks for your reply
>>
>> 15.06.2011 13:12, Peter Shangov пишет:
>>>   Dmitry, Alex,
>>>
>>>   There is an undocumented option 'ignore_if_empty' for columns,
>> which instructs HTML::FormFu::Model::DBIC not to save the value to the database
>> if it is an empty string. Can you try that and see if it works? Here is a sample
>> configuration:
>>>
>>>   elements:
>>>      - type: Text
>>>
>>>        name: some_field
>>>        model_config:
>>>            ignore_if_empty: 1
>>>
>>>   Cheers,
>>>
>>>   --
>>>   Peter
>>>
>>>
>>>