[Dbix-class] Query without schema

[kevin montuori]

On Tue, Mar 23, 2010 at 4:35 AM, Jason Armstrong <ja at riverdrums.com> wrote:
> I have a function in my database that I want to call without a table.

I use a virtual result source for this:

  package MyApp::Schema::Result::Parent;

  use strict;
  use parent 'DBIx::Class::Core';

  __PACKAGE__->table_class('DBIx::Class::ResultSource::View');

  __PACKAGE__->table('null');
  __PACKAGE__->add_columns(qw[ parent ]);

  __PACKAGE__->result_source_instance->is_virtual(1);
  __PACKAGE__->result_source_instance->view_definition(q[
            SELECT uuid.get_parent(?)
  ]);

  1;

and then

  $schema->resultset('Parent')->search( {}, { bind => [$uuid] });

If memory serves (and it often does not), the ResultSource::View is a
relatively recent thing.

k.


-- 
kevin montuori