blib/lib/AutoSQL/DBSQL/DBContext.pm untested

filter: Statementstmt 0.0% 0 / 52 Branchbran 0.0% 0 / 4 Conditioncond 0.0% 0 / 14 MC/DCmcdc 0.0% 0 / 8 Subroutinesub 0.0% 0 / 10 Podpod 0.0% 0 / 6 totaltotal 0.0% 0 / 94 CC 3 SCAR 12.0
CC
3
Cov
0%
db_handle
6.0
_host_locator
6.0
_initialize
2.0
CRAP 3.3
1 package AutoSQL::DBSQL::DBContext;
2 use strict;
3 use DBI;
4 use AutoCode::Root;
5 our @ISA=qw(AutoCode::Root);
6 use AutoCode::AccessorMaker ('$' => [qw(dbname host user pass port driver)]);
7  
8 sub _initialize {
9 my ($self, @args)=@_;
10 my ($dbname, $host, $user, $pass, $driver, $port) =
11 $self->_rearrange([qw(DBNAME HOST USER PASS DRIVER PORT)], @args);
12
13 $self->host($host || 'localhost');
14 $self->user($user || 'root');
15 $self->pass($pass);
16 $self->port($port);
17 $self->driver($driver || 'mysql');
18 $self->dbname($dbname);
19 }
20  
21 sub prepare {
22 my ($self, $sql)=@_;
23 return $self->db_handle->prepare($sql);
24 }
25  
26 sub db_handle {
27 my $self = shift;
28
29 if(! exists $self->{_db_handle} || @_){
30 my $locator = shift || $self->_db_locator;
31 my $user=$self->user;
32 my $dbh;
33 eval{$dbh=DBI->connect($locator, $user, $self->pass, {RaiseError=>1}) };
34 $dbh || die <<END;
35 Could not connect by [$user] using [$locator] as a locator.
36 $DBI::errstr
37 END
38 $self->{_current_locator}=$locator;
39 $self->{_db_handle}=$dbh;
40 }
41 return $self->{_db_handle};
42 }
43  
44 sub DESTROY {
45 my $self=shift;
46 $self->db_handle->disconnect;
47 $self->{_db_handle}=undef;
48 }
49  
50 sub _host_locator {
51 my $self=shift;
52 my $locator='dbi:'. $self->driver .':';
53 foreach my $meth(qw(host port)){
54 if(my $value=$self->$meth){ $locator .="$meth=$value;"; }
55 }
56 return $locator;
57 }
58  
59 our %DBNAME_PARAM = (
60 mysql => 'database=',
61 Pg => 'dbname=',
62 Oracle => ''
63 );
64  
65 sub _db_locator {
66 my $self=shift;
67 my $locator=$self->_host_locator;
68 $locator .= $DBNAME_PARAM{$self->driver} . $self->dbname;
69 return $locator;
70 }
71  
72  
73 1;