BancaSella/Ric/Mysql.pm untested

filter: Statementstmt 0.0% 0 / 62 Branchbran 0.0% 0 / 14 Conditioncond 0.0% 0 / 16 MC/DCmcdc 0.0% 0 / 9 Subroutinesub 0.0% 0 / 11 Podpod 0.0% 0 / 8 totaltotal 0.0% 0 / 120 CC 8 SCAR 17.7
CC
8
Cov
0%
prepare
12.0
init
6.0
extract
6.0
CRAP 5.9
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__