| 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__ |