| 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; |