[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