X-Git-Url: http://git.shadowcat.co.uk/gitweb/gitweb.cgi?a=blobdiff_plain;f=lib%2FDBIx%2FClass%2FStorage%2FDBI.pm;h=4ee25cc0ff1292fedb1457238cc4eaa91c15965c;hb=1346e22d4899edf837c77312259c3ebaaf71f602;hp=03f3a6cac5ecc386dc6f7d9aa5016579ef569641;hpb=e535069e2685255d87c39b39d5f91f00a2548f3a;p=dbsrgits%2FDBIx-Class.git diff --git a/lib/DBIx/Class/Storage/DBI.pm b/lib/DBIx/Class/Storage/DBI.pm index 03f3a6c..4ee25cc 100644 --- a/lib/DBIx/Class/Storage/DBI.pm +++ b/lib/DBIx/Class/Storage/DBI.pm @@ -210,8 +210,8 @@ use base qw/DBIx::Class/; __PACKAGE__->load_components(qw/AccessorGroup/); __PACKAGE__->mk_group_accessors('simple' => - qw/connect_info _dbh _sql_maker _connection_pid debug debugfh cursor - on_connect_do transaction_depth/); + qw/connect_info _dbh _sql_maker _conn_pid _conn_tid debug debugfh + cursor on_connect_do transaction_depth/); sub new { my $new = bless({}, ref $_[0] || $_[0]); @@ -290,8 +290,20 @@ sub disconnect { sub connected { my ($self) = @_; - my $dbh; - (($dbh = $self->_dbh) && $dbh->FETCH('Active') && $dbh->ping) + if(my $dbh = $self->_dbh) { + if(defined $self->_conn_tid && $self->_conn_tid != threads->tid) { + $self->_sql_maker(undef); + return $self->_dbh(undef); + } + elsif($self->_conn_pid != $$) { + $self->_dbh->{InactiveDestroy} = 1; + $self->_sql_maker(undef); + return $self->_dbh(undef) + } + return ($dbh->FETCH('Active') && $dbh->ping); + } + + return 0; } sub ensure_connected { @@ -305,10 +317,6 @@ sub ensure_connected { sub dbh { my ($self) = @_; - if($self->_connection_pid && $self->_connection_pid != $$) { - $self->_dbh->{InactiveDestroy} = 1; - $self->_dbh(undef) - } $self->ensure_connected; return $self->_dbh; } @@ -335,7 +343,8 @@ sub _populate_dbh { $self->_dbh->do($sql_statement); } - $self->_connection_pid($$); + $self->_conn_pid($$); + $self->_conn_tid(threads->tid) if $INC{'threads.pm'}; } sub _connect { @@ -412,7 +421,7 @@ sub txn_rollback { else { --$self->{transaction_depth} == 0 ? $self->dbh->rollback : - die DBIx::Class::Storage::NESTED_ROLLBACK_EXCEPTION->new; + die DBIx::Class::Storage::NESTED_ROLLBACK_EXCEPTION->new; } }; @@ -543,7 +552,7 @@ sub last_insert_id { sub sqlt_type { shift->dbh->{Driver}->{Name} } sub deployment_statements { - my ($self, $schema, $type) = @_; + my ($self, $schema, $type, $sqltargs) = @_; $type ||= $self->sqlt_type; eval "use SQL::Translator"; $self->throw_exception("Can't deploy without SQL::Translator: $@") if $@; @@ -551,15 +560,16 @@ sub deployment_statements { $self->throw_exception($@) if $@; eval "use SQL::Translator::Producer::${type};"; $self->throw_exception($@) if $@; - my $tr = SQL::Translator->new(); + my $tr = SQL::Translator->new(%$sqltargs); SQL::Translator::Parser::DBIx::Class::parse( $tr, $schema ); return "SQL::Translator::Producer::${type}"->can('produce')->($tr); } sub deploy { - my ($self, $schema, $type) = @_; - foreach(split(";\n", $self->deployment_statements($schema, $type))) { - $self->dbh->do($_) or warn "SQL was:\n $_"; + my ($self, $schema, $type, $sqltargs) = @_; + foreach(split(";\n", $self->deployment_statements($schema, $type, $sqltargs))) { + $self->debugfh->print("$_\n") if $self->debug; + $self->dbh->do($_) or warn "SQL was:\n $_"; } }