BancaSella/Ris/Mysql.pm untested

filter: Statementstmt 0.0% 0 / 72 Branchbran 0.0% 0 / 18 Conditioncond 0.0% 0 / 14 MC/DCmcdc 0.0% 0 / 8 Subroutinesub 0.0% 0 / 14 Podpod 0.0% 0 / 10 totaltotal 0.0% 0 / 136 CC 10 SCAR 17.5
CC
10
Cov
0%
prepare
12.0
init
6.0
check
6.0
CRAP 5.7
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__