line |
stmt |
bran |
cond |
sub |
pod |
time |
code |
1
|
|
|
|
|
|
|
package DBR::Util::Operator; |
2
|
|
|
|
|
|
|
|
3
|
4
|
|
|
4
|
|
12215
|
use strict; |
|
4
|
|
|
|
|
13
|
|
|
4
|
|
|
|
|
183
|
|
4
|
4
|
|
|
4
|
|
26
|
use base 'Exporter'; |
|
4
|
|
|
|
|
11
|
|
|
4
|
|
|
|
|
497
|
|
5
|
|
|
|
|
|
|
our @EXPORT = qw(GT LT GE LE NOT LIKE NOTLIKE BETWEEN NOTBETWEEN AND OR); |
6
|
4
|
|
|
4
|
|
726
|
use DBR::Misc::General; # imported utils |
|
4
|
|
|
|
|
9
|
|
|
4
|
|
|
|
|
3026
|
|
7
|
|
|
|
|
|
|
|
8
|
|
|
|
|
|
|
# Object oriented |
9
|
|
|
|
|
|
|
sub new{ |
10
|
19
|
|
|
19
|
0
|
44
|
my $package = shift; |
11
|
19
|
|
|
|
|
42
|
my $operator = shift; |
12
|
19
|
|
|
|
|
33
|
my $value = shift; |
13
|
|
|
|
|
|
|
|
14
|
19
|
|
|
|
|
56
|
my $self = [$operator,$value]; |
15
|
19
|
|
|
|
|
82
|
bless ( $self, $package ); |
16
|
19
|
|
|
|
|
121
|
return ( $self ); |
17
|
|
|
|
|
|
|
} |
18
|
|
|
|
|
|
|
|
19
|
45
|
|
|
45
|
0
|
232
|
sub operator {$_[0]->[0]} |
20
|
37
|
|
|
37
|
0
|
167
|
sub value {$_[0]->[1]} |
21
|
70010
|
|
|
70010
|
0
|
273293
|
sub stringify{ 'OP-' . $_[0][0] . ':' . _expandstr( $_[0][1] ) } |
22
|
|
|
|
|
|
|
|
23
|
|
|
|
|
|
|
# EXPORTED: |
24
|
|
|
|
|
|
|
|
25
|
9
|
|
|
9
|
0
|
68
|
sub GT ($) { __PACKAGE__->new('gt', $_[0]) } |
26
|
0
|
|
|
0
|
0
|
0
|
sub LT ($) { __PACKAGE__->new('lt', $_[0]) } |
27
|
0
|
|
|
0
|
0
|
0
|
sub GE ($) { __PACKAGE__->new('ge', $_[0]) } |
28
|
0
|
|
|
0
|
0
|
0
|
sub LE ($) { __PACKAGE__->new('le', $_[0]) } |
29
|
2
|
|
|
2
|
0
|
17
|
sub NOT ($) { __PACKAGE__->new('not', $_[0]) } |
30
|
8
|
|
|
8
|
0
|
4026
|
sub LIKE ($) { __PACKAGE__->new('like',$_[0]) } |
31
|
0
|
|
|
0
|
0
|
0
|
sub NOTLIKE ($) { __PACKAGE__->new('notlike',$_[0]) } |
32
|
|
|
|
|
|
|
|
33
|
0
|
|
|
0
|
0
|
0
|
sub BETWEEN ($$) { __PACKAGE__->new('between', [ $_[0],$_[1] ]) } |
34
|
0
|
|
|
0
|
0
|
0
|
sub NOTBETWEEN ($$) { __PACKAGE__->new('notbetween',[ $_[0],$_[1] ]) } |
35
|
|
|
|
|
|
|
|
36
|
|
|
|
|
|
|
# Yes, having an AND operator is a little silly, |
37
|
|
|
|
|
|
|
# given that AND is the default operation, |
38
|
|
|
|
|
|
|
# but it's necessary to represent some of the more |
39
|
|
|
|
|
|
|
# esoteric queries out there now that OR is in the mix. |
40
|
|
|
|
|
|
|
# A AND (B OR C) is not equivelant to A AND B OR C |
41
|
|
|
|
|
|
|
sub AND { |
42
|
28
|
100
|
|
|
|
186
|
bless ([ |
43
|
|
|
|
|
|
|
'And', [ @_ ], |
44
|
11
|
100
|
|
11
|
0
|
1184
|
(scalar ( grep { !(ref($_) eq 'DBR::_LOP') || $_->operator eq 'And' } @_ ) == @_) ? 1 : 0, # calculate only_contains_and |
45
|
|
|
|
|
|
|
], 'DBR::_LOP'); |
46
|
|
|
|
|
|
|
} |
47
|
|
|
|
|
|
|
sub OR { |
48
|
28
|
100
|
|
|
|
186
|
bless ([ |
49
|
|
|
|
|
|
|
'Or', [ @_ ], |
50
|
11
|
100
|
|
11
|
0
|
43
|
(scalar ( grep { !(ref($_) eq 'DBR::_LOP') || $_->operator eq 'And' } @_ ) == @_) ? 1 : 0, # calculate only_contains_and |
51
|
|
|
|
|
|
|
], 'DBR::_LOP' ); |
52
|
|
|
|
|
|
|
} |
53
|
|
|
|
|
|
|
|
54
|
|
|
|
|
|
|
package DBR::_LOP; |
55
|
4
|
|
|
4
|
|
33
|
use base 'DBR::Util::Operator'; |
|
4
|
|
|
|
|
9
|
|
|
4
|
|
|
|
|
325
|
|
56
|
4
|
|
|
4
|
|
30
|
use DBR::Misc::General; # imported utils |
|
4
|
|
|
|
|
9
|
|
|
4
|
|
|
|
|
551
|
|
57
|
|
|
|
|
|
|
|
58
|
11
|
|
|
11
|
|
45
|
sub only_contains_and{ $_[0][2] } |
59
|
|
|
|
|
|
|
|
60
|
220000
|
|
|
220000
|
|
762450
|
sub stringify{ 'LOP-' . $_[0][0] . ':' . _expandstr( $_[0][1] ) } |
61
|
|
|
|
|
|
|
|
62
|
|
|
|
|
|
|
1; |