[Dbix-class] NULL values and DBIx::Class::InflateColumn::DateTime

Matt S Trout dbix-class at trout.me.uk
Sun Aug 3 16:19:09 BST 2008


On Sun, Aug 03, 2008 at 01:13:39PM +0100, Will Hawes wrote:
> The InflateColumn::DateTime helper currently throws "Invalid date
> format:  " for rows that contain NULL, even if the column info has
> is_nullable => 1. The docs show that either default_value =>
> '0000-00-00' or datetime_undef_if_invalid => 1 could be used to work
> around this, but bypassing inflation completely based on the presence
> of is_nullable => 1 would be trivial and probably more sensible.

We already bypass inflation of any column that's undef.

get_inflated_column in DBIx::Class::InflateColumn calls _inflate_column
and the first thing that does is

return $value unless defined $value; # NULL is NULL is NULL

so I'm really not sure how you've contrived to get undef passed to an
inflator ...

-- 
      Matt S Trout       Need help with your Catalyst or DBIx::Class project?
   Technical Director                    http://www.shadowcat.co.uk/catalyst/
 Shadowcat Systems Ltd.  Want a managed development or deployment platform?
http://chainsawblues.vox.com/            http://www.shadowcat.co.uk/servers/



More information about the DBIx-Class mailing list