line |
stmt |
bran |
cond |
sub |
pod |
time |
code |
1
|
|
|
|
|
|
|
package Fey::SQL::Intersect; |
2
|
|
|
|
|
|
|
|
3
|
27
|
|
|
27
|
|
152
|
use strict; |
|
27
|
|
|
|
|
44
|
|
|
27
|
|
|
|
|
1216
|
|
4
|
27
|
|
|
27
|
|
138
|
use warnings; |
|
27
|
|
|
|
|
46
|
|
|
27
|
|
|
|
|
912
|
|
5
|
27
|
|
|
27
|
|
131
|
use namespace::autoclean; |
|
27
|
|
|
|
|
48
|
|
|
27
|
|
|
|
|
286
|
|
6
|
|
|
|
|
|
|
|
7
|
|
|
|
|
|
|
our $VERSION = '0.43'; |
8
|
|
|
|
|
|
|
|
9
|
27
|
|
|
27
|
|
2971
|
use Moose 2.1200; |
|
27
|
|
|
|
|
794
|
|
|
27
|
|
|
|
|
257
|
|
10
|
|
|
|
|
|
|
|
11
|
|
|
|
|
|
|
with 'Fey::Role::SetOperation' => { keyword => 'INTERSECT' }; |
12
|
|
|
|
|
|
|
|
13
|
|
|
|
|
|
|
with 'Fey::Role::SQL::Cloneable'; |
14
|
|
|
|
|
|
|
|
15
|
|
|
|
|
|
|
1; |
16
|
|
|
|
|
|
|
|
17
|
|
|
|
|
|
|
# ABSTRACT: Represents an INTERSECT operation |
18
|
|
|
|
|
|
|
|
19
|
|
|
|
|
|
|
__END__ |
20
|
|
|
|
|
|
|
|
21
|
|
|
|
|
|
|
=pod |
22
|
|
|
|
|
|
|
|
23
|
|
|
|
|
|
|
=head1 NAME |
24
|
|
|
|
|
|
|
|
25
|
|
|
|
|
|
|
Fey::SQL::Intersect - Represents an INTERSECT operation |
26
|
|
|
|
|
|
|
|
27
|
|
|
|
|
|
|
=head1 VERSION |
28
|
|
|
|
|
|
|
|
29
|
|
|
|
|
|
|
version 0.43 |
30
|
|
|
|
|
|
|
|
31
|
|
|
|
|
|
|
=head1 SYNOPSIS |
32
|
|
|
|
|
|
|
|
33
|
|
|
|
|
|
|
my $intersect = Fey::SQL->new_intersect; |
34
|
|
|
|
|
|
|
|
35
|
|
|
|
|
|
|
$intersect->intersect( Fey::SQL->new_select->select(...), |
36
|
|
|
|
|
|
|
Fey::SQL->new_select->select(...), |
37
|
|
|
|
|
|
|
Fey::SQL->new_select->select(...), |
38
|
|
|
|
|
|
|
... |
39
|
|
|
|
|
|
|
); |
40
|
|
|
|
|
|
|
|
41
|
|
|
|
|
|
|
$intersect->order_by( $part_name, 'DESC' ); |
42
|
|
|
|
|
|
|
$intersect->limit(10); |
43
|
|
|
|
|
|
|
|
44
|
|
|
|
|
|
|
print $intersect->sql($dbh); |
45
|
|
|
|
|
|
|
|
46
|
|
|
|
|
|
|
=head1 DESCRIPTION |
47
|
|
|
|
|
|
|
|
48
|
|
|
|
|
|
|
This class represents an INTERSECT set operator. |
49
|
|
|
|
|
|
|
|
50
|
|
|
|
|
|
|
=head1 METHODS |
51
|
|
|
|
|
|
|
|
52
|
|
|
|
|
|
|
See L<Fey::Role::SetOperation> for all methods. |
53
|
|
|
|
|
|
|
|
54
|
|
|
|
|
|
|
=head1 ROLES |
55
|
|
|
|
|
|
|
|
56
|
|
|
|
|
|
|
=over 4 |
57
|
|
|
|
|
|
|
|
58
|
|
|
|
|
|
|
=item * L<Fey::Role::SetOperation> |
59
|
|
|
|
|
|
|
|
60
|
|
|
|
|
|
|
=item * L<Fey::Role::SQL::Cloneable> |
61
|
|
|
|
|
|
|
|
62
|
|
|
|
|
|
|
=back |
63
|
|
|
|
|
|
|
|
64
|
|
|
|
|
|
|
=head1 BUGS |
65
|
|
|
|
|
|
|
|
66
|
|
|
|
|
|
|
See L<Fey> for details on how to report bugs. |
67
|
|
|
|
|
|
|
|
68
|
|
|
|
|
|
|
=head1 AUTHOR |
69
|
|
|
|
|
|
|
|
70
|
|
|
|
|
|
|
Dave Rolsky <autarch@urth.org> |
71
|
|
|
|
|
|
|
|
72
|
|
|
|
|
|
|
=head1 COPYRIGHT AND LICENSE |
73
|
|
|
|
|
|
|
|
74
|
|
|
|
|
|
|
This software is Copyright (c) 2011 - 2015 by Dave Rolsky. |
75
|
|
|
|
|
|
|
|
76
|
|
|
|
|
|
|
This is free software, licensed under: |
77
|
|
|
|
|
|
|
|
78
|
|
|
|
|
|
|
The Artistic License 2.0 (GPL Compatible) |
79
|
|
|
|
|
|
|
|
80
|
|
|
|
|
|
|
=cut |