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