Filtering DBIx::Class resultsets with external criteria


No such thing as a small change
	PerlMonks

Filtering DBIx::Class resultsets with external criteria

by Ovid (Cardinal)

on Nov 07, 2008 at 09:06 UTC ( #722180=perlquestion: print w/ replies, xml )

Need Help??

Ovid has asked for the wisdom of the Perl Monks concerning the following question:

Using DBIx::Class and I have a resultset which needs to be filtered by data which cannot be generated by SQL. What I need to do is something effectively equivalent to this hypothetical example:

    my $resultset     = $schema->resultset('Service')->search(\%search
+);
    my $new_resultset = $resultset->filter( sub {
        my $web_service = shift;
        return $web_service->is_available;
    } );
[download]

Reading through the docs gives me no clue how to accomplish a strategy like this.

Cheers,
Ovid

The official Perl 6 wiki.

Comment on Filtering DBIx::Class resultsets with external criteria Download Code
Re: Filtering DBIx::Class resultsets with external criteria by arc_of_descent (Hermit) on Nov 09, 2008 at 04:46 UTC
Can't you just do something like this: `my $resultset = grep { WS->new($_->id)->is_available; } $schema->resultset('Service')->search(\%search);` [download] update Not sure of how $web_service is linked to your app. I guess I'm trying to say that I utilize grep for simple filters. -- Rohan	[reply] [d/l]

Back to Seekers of Perl Wisdom

Node Status^?

node history
Node Type: perlquestion [id://722180]
Approved by Arunbear
Front-paged by grinder
help

Chatterbox^?

How do I use this? | Other CB clients

Other Users^?

Others surveying the Monastery: (7)

As of 2013-05-18 11:41 GMT

Sections^?

Information^?

Find Nodes^?

Leftovers^?

Voting Booth^?

The best material for plates (tableware) is:

Results (392 votes), past polls