1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
|
package DBIx::Class::Helper::ResultSet::Shortcut::ResultsExist;
$DBIx::Class::Helper::ResultSet::Shortcut::ResultsExist::VERSION = '2.037000';
use strict;
use warnings;
use parent 'DBIx::Class::ResultSet';
sub results_exist_as_query {
my ($self, $cond) = @_;
my $reified = $self->search_rs( $cond, {
columns => { _results_existence_check => \ '42' }
} )->as_query;
$$reified->[0] = "( SELECT EXISTS $$reified->[0] )";
$reified;
}
sub results_exist {
my ($self, $cond) = @_;
my $query = $self->results_exist_as_query($cond);
$$query->[0] .= ' AS _existence_subq';
my( undef, $sth ) = $self->result_source
->schema
->storage
->_select(
$query,
\'*',
{},
{},
);
$sth->fetchall_arrayref->[0][0] ? 1 : 0;
}
1;
__END__
=pod
=head1 NAME
DBIx::Class::Helper::ResultSet::Shortcut::ResultsExist
=head1 AUTHOR
Arthur Axel "fREW" Schmidt <frioux+cpan@gmail.com>
=head1 COPYRIGHT AND LICENSE
This software is copyright (c) 2024 by Arthur Axel "fREW" Schmidt.
This is free software; you can redistribute it and/or modify it under
the same terms as the Perl 5 programming language system itself.
=cut
|
