| 1 | package DBIx::Compare::Oracle; | ||
| 2 | |||
| 3 | use 5.006; | ||
| 4 | use strict; | ||
| 5 | use warnings; | ||
| 6 | require DBIx::Compare; | ||
| 7 | |||
| 8 | our $VERSION = '1.1'; | ||
| 9 | |||
| 10 | { package oracle_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(LENGTHB($field)), STDDEV(LENGTHB($field)), MIN(LENGTHB($field)), MAX(LENGTHB($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), STDDEV($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,$table,$field) = @_; | ||
| 32 | my $statement = " | ||
| 33 | SELECT AVG(TO_NUMBER($field)), STDDEV(TO_NUMBER($field)), MIN(TO_NUMBER($field)), MAX(TO_NUMBER($field)) | ||
| 34 | FROM $table | ||
| 35 | "; | ||
| 36 | return $self->do_compare_field($statement); | ||
| 37 | } | ||
| 38 | } | ||
| 39 | |||
| 40 | 1; | ||
| 41 | |||
| 42 | __END__ |