| 1 | package Business::BancaSella::Ric::Mysql; | ||
| 2 | |||
| 3 | $VERSION = "0.11"; | ||
| 4 | sub Version { $VERSION; } | ||
| 5 | require 5.004; | ||
| 6 | use strict; | ||
| 7 | use Carp; | ||
| 8 | |||
| 9 | my %fields = | ||
| 10 | ( | ||
| 11 | dbh => undef, | ||
| 12 | tableName => undef, | ||
| 13 | fieldName => undef, | ||
| 14 | ); | ||
| 15 | |||
| 16 | my @fields_req = qw/dbh tableName fieldName/; | ||
| 17 | |||
| 18 | |||
| 19 | sub new | ||
| 20 | { | ||
| 21 | my $proto = shift; | ||
| 22 | my $class = ref($proto) || $proto; | ||
| 23 | my $self = {}; | ||
| 24 | bless $self,$class; | ||
| 25 | $self->init(@_); | ||
| 26 | return $self; | ||
| 27 | } | ||
| 28 | |||
| 29 | sub init { | ||
| 30 | my $self = shift; | ||
| 31 | my (%options) = @_; | ||
| 32 | # Assign default options | ||
| 33 | while (my ($key,$value) = each(%fields)) { | ||
| 34 | $self->{$key} = $self->{$key} || $value; | ||
| 35 | } | ||
| 36 | # Assign options | ||
| 37 | while (my ($key,$value) = each(%options)) { | ||
| 38 | $self->{$key} = $value | ||
| 39 | } | ||
| 40 | # Check required params | ||
| 41 | foreach (@fields_req) { | ||
| 42 | croak "You must declare '$_' in " . ref($self) . "::new" | ||
| 43 | if (!defined $self->{$_}); | ||
| 44 | } | ||
| 45 | } | ||
| 46 | |||
| 47 | sub extract { | ||
| 48 | my $self = shift; | ||
| 49 | # get first Ric password | ||
| 50 | my $sql = 'select ' . $self->fieldName . ' from ' . $self->tableName . | ||
| 51 | ' limit 1'; | ||
| 52 | my @ret = $self->dbh->selectrow_array($sql) or | ||
| 53 | croak "Unable to execute $sql"; | ||
| 54 | if (@ret) { | ||
| 55 | # remove Ric password from Ric Table. | ||
| 56 | $sql = 'delete from ' . $self->tableName . ' where ' . | ||
| 57 | $self->fieldName . " = '" . $ret[0] . "'"; | ||
| 58 | $self->dbh->do($sql) or croak "Unable to execute $sql"; | ||
| 59 | return $ret[0]; | ||
| 60 | } else { | ||
| 61 | return undef; | ||
| 62 | } | ||
| 63 | } | ||
| 64 | |||
| 65 | sub prepare { | ||
| 66 | my ($self,$source_file) = @_; | ||
| 67 | # read the passwords | ||
| 68 | open(SOURCE,"<$source_file") || croak "SYSTEM. opening $source_file : $!\n"; | ||
| 69 | my @rows = <SOURCE>; | ||
| 70 | if ( $! ) { | ||
| 71 | croak "SYSTEM. reading $source_file : $!\n"; | ||
| 72 | } | ||
| 73 | close(SOURCE) || croak "SYSTEM. closing $source_file : $!\n"; | ||
| 74 | |||
| 75 | # verify the passwords | ||
| 76 | my @passwords = (); | ||
| 77 | my $line = 1; | ||
| 78 | foreach my $row ( @rows ) { | ||
| 79 | unless ( $row =~ /^([a-zA-Z0-9]{32})\n+$/ ) { | ||
| 80 | croak "CORRUPT. file $source_file corrupted at line $line\n"; | ||
| 81 | } | ||
| 82 | push @passwords, ($1); | ||
| 83 | } | ||
| 84 | # build insert string | ||
| 85 | my $sql = "INSERT INTO " . $self->{tableName} . " (" . $self->{fieldName} . | ||
| 86 | ") VALUES \n"; | ||
| 87 | foreach (@passwords) { | ||
| 88 | $sql .= "('$_'),\n"; | ||
| 89 | } | ||
| 90 | # remove last ",\n" | ||
| 91 | chomp($sql);chop($sql); | ||
| 92 | $self->{dbh}->do($sql) or croak "Unable to execute " . substr($sql,0,200). "..."; | ||
| 93 | } | ||
| 94 | |||
| 95 | sub dbh { my $s=shift; return @_ ? ($s->{dbh}=shift) : $s->{dbh} } | ||
| 96 | sub tableName { my $s=shift; return @_ ? ($s->{tableName}=shift) : $s->{tableName} } | ||
| 97 | sub fieldName { my $s=shift; return @_ ? ($s->{fieldName}=shift) : $s->{fieldName} } | ||
| 98 | |||
| 99 | |||
| 100 | 1; | ||
| 101 | __END__ |