Oh. Ok, thanks On 6 September 2010 17:16, Neil Lunn <[email protected]> wrote:
> Was pointing out that a a Inflator is a convenience method from the
> original object.
>
> In your query source:
>
>
> select => [ { max => 'me.date_created' } ],
> as => [ 'date_created' ],
>
> So the problem essentially is that your underlying object doesn't know that
> your derived [ max(date_created) ] column is to cast as a DateTIme object
> like it knows how to do so for the defined column [ me.date_created ].
>
> Therefore you either:
>
> a. Look here:
> http://search.cpan.org/~frew/DBIx-Class-0.08123/lib/DBIx/Class/Manual/Cookbook.pod#Arbitrary_SQL_through_a_custom_ResultSource<http://search.cpan.org/%7Efrew/DBIx-Class-0.08123/lib/DBIx/Class/Manual/Cookbook.pod#Arbitrary_SQL_through_a_custom_ResultSource>
> and define your result object in a way that understands your now max result
> column is to return a DateTime object from the string it gets.
>
> b. Recast your results in a different Moose Class and co-erce the result
> into a DateTime object from there.
>
>
>
> On Mon, 2010-09-06 at 16:31 +1200, Dan Horne wrote:
>
> Hi
>
> Which part of the documentation are you referring to? My dates normally
> inflate, but not when I apply the max function.
>
> On 6 September 2010 16:16, Neil Lunn <[email protected]> wrote:
>
>
> Try:
>
>
> http://search.cpan.org/~frew/DBIx-Class-0.08123/lib/DBIx/Class/InflateColumn/DateTime.pm<http://search.cpan.org/%7Efrew/DBIx-Class-0.08123/lib/DBIx/Class/InflateColumn/DateTime.pm>
>
>
>
>
>
>
> On Mon, 2010-09-06 at 15:58 +1200, Dan Horne wrote:
>
>
> Hi
>
> Consider the following: A config has many sections. A section has many
> process runs. I want to find the latest process run from a config and
> section combination:
>
> my $rs = $scheduler->EpProcessRun->search(
> {
> 'ep_config.config_name' => 'my_config',
> 'ep_section.section_name' => 'my_section',
> },
> {
> select => [ { max => 'me.date_created' } ],
> as => [ 'date_created' ],
> 'join' => {'ep_section' => ['ep_config']},
> }
> );
>
> say $rs->first->get_column('date_created');
>
> This works - but the date is text, whereas I was hoping it would be
> inflated to a DateTime object (as they are with regular queries). The
> generated SQL is
>
> SELECT MAX(me.date_created)
> FROM ep_process_run me
> JOIN ep_section ep_section
> ON ep_section.section_id = me.section_id
> JOIN ep_config ep_config
> ON ep_config.config_id = ep_section.config_id
> WHERE ((ep_config.config_name = ? AND ep_section.section_name = ?))
>
> I also tried
>
> my $rs = $scheduler->EpProcessRun->search(
> {
> 'ep_config.config_name' => 'my_config',
> 'ep_section.section_name' => 'my_section',
> },
> {
> 'join' => {'ep_section' => ['ep_config']},
> }
> );
>
> say $rs->get_column('date_created')->max;
>
> The generated SQL is exactly the same, and the date isn't inflated. Am I
> doing something wrong, or have I hit a DBIx::Class limitation? I;m on
> DBIx:Class v0.08123 on Win32
>
> Dan
>
> _______________________________________________
> 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/[email protected]
>
>
>
>
> _______________________________________________
> 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/[email protected]
>
>
> _______________________________________________
> 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/[email protected]
>
> --
>
>
> Regards,
>
> *Neil Lunn*
> *IT Support E-Commerce Stream*
> *Trixan Group of Companies*
>
>
> *p:* +61 1300 TRIXAN or +61 1300 874 926 (ext. 1206)
> *f:* +61 2 9475 0553
> *e:* *[email protected]*
> *w:* <http://www.trixan.com/>*www.trixan.com*
>
> This electronic message, including its attachments, is confidential and may
> be privileged or otherwise protected. The information is solely for the
> intended recipient. If you are not the intended recipient, this message was
> sent to you in error and you are hereby advised that any review, disclosure,
> copying, distribution or use of this message or any of the information
> included in this message by you is unauthorized and strictly prohibited. If
> you have received this electronic transmission in error, please immediately
> and permanently delete this message and notify the sender by collect
> telephone call to +61 1300 874 926 or by reply to this e-mail message. Thank
> you.
>
>
>
>
> _______________________________________________
> 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/[email protected]
>
<<TrixanLogo.jpg>>
_______________________________________________ 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/[email protected]
