lib/DB/Object/Query/Element.pm

filter: Statementstmt 41.9% 52 / 124 Branchbran 5.7% 3 / 52 Conditioncond 5.3% 3 / 56 MC/DCmcdc 0.0% 0 / 29 Subroutinesub 53.5% 15 / 28 Podpod 77.7% 14 / 18 totaltotal 28.3% 87 / 307 CC 49 SCAR 40.5
CC
49
Cov
25%
fo
132.0
THAW
110.0
attach
90.0
CRAP 57.3
« lib/DB/Object/Fields.pm ↑ Summary lib/DB/Object/Constraint/Check.pm »
1 ##----------------------------------------------------------------------------
2 ## Database Object Interface - ~/lib/DB/Object/Query/Element.pm
3 ## Version v0.3.1
4 ## Copyright(c) 2026 DEGUEST Pte. Ltd.
5 ## Author: Jacques Deguest <jack@deguest.jp>
6 ## Created 2023/07/08
7 ## Modified 2026/03/22
8 ## All rights reserved
9 ##
10 ## This program is free software; you can redistribute it and/or modify it
11 ## under the same terms as Perl itself.
12 ##----------------------------------------------------------------------------
13 package DB::Object::Query::Element;
14 BEGIN
15 5 ▶{
Subroutine BEGIN: called CC=1 SCAR=0.0
16 5 ▶ use strict;
Subroutine BEGIN: called CC=1 SCAR=0.0
17 5 ▶ use common::sense;
Subroutine BEGIN: called CC=1 SCAR=0.0
18 5 warnings::register_categories( 'DB::Object' );
19 5 ▶ use parent qw( Module::Generic );
Subroutine BEGIN: called CC=1 SCAR=0.0
20 5 ▶ use vars qw( $VERSION $EXCEPTION_CLASS );
Subroutine BEGIN: called CC=1 SCAR=0.0
21 5 our $EXCEPTION_CLASS = $DB::Object::EXCEPTION_CLASS;
22 5 ▶ use Wanted;
Subroutine BEGIN: called CC=1 SCAR=0.0
23 5 our $VERSION = 'v0.3.1';
24 };
25  
26 5 ▶use strict;
Subroutine BEGIN: called CC=1 SCAR=0.0
27 5 ▶use warnings;
Subroutine BEGIN: called CC=1 SCAR=0.0
28  
29 sub init
30 21 ▶{
Subroutine init: called CC=2 SCAR=6.9
Pod documented
31 21 my $self = shift( @_ );
32 21 $self->{as_is} = undef;
33 21 $self->{field} = undef;
34 21 $self->{format} = undef;
35 21 $self->{index} = undef;
36 21 $self->{is_numbered} = 0;
37 21 $self->{placeholder} = undef;
38 21 $self->{query_object} = undef;
39 21 $self->{type} = undef;
40 21 $self->{value} = undef;
41 21 $self->{_init_strict_use_sub} = 1;
42 21 $self->{_init_params_order} = [qw( query_object field placeholder format type value index )];
43 21 $self->{_exception_class} = $EXCEPTION_CLASS;
44 21 ▶ $self->SUPER::init( @_ ) || return( $self->pass_error );
Branch: 1 branch
BranchTrueFalseTotal
$self->SUPER::init(@_) or return $self->pass_error 21 0 21
45 21 $self->{_fields} = [qw(
46 as_is field format index is_numbered placeholder type value
47 )];
48 21 return( $self );
49 }
50  
51 0 ▶sub as_is { return( shift->_set_get_boolean( 'as_is', @_ ) ); }
Subroutine as_is: not called CC=1 SCAR=6.9
Pod documented
52  
53 sub attach
54 0 ▶{
Subroutine attach: not called CC=9 SCAR=45.0
Pod documented
55 0 my $self = shift( @_ );
56 0 ▶ my $elems = shift( @_ ) ||
Condition0%0/2
shift @_ || (return $self->error('No DB::Object::Query::Elements object was provided.'))
l!l
00
MC/DC0%0/1
shift @_ || (return $self->error('No DB::Object::Query::Elements object was provided.'))
shift @_
Truth table0%0/2
A
A= shift @_
Aresult
11
00
57 return( $self->error( "No DB::Object::Query::Elements object was provided." ) );
58 0 ▶ unless( $self->_is_a( $elems => 'DB::Object::Query::Elements' ) )
Branch: 1 branch
BranchTrueFalseTotal
unless ($self->_is_a($elems, "DB::Object::Query::Elements")) 0 0 0
59 {
60 0 return( $self->error( "Value provided is not a DB::Object::Query::Elements object." ) );
61 }
62 0 ▶ $self->elements( $elems ) || return( $self->pass_error );
Branch: 1 branch
BranchTrueFalseTotal
$self->elements($elems) or return $self->pass_error 0 0 0
63 0 $self->debug( $elems->debug );
64 0 ▶ if( my $qo = $elems->query_object )
Branch: 1 branch
BranchTrueFalseTotal
if (my $qo = $elems->query_object) 0 0 0
65 {
66 0 ▶ $self->query_object( $qo ) || return( $self->pass_error );
Branch: 1 branch
BranchTrueFalseTotal
$self->query_object($qo) or return $self->pass_error 0 0 0
67 0 my $tbl = $qo->table_object;
68 0 my $field = $self->fo;
69 0 ▶ if( $field && $tbl )
Branch: 1 branch
BranchTrueFalseTotal
if ($field and $tbl) 0 0 0
Condition0%0/3
$field and $tbl
!ll&&!rl&&r
000
MC/DC0%0/2
$field and $tbl
$field $tbl
Truth table0%0/3
A and B
A= $fieldB= $tbl
ABresult
0X0
100
111
70 {
71 0 ▶ $field->attach( $tbl ) || return( $self->pass_error( $field->error ) );
Branch: 1 branch
BranchTrueFalseTotal
$field->attach($tbl) or return $self->pass_error($field->error) 0 0 0
72 }
73 }
74 0 return( $self );
75 }
76  
77 0 ▶sub elements { return( shift->_set_get_object_without_init( 'elements', 'DB::Object::Query::Elements', @_ ) ); }
Subroutine elements: not called CC=1 SCAR=6.9
Pod documented
78  
79 # The field name
80 20 ▶sub field { return( shift->_set_get_scalar_or_object( 'field', 'DB::Object::Fields::Field', @_ ) ); }
Subroutine field: called CC=1 SCAR=0.0
Pod documented
81  
82 sub fo
83 0 ▶{
Subroutine fo: not called CC=11 SCAR=48.8
Pod documented
84 0 my $self = shift( @_ );
85 0 ▶ if( @_ )
Branch: 1 branch
BranchTrueFalseTotal
if (@_) 0 0 0
86 {
87 0 ▶ return( $self->error( "Value provided for method fo() in class ", ref( $self ), " is not a DB::Object::Fields::Field object." ) ) if( !$self->_is_a( $_[0] => 'DB::Object::Fields::Field' ) );
Branch: 1 branch
BranchTrueFalseTotal
unless $self->_is_a($_[0], "DB::Object::Fields::Field") 0 0 0
88 0 $self->{fo} = shift( @_ );
89 }
90 0 ▶ return( $self->{fo} ) if( $self->{fo} );
Branch: 1 branch
BranchTrueFalseTotal
if $self->{"fo"} 0 0 0
91 0 my $f = $self->field;
92 0 my $fo;
93 0 ▶ if( $self->_is_a( $f => 'DB::Object::Fields::Field' ) )
Branch: 2 branches
BranchTrueFalseTotal
if ($self->_is_a($f, 'DB::Object::Fields::Field')) { } 0 0 0
elsif (defined $f and length($f // '')) { } 0 0 0
94 {
95 0 $fo = $f;
96 }
97 ▶ elsif( defined( $f ) && CORE::length( $f // '' ) )
Condition0%0/5
defined $f and length($f // "")
!ll&&!rl&&r
000
$f // ""
l!l
00
MC/DC0%0/2
defined $f and length($f // "")
defined $f $f
Truth table0%0/3
A and B
A= defined $fB= $f
ABresult
0X0
100
111
98 {
99 0 $fo = $self->query_object->table_object->fields( $f );
100 }
101 0 ▶ $self->{fo} = $fo if( defined( $fo ) );
Branch: 1 branch
BranchTrueFalseTotal
if defined $fo 0 0 0
102 0 ▶ return( $self->new_null ) if( !defined( $fo ) && Wanted::want( 'OBJECT' ) );
Branch: 1 branch
BranchTrueFalseTotal
if not defined $fo and Wanted::want("OBJECT") 0 0 0
Condition0%0/3
not defined $fo and Wanted::want("OBJECT")
!ll&&!rl&&r
000
MC/DC0%0/2
not defined $fo and Wanted::want("OBJECT")
not defined $fo Wanted::want("OBJECT")
Truth table0%0/3
not(A) and B
A= not defined $foB= Wanted::want("OBJECT")
ABresult
0X0
100
111
103 0 return( $fo );
104 }
105  
106 # The formatting for insert, e.g.: field = value, or possibly field = ?, or even field = $1
107 0 ▶sub format { return( shift->_set_get_scalar_as_object( 'format', @_ ) ); }
Subroutine format: not called CC=1 SCAR=6.9
Pod documented
108  
109 # The generic representation of this element if we want to bind data to it
110 0 ▶sub generic { return( shift->_set_get_scalar_as_object( 'generic', @_ ) ); }
Subroutine generic: not called CC=1 SCAR=6.9
Pod documented
111  
112 # If this is a numbered placeholder
113 1 ▶sub index { return( shift->_set_get_number( { field => 'index', undef_ok => 1 }, @_ ) ); }
Subroutine index: called CC=1 SCAR=0.0
Pod documented
114  
115 # sub is_numbered { return( shift->_set_get_boolean( 'is_numbered', @_ ) ); }
116 sub is_numbered
117 0 ▶{
Subroutine is_numbered: not called CC=4 SCAR=30.0
Pod documented
118 0 my $self = shift( @_ );
119 0 my $placeholder = $self->placeholder;
120 0 ▶ return(0) if( !defined( $placeholder ) );
Branch: 1 branch
BranchTrueFalseTotal
unless defined $placeholder 0 0 0
121 0 my $placeholder_re = $self->query_object->database_object->_placeholder_regexp;
122 0 ▶ if( $placeholder =~ /^$placeholder_re$/ && defined( $+{index} ) )
Branch: 1 branch
BranchTrueFalseTotal
if ($placeholder =~ /^$placeholder_re$/ and defined $+{"index"}) 0 0 0
Condition0%0/3
$placeholder =~ /^$placeholder_re$/ and defined $+{"index"}
!ll&&!rl&&r
000
MC/DC0%0/2
$placeholder =~ /^$placeholder_re$/ and defined $+{"index"}
$placeholder =~ /^$placeholder_re$/ defined $+{"index"}
Truth table0%0/3
A and B
A= $placeholder =~ /^$placeholder_re$/B= defined $+{"index"}
ABresult
0X0
100
111
123 {
124 0 return(1);
125 }
126 0 return(0);
127 }
128  
129 # The placeholder, such as ?, $2, ?2, or others supported by the driver
130 1 ▶sub placeholder { return( shift->_set_get_scalar_as_object({
Subroutine placeholder: called CC=1 SCAR=0.8
Pod documented
131 field => 'placeholder',
132 callbacks =>
133 {
134 set => sub
135 1 ▶ {
Subroutine __ANON__: called CC=6 SCAR=22.3
136 # $val is a scalar object (Module::Generic::Scalar)
137 1 my( $self, $val ) = @_;
138 1 my $placeholder_re = $self->query_object->database_object->_placeholder_regexp;
139 1 ▶ return( $val ) if( $self->_is_scalar( $val ) && $self->_can( $val => 'defined' ) && !$val->defined );
Branch: 1 branch
BranchTrueFalseTotal
if $self->_is_scalar($val) and $self->_can($val, "defined") and not $val->defined 0 1 1
Condition33%2/6
$self->_is_scalar($val) and $self->_can($val, "defined") and not $val->defined
!ll&&!rl&&r
010
$self->_is_scalar($val) and $self->_can($val, "defined")
!ll&&!rl&&r
001
MC/DC0%0/3
$self->_is_scalar($val) and $self->_can($val, "defined") and not $val->defined
$self->_is_scalar($val) $self->_can($val, "defined") not $val->defined
Truth table25%1/4
A and B and not(C)
A= $self->_is_scalar($val)B= $self->_can($val, "defined")C= not $val->defined
ABCresult
0XX0
10X0
1100
1111
140 1 ▶ if( defined( $val ) && "$val" =~ /^(?:$placeholder_re)$/ )
Branch: 1 branch
BranchTrueFalseTotal
if (defined $val and "$val" =~ /^(?:$placeholder_re)$/) { } 1 0 1
Condition33%1/3
defined $val and "$val" =~ /^(?:$placeholder_re)$/
!ll&&!rl&&r
001
MC/DC0%0/2
defined $val and "$val" =~ /^(?:$placeholder_re)$/
defined $val "$val" =~ /^(?:$placeholder_re)$/
Truth table33%1/3
A and B
A= defined $valB= "$val" =~ /^(?:$placeholder_re)$/
ABresult
0X0
100
111
141 {
142 # Could be undef
143 1 $self->index( $+{index} );
144 }
145 else
146 {
147 0 $self->index( undef );
148 }
149 1 return( $val );
150 }
151 }
152 1 }, @_ ) ); }
153  
154 21 ▶sub query_object { return( shift->_set_get_object( 'query_object', 'DB::Object::Query', @_ ) ); }
Subroutine query_object: called CC=1 SCAR=0.0
Pod documented
155  
156 # The field data type to be used when binding parameters
157 # sub type { return( shift->_set_get_scalar_as_object( 'type', @_ ) ); }
158 0 ▶sub type { return( shift->_set_get_scalar_as_object( { field => 'type', callbacks =>
Subroutine type: not called CC=1 SCAR=6.9
Pod documented
159 {
160 get => sub
161 0 ▶ {
Subroutine __ANON__: not called CC=6 SCAR=37.4
162 0 my( $self, $val ) = @_;
163 0 my $field = $self->field;
164 0 ▶ if( ( !defined( $val ) || !$val->defined || !CORE::length( $val // '' ) ) &&
Branch: 1 branch
BranchTrueFalseTotal
if (not defined $val && $val->defined && length($val // "") and $self->_is_a($field, "DB::Object::Fields::Field")) 0 0 0
Condition0%0/11
not defined $val && $val->defined && length($val // "") and $self->_is_a($field, "DB::Object::Fields::Field")
!ll&&!rl&&r
000
defined $val && $val->defined && length($val // '')
!ll&&!rl&&r
000
defined $val and $val->defined
!ll&&!rl&&r
000
$val // ""
l!l
00
MC/DC0%0/4
not defined $val && $val->defined && length($val // "") and $self->_is_a($field, "DB::Object::Fields::Field")
defined $val $val->defined $val $self->_is_a($field, "DB::Object::Fields::Field")
Truth table0%0/7
not(A and B && C) and D
A= defined $valB= $val->definedC= $valD= $self->_is_a($field, "DB::Object::Fields::Field")
ABCDresult
111X0
0XX00
10X00
11000
0XX11
10X11
11011
165 $self->_is_a( $field => 'DB::Object::Fields::Field' ) )
166 {
167 0 $val = $field->datatype->constant;
168 }
169 0 return( $val );
170 }
171 0 }}, @_ ) ); }
172  
173 # The value to bind, if any at all. So could be undef
174 17 ▶sub value { return( shift->_set_get_scalar_as_object( 'value', @_ ) ); }
Subroutine value: called CC=1 SCAR=0.0
Pod documented
175  
176 sub FREEZE
177 0 ▶{
Subroutine FREEZE: not called CC=8 SCAR=42.8
Pod undocumented
178 0 my $self = CORE::shift( @_ );
179 0 ▶ my $serialiser = CORE::shift( @_ ) // '';
Condition0%0/2
shift @_ // ""
l!l
00
MC/DC0%0/1
shift @_ // ""
shift @_
Truth table0%0/2
A
A= shift @_
Aresult
11
00
180 0 my $class = CORE::ref( $self );
181  
182 # We keep a strict allow-list to avoid accidentally freezing DBI handles or other
183 # process-local state.
184 0 my @props = @{$self->{_fields}};
185  
186 0 my $hash = {};
187 0 foreach my $prop ( @props )
188 {
189 0 ▶ if( CORE::exists( $self->{ $prop } ) &&
Branch: 1 branch
BranchTrueFalseTotal
if (exists $self->{$prop} and defined $self->{$prop} and ref $self->{$prop} ne "CODE") 0 0 0
Condition0%0/6
exists $self->{$prop} and defined $self->{$prop} and ref $self->{$prop} ne "CODE"
!ll&&!rl&&r
000
exists $self->{$prop} and defined $self->{$prop}
!ll&&!rl&&r
000
MC/DC0%0/3
exists $self->{$prop} and defined $self->{$prop} and ref $self->{$prop} ne "CODE"
exists $self->{$prop} defined $self->{$prop} ref $self->{$prop} ne "CODE"
Truth table0%0/4
A and B and C
A= exists $self->{$prop}B= defined $self->{$prop}C= ref $self->{$prop} ne "CODE"
ABCresult
0XX0
10X0
1100
1111
190 defined( $self->{ $prop } ) &&
191 CORE::ref( $self->{ $prop } ) ne 'CODE' )
192 {
193 0 $hash->{ $prop } = $self->{ $prop };
194 }
195 }
196  
197 # Return an array reference rather than a list so this works with Sereal and CBOR.
198 # Before Sereal version 4.023, Sereal did not support multiple values returned.
199 0 ▶ if( $serialiser eq 'Sereal' )
Branch: 1 branch
BranchTrueFalseTotal
if ($serialiser eq "Sereal") 0 0 0
200 {
201 0 require Sereal::Encoder;
202 0 require version;
203  
204 0 ▶ if( version->parse( Sereal::Encoder->VERSION ) < version->parse( '4.023' ) )
Branch: 1 branch
BranchTrueFalseTotal
if ("version"->parse("Sereal::Encoder"->VERSION) < "version"->parse("4.023")) 0 0 0
205 {
206 0 CORE::return( [$class, $hash] );
207 }
208 }
209  
210 # But Storable wants a list with the first element being the serialised element
211 0 CORE::return( $class, $hash );
212 }
213  
214 0 ▶sub STORABLE_freeze { return( shift->FREEZE( @_ ) ); }
Subroutine STORABLE_freeze: not called CC=1 SCAR=6.9
Pod undocumented
215  
216 0 ▶sub STORABLE_thaw { return( shift->THAW( @_ ) ); }
Subroutine STORABLE_thaw: not called CC=1 SCAR=6.9
Pod undocumented
217  
218 sub THAW
219 0 ▶{
Subroutine THAW: not called CC=10 SCAR=47.0
Pod undocumented
220 # STORABLE_thaw would issue $cloning as the 2nd argument, while CBOR would issue
221 # 'CBOR' as the second value.
222 0 my( $self, undef, @args ) = @_;
223 0 ▶ my $ref = ( CORE::scalar( @args ) == 1 && CORE::ref( $args[0] ) eq 'ARRAY' ) ? CORE::shift( @args ) : \@args;
Branch: 1 branch
BranchTrueFalseTotal
scalar @args == 1 && ref $args[0] eq 'ARRAY' ? : 0 0 0
Condition0%0/3
scalar @args == 1 and ref $args[0] eq "ARRAY"
!ll&&!rl&&r
000
MC/DC0%0/2
scalar @args == 1 and ref $args[0] eq "ARRAY"
scalar @args == 1 ref $args[0] eq "ARRAY"
Truth table0%0/3
A and B
A= scalar @args == 1B= ref $args[0] eq "ARRAY"
ABresult
0X0
100
111
224 0 ▶ my $class = ( CORE::defined( $ref ) && CORE::ref( $ref ) eq 'ARRAY' && CORE::scalar( @$ref ) > 1 ) ? CORE::shift( @$ref ) : ( CORE::ref( $self ) || $self );
Branch: 1 branch
BranchTrueFalseTotal
defined $ref && ref $ref eq 'ARRAY' && scalar @$ref > 1 ? : 0 0 0
Condition0%0/9
defined $ref and ref $ref eq "ARRAY" and scalar @$ref > 1
!ll&&!rl&&r
000
defined $ref and ref $ref eq "ARRAY"
!ll&&!rl&&r
000
ref $self or $self
l!l&&r!l&&!r
000
MC/DC0%0/3
defined $ref and ref $ref eq "ARRAY" and scalar @$ref > 1
defined $ref ref $ref eq "ARRAY" scalar @$ref > 1
MC/DC0%0/2
ref $self or $self
ref $self $self
Truth table0%0/4
A and B and C
A= defined $refB= ref $ref eq "ARRAY"C= scalar @$ref > 1
ABCresult
0XX0
10X0
1100
1111
Truth table0%0/3
A or B
A= ref $selfB= $self
ABresult
1X1
011
000
225 0 ▶ my $hash = CORE::ref( $ref ) eq 'ARRAY' ? CORE::shift( @$ref ) : {};
Branch: 1 branch
BranchTrueFalseTotal
ref $ref eq 'ARRAY' ? : 0 0 0
226 0 my $new;
227 # Storable pattern requires to modify the object it created rather than returning a new one
228 0 ▶ if( CORE::ref( $self ) )
Branch: 1 branch
BranchTrueFalseTotal
if (ref $self) { } 0 0 0
229 {
230 0 foreach( CORE::keys( %$hash ) )
231 {
232 0 $self->{ $_ } = CORE::delete( $hash->{ $_ } );
233 }
234 0 $new = $self;
235 }
236 else
237 {
238 0 $new = CORE::bless( $hash => $class );
239 }
240 0 CORE::return( $new );
241 }
242  
243 5 1;
244 # NOTE: POD
245 __END__
« lib/DB/Object/Fields.pm ↑ Summary lib/DB/Object/Constraint/Check.pm »