Compare/SQLite.pm untested

filter: Statementstmt 0.0% 0 / 25 Branchbran n/a Conditioncond n/a MC/DCmcdc n/a Subroutinesub 0.0% 0 / 7 Podpod 0.0% 0 / 3 totaltotal 0.0% 0 / 35 CC 1 SCAR 6.9
CC
1
Cov
0%
compare_string_field
2.0
compare_numeric_field
2.0
compare_datetime_field
2.0
CRAP 2.0
1 package DBIx::Compare::SQLite;
2  
3 use 5.006;
4 use strict;
5 use warnings;
6 require DBIx::Compare;
7  
8 our $VERSION = '1.1';
9  
10 { package sqlite_comparison;
11  
12 our @ISA = qw( db_comparison );
13  
14 sub compare_string_field {
15 my ($self,$table,$field) = @_;
16 my $statement = "
17 SELECT AVG(LENGTH($field)), MIN(LENGTH($field)), MAX(LENGTH($field))
18 FROM $table
19 ";
20 return $self->do_compare_field($statement);
21 }
22 sub compare_numeric_field {
23 my ($self,$table,$field) = @_;
24 my $statement = "
25 SELECT AVG($field), MIN($field), MAX($field)
26 FROM $table
27 ";
28 return $self->do_compare_field($statement);
29 }
30 sub compare_datetime_field {
31 my $self = shift;
32 $self->add_errors("Could not compare date/time field types");
33 return 1;
34 }
35 }
36  
37 1;
38  
39 __END__