[Dbix-class] Re: DateTime objects passed to search() are not supported properly

[Alexander Hartmaier]

Take a look at the dbic Changelog, it's mentioned in there.

Cheers, Alex

On 2012-08-15 18:24, Bill Moseley wrote:
Pinging on this.   Is this new behavior?   I don't remember seeing these wa=
rnings before -- and I am curious why the calling code needs to do this ins=
tead of DBIC.   Sorry if I'm missing something here.

On Sun, Aug 5, 2012 at 10:26 AM, Bill Moseley <moseley at hank.org<mailto:mose=
ley at hank.org>> wrote:
Running tests saw this message:

DBIx::Class::ResultSet::search(): DateTime objects passed to search() are n=
ot supported properly (InflateColumn::DateTime formats and settings are not=
 respected.) See "Formatting DateTime objects in queries" in DBIx::Class::M=
anual::Cookbook.

Cookbook suggests this:


  my $dtf =3D $schema->storage->datetime_parser;
  my $rs =3D $schema->resultset('users')->search(
    {
      signup_date =3D> {
        -between =3D> [
          $dtf->format_datetime($dt_start),
          $dtf->format_datetime($dt_end),
        ],
      }
    },
  );

I'm curious.  If DBIC knows it's a DateTime object and DBIC has a method to=
 format it correctly then why is there a warning?  Why not just format it?


--
Bill Moseley
moseley at hank.org<mailto:moseley at hank.org>



--
Bill Moseley
moseley at hank.org<mailto:moseley at hank.org>



_______________________________________________
List: http://lists.scsys.co.uk/cgi-bin/mailman/listinfo/dbix-class
IRC: irc.perl.org#dbix-class
SVN: http://dev.catalyst.perl.org/repos/bast/DBIx-Class/
Searchable Archive: http://www.grokbase.com/group/dbix-class@lists.scsys.co=
.uk



*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*=
"*
T-Systems Austria GesmbH Rennweg 97-99, 1030 Wien
Handelsgericht Wien, FN 79340b
*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*=
"*
Notice: This e-mail contains information that is confidential and may be pr=
ivileged.
If you are not the intended recipient, please notify the sender and then
delete this e-mail immediately.
*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*=
"*
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.scsys.co.uk/pipermail/dbix-class/attachments/20120824/8fc=
577f7/attachment.htm