X-Git-Url: http://git.shadowcat.co.uk/gitweb/gitweb.cgi?a=blobdiff_plain;f=lib%2FDBIx%2FClass%2FStorage%2FDBI%2FInterBase.pm;h=e14277a0d314b284ba1b5df3211f8e6fef60454d;hb=d5dedbd62928f65a9071b4d9b6d56c6b663a073b;hp=3664d9c90d03685bfde419f4bb30026e8d4a95a6;hpb=bab40deebe87977cb35055321a722d0d1ccebcd5;p=dbsrgits%2FDBIx-Class.git diff --git a/lib/DBIx/Class/Storage/DBI/InterBase.pm b/lib/DBIx/Class/Storage/DBI/InterBase.pm index 3664d9c..e14277a 100644 --- a/lib/DBIx/Class/Storage/DBI/InterBase.pm +++ b/lib/DBIx/Class/Storage/DBI/InterBase.pm @@ -4,7 +4,9 @@ use strict; use warnings; use base qw/DBIx::Class::Storage::DBI/; use mro 'c3'; -use List::Util(); +use List::Util 'first'; +use Try::Tiny; +use namespace::clean; =head1 NAME @@ -13,8 +15,8 @@ DBIx::Class::Storage::DBI::InterBase - Driver for the Firebird RDBMS =head1 DESCRIPTION This class implements autoincrements for Firebird using C as well as -L sets the limit dialect to -C and provides L support. +L and provides +L support. You need to use either the L option or @@ -29,7 +31,9 @@ L. =cut -sub can_insert_returning { 1 } +# set default +__PACKAGE__->_use_insert_returning (1); +__PACKAGE__->sql_limit_dialect ('FirstSkip'); sub _sequence_fetch { my ($self, $nextval, $sequence) = @_; @@ -39,13 +43,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) = @_; @@ -78,7 +82,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; } @@ -87,18 +91,6 @@ EOF return undef; } -# this sub stolen from DB2 - -sub _sql_maker_opts { - my ( $self, $opts ) = @_; - - if ( $opts ) { - $self->{_sql_maker_opts} = { %$opts }; - } - - return { limit_dialect => 'FirstSkip', %{$self->{_sql_maker_opts}||{}} }; -} - sub _svp_begin { my ($self, $name) = @_; @@ -125,11 +117,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 @@ -155,6 +148,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: