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