X-Git-Url: http://git.shadowcat.co.uk/gitweb/gitweb.cgi?a=blobdiff_plain;f=lib%2FDBIx%2FClass%2FStorage%2FDBI%2FInterBase.pm;h=3bce1569854e0a73aa68983a2e694a7f25cafce6;hb=96736321fa6fb1efc9e471b037e508778188dbbe;hp=2a789b519cea1d6278357eaabc13910024188d66;hpb=ecdf1ac8ec414ab62b84c78bad176e125dff553d;p=dbsrgits%2FDBIx-Class.git diff --git a/lib/DBIx/Class/Storage/DBI/InterBase.pm b/lib/DBIx/Class/Storage/DBI/InterBase.pm index 2a789b5..3bce156 100644 --- a/lib/DBIx/Class/Storage/DBI/InterBase.pm +++ b/lib/DBIx/Class/Storage/DBI/InterBase.pm @@ -1,16 +1,12 @@ package DBIx::Class::Storage::DBI::InterBase; -# partly stolen from DBIx::Class::Storage::DBI::MSSQL - use strict; use warnings; use base qw/DBIx::Class::Storage::DBI/; use mro 'c3'; -use List::Util(); - -__PACKAGE__->mk_group_accessors(simple => qw/ - _auto_incs -/); +use List::Util 'first'; +use Try::Tiny; +use namespace::clean; =head1 NAME @@ -35,56 +31,7 @@ L. =cut -sub _prep_for_execute { - my $self = shift; - my ($op, $extra_bind, $ident, $args) = @_; - - if ($op eq 'insert') { - $self->_auto_incs([]); - - my %pk; - @pk{$ident->primary_columns} = (); - - my @auto_inc_cols = grep { - my $inserting = $args->[0]{$_}; - - ($ident->column_info($_)->{is_auto_increment} - || exists $pk{$_}) - && ( - (not defined $inserting) - || - (ref $inserting eq 'SCALAR' && $$inserting =~ /^null\z/i) - ) - } $ident->columns; - - if (@auto_inc_cols) { - $args->[1]{returning} = \@auto_inc_cols; - - $self->_auto_incs->[0] = \@auto_inc_cols; - } - } - - return $self->next::method(@_); -} - -sub _execute { - my $self = shift; - my ($op) = @_; - - my ($rv, $sth, @bind) = $self->dbh_do($self->can('_dbh_execute'), @_); - - if ($op eq 'insert' && $self->_auto_incs) { - local $@; - my (@auto_incs) = eval { - local $SIG{__WARN__} = sub {}; - $sth->fetchrow_array - }; - $self->_auto_incs->[1] = \@auto_incs; - $sth->finish; - } - - return wantarray ? ($rv, $sth, @bind) : $rv; -} +sub _supports_insert_returning { 1 } sub _sequence_fetch { my ($self, $nextval, $sequence) = @_; @@ -94,13 +41,13 @@ sub _sequence_fetch { } $self->throw_exception('No sequence to fetch') unless $sequence; - + my ($val) = $self->_get_dbh->selectrow_array( 'SELECT GEN_ID(' . $self->sql_maker->_quote($sequence) . ', 1) FROM rdb$database'); return $val; -} +} sub _dbh_get_autoinc_seq { my ($self, $dbh, $source, $col) = @_; @@ -133,7 +80,7 @@ EOF $generator = uc $generator unless $quoted; return $generator - if List::Util::first { + if first { $self->sql_maker->quote_char ? ($_ eq $col) : (uc($_) eq uc($col)) } @trig_cols; } @@ -142,34 +89,6 @@ EOF return undef; } -sub last_insert_id { - my ($self, $source, @cols) = @_; - my @result; - - my %auto_incs; - @auto_incs{ @{ $self->_auto_incs->[0] } } = - @{ $self->_auto_incs->[1] }; - - push @result, $auto_incs{$_} for @cols; - - return @result; -} - -sub insert { - my $self = shift; - - my $updated_cols = $self->next::method(@_); - - if ($self->_auto_incs->[0]) { - my %auto_incs; - @auto_incs{ @{ $self->_auto_incs->[0] } } = @{ $self->_auto_incs->[1] }; - - $updated_cols = { %$updated_cols, %auto_incs }; - } - - return $updated_cols; -} - # this sub stolen from DB2 sub _sql_maker_opts { @@ -208,11 +127,12 @@ sub _ping { local $dbh->{RaiseError} = 1; local $dbh->{PrintError} = 0; - eval { + return try { $dbh->do('select 1 from rdb$database'); + 1; + } catch { + 0; }; - - return $@ ? 0 : 1; } # We want dialect 3 for new features and quoting to work, DBD::InterBase uses @@ -238,6 +158,16 @@ sub _set_sql_dialect { } } +sub _get_server_version { + my $self = shift; + + return $self->next::method(@_) if ref $self ne __PACKAGE__; + + local $SIG{__WARN__} = sub {}; # silence warning due to bug in DBD::InterBase + + return $self->next::method(@_); +} + =head2 connect_call_use_softcommit Used as: