[Dbix-class] Query without schema

Jason Armstrong ja at riverdrums.com
Tue Mar 23 08:35:28 GMT 2010


I have a function in my database that I want to call without a table.

Ie, I want to issue the query:

   SELECT uuid.get_parent('663288c6-2cbf-11df-9818-7f00ea0e1477');

And not:

   SELECT uuid.get_parent('663288c6-2cbf-11df-9818-7f00ea0e1477') from
uuid.master;

My current code gives the latter query:

$schema->resultset('UuidMaster')->search(
             {},
             { select => [ { 'uuid.get_parent' => "'$uuid'" } ],
               as => [qw(top)],
             });

-- 
Jason Armstrong



More information about the DBIx-Class mailing list