line |
stmt |
bran |
cond |
sub |
pod |
time |
code |
1
|
1
|
|
|
1
|
|
4
|
use strict; |
|
1
|
|
|
|
|
1
|
|
|
1
|
|
|
|
|
91
|
|
2
|
|
|
|
|
|
|
|
3
|
|
|
|
|
|
|
package LittleORM::Model; |
4
|
|
|
|
|
|
|
|
5
|
|
|
|
|
|
|
# Extend LittleORM::Model capabilities with clause support: |
6
|
|
|
|
|
|
|
|
7
|
|
|
|
|
|
|
sub clause |
8
|
|
|
|
|
|
|
{ |
9
|
0
|
|
|
0
|
0
|
|
my $self = shift; |
10
|
|
|
|
|
|
|
|
11
|
0
|
|
|
|
|
|
my @args = @_; |
12
|
|
|
|
|
|
|
|
13
|
0
|
|
0
|
|
|
|
my $class = ( ref( $self ) or $self ); |
14
|
|
|
|
|
|
|
|
15
|
0
|
|
|
|
|
|
my @clause_creation_args = ( model => $class, |
16
|
|
|
|
|
|
|
LittleORM::Clause -> __smart_clause_creation_args( @args ) ); |
17
|
|
|
|
|
|
|
|
18
|
0
|
|
|
|
|
|
return LittleORM::Clause -> new( @clause_creation_args ); |
19
|
|
|
|
|
|
|
} |
20
|
|
|
|
|
|
|
|
21
|
|
|
|
|
|
|
package LittleORM::Clause; |
22
|
|
|
|
|
|
|
|
23
|
1
|
|
|
1
|
|
4
|
use Moose; |
|
1
|
|
|
|
|
2
|
|
|
1
|
|
|
|
|
5
|
|
24
|
|
|
|
|
|
|
|
25
|
|
|
|
|
|
|
has 'logic' => ( is => 'rw', isa => 'Str', default => 'AND' ); |
26
|
|
|
|
|
|
|
has 'model' => ( is => 'rw', isa => 'Str', required => 1 ); |
27
|
|
|
|
|
|
|
has 'table_alias' => ( is => 'rw', isa => 'Maybe[Str]' ); |
28
|
|
|
|
|
|
|
has 'cond' => ( is => 'rw', isa => 'ArrayRef', default => sub { [] } ); |
29
|
|
|
|
|
|
|
|
30
|
1
|
|
|
1
|
|
5293
|
use Carp::Assert 'assert'; |
|
1
|
|
|
|
|
1
|
|
|
1
|
|
|
|
|
10
|
|
31
|
1
|
|
|
1
|
|
897
|
use Data::Dumper 'Dumper'; |
|
1
|
|
|
|
|
6266
|
|
|
1
|
|
|
|
|
386
|
|
32
|
|
|
|
|
|
|
|
33
|
|
|
|
|
|
|
sub __smart_clause_creation_args |
34
|
|
|
|
|
|
|
{ |
35
|
0
|
|
|
0
|
|
|
my $self = shift; |
36
|
0
|
|
|
|
|
|
my @args = @_; |
37
|
|
|
|
|
|
|
|
38
|
0
|
|
|
|
|
|
my %my_attrs = map { $_ -> name() => 1 } $self -> meta() -> get_all_attributes(); |
|
0
|
|
|
|
|
|
|
39
|
0
|
|
|
|
|
|
my @goes_into_cond = (); |
40
|
0
|
|
|
|
|
|
my @goes_as_is = (); |
41
|
0
|
|
|
|
|
|
my $seen_cond = 0; |
42
|
|
|
|
|
|
|
|
43
|
0
|
|
|
|
|
|
while( my $arg = shift @args ) |
44
|
|
|
|
|
|
|
{ |
45
|
0
|
|
|
|
|
|
my $value = shift @args; |
46
|
|
|
|
|
|
|
|
47
|
0
|
0
|
|
|
|
|
if( exists $my_attrs{ $arg } ) |
48
|
|
|
|
|
|
|
{ |
49
|
0
|
0
|
|
|
|
|
if( $arg eq 'cond' ) |
50
|
|
|
|
|
|
|
{ |
51
|
0
|
|
|
|
|
|
$seen_cond = 1; |
52
|
|
|
|
|
|
|
} |
53
|
|
|
|
|
|
|
|
54
|
0
|
|
|
|
|
|
push @goes_as_is, ( $arg => $value ); |
55
|
|
|
|
|
|
|
} else |
56
|
|
|
|
|
|
|
{ |
57
|
0
|
|
|
|
|
|
push @goes_into_cond, ( $arg => $value ); |
58
|
|
|
|
|
|
|
} |
59
|
|
|
|
|
|
|
} |
60
|
|
|
|
|
|
|
|
61
|
0
|
0
|
|
|
|
|
if( @goes_into_cond ) |
62
|
|
|
|
|
|
|
{ |
63
|
0
|
|
|
|
|
|
assert( ( $seen_cond == 0 ), |
64
|
|
|
|
|
|
|
'ambiguous clause creation arguments: ' . Dumper( \@args ) ); |
65
|
0
|
|
|
|
|
|
push @goes_as_is, ( cond => \@goes_into_cond ); |
66
|
|
|
|
|
|
|
} |
67
|
|
|
|
|
|
|
|
68
|
0
|
|
|
|
|
|
return @goes_as_is; |
69
|
|
|
|
|
|
|
} |
70
|
|
|
|
|
|
|
|
71
|
|
|
|
|
|
|
sub sql |
72
|
|
|
|
|
|
|
{ |
73
|
0
|
|
|
0
|
0
|
|
my $self = shift; |
74
|
|
|
|
|
|
|
|
75
|
0
|
|
|
|
|
|
my @rv = $self -> gen_clauses( &LittleORM::Model::__for_read(), # default, can be overwritten with following in @_ |
76
|
|
|
|
|
|
|
@_ ); |
77
|
|
|
|
|
|
|
|
78
|
0
|
|
|
|
|
|
return sprintf( ' ( %s ) ', join( ' '. $self -> logic() . ' ', @rv ) ); |
79
|
|
|
|
|
|
|
} |
80
|
|
|
|
|
|
|
|
81
|
|
|
|
|
|
|
sub gen_clauses |
82
|
|
|
|
|
|
|
{ |
83
|
0
|
|
|
0
|
0
|
|
my $self = shift; |
84
|
0
|
|
|
|
|
|
my @args = @_; |
85
|
|
|
|
|
|
|
|
86
|
0
|
|
|
|
|
|
my @rv = (); |
87
|
|
|
|
|
|
|
|
88
|
0
|
|
|
|
|
|
my @c = @{ $self -> cond() }; |
|
0
|
|
|
|
|
|
|
89
|
|
|
|
|
|
|
|
90
|
0
|
|
|
|
|
|
while( @c ) |
91
|
|
|
|
|
|
|
{ |
92
|
0
|
|
|
|
|
|
my $item = shift @c; |
93
|
|
|
|
|
|
|
|
94
|
0
|
0
|
|
|
|
|
if( ref( $item ) eq 'LittleORM::Clause' ) |
95
|
|
|
|
|
|
|
{ |
96
|
0
|
0
|
0
|
|
|
|
if( ( $item -> model() eq $self -> model() ) and ( my $ta = $self -> table_alias() ) and ( not $item -> table_alias() ) ) |
|
|
|
0
|
|
|
|
|
97
|
|
|
|
|
|
|
{ |
98
|
|
|
|
|
|
|
# copy obj ? |
99
|
0
|
|
|
|
|
|
my $copy = bless( { %{ $item } }, ref $item ); |
|
0
|
|
|
|
|
|
|
100
|
0
|
|
|
|
|
|
$item = $copy; |
101
|
0
|
|
|
|
|
|
$item -> table_alias( $ta ); |
102
|
|
|
|
|
|
|
} |
103
|
|
|
|
|
|
|
|
104
|
0
|
|
|
|
|
|
push @rv, $item -> sql(); |
105
|
|
|
|
|
|
|
} else |
106
|
|
|
|
|
|
|
{ |
107
|
0
|
|
|
|
|
|
my $value = shift @c; |
108
|
|
|
|
|
|
|
|
109
|
0
|
|
|
|
|
|
push @rv, $self -> model() -> __form_where( @args, |
110
|
|
|
|
|
|
|
$item => $value, |
111
|
|
|
|
|
|
|
_table_alias => $self -> table_alias() ); |
112
|
|
|
|
|
|
|
|
113
|
|
|
|
|
|
|
} |
114
|
|
|
|
|
|
|
} |
115
|
|
|
|
|
|
|
|
116
|
0
|
0
|
|
|
|
|
unless( @rv ) |
117
|
|
|
|
|
|
|
{ |
118
|
0
|
|
|
|
|
|
@rv = ( '2=2' ); |
119
|
|
|
|
|
|
|
} |
120
|
|
|
|
|
|
|
|
121
|
0
|
|
|
|
|
|
return @rv; |
122
|
|
|
|
|
|
|
|
123
|
|
|
|
|
|
|
} |
124
|
|
|
|
|
|
|
|
125
|
|
|
|
|
|
|
|
126
|
|
|
|
|
|
|
42; |