X-Git-Url: http://git.shadowcat.co.uk/gitweb/gitweb.cgi?a=blobdiff_plain;f=lib%2FDBIx%2FClass%2FStorage%2FDBI%2FODBC%2FFirebird.pm;h=c5254b491fe59d300afb130b2aba4962b77c08c3;hb=f3d7b702505f7eabec97857ffcba3f99edcd9d8d;hp=11af6586983da7a384b82444a13c26493cf4822d;hpb=a499b173840b72f8e6d32cc1935017daab8826f5;p=dbsrgits%2FDBIx-Class.git diff --git a/lib/DBIx/Class/Storage/DBI/ODBC/Firebird.pm b/lib/DBIx/Class/Storage/DBI/ODBC/Firebird.pm index 11af658..c5254b4 100644 --- a/lib/DBIx/Class/Storage/DBI/ODBC/Firebird.pm +++ b/lib/DBIx/Class/Storage/DBI/ODBC/Firebird.pm @@ -2,59 +2,62 @@ package DBIx::Class::Storage::DBI::ODBC::Firebird; use strict; use warnings; -use base qw/DBIx::Class::Storage::DBI::InterBase/; +use base qw/ + DBIx::Class::Storage::DBI::ODBC + DBIx::Class::Storage::DBI::Firebird::Common +/; use mro 'c3'; +use Try::Tiny; +use namespace::clean; =head1 NAME DBIx::Class::Storage::DBI::ODBC::Firebird - Driver for using the Firebird RDBMS through ODBC -=head1 SYNOPSIS +=head1 DESCRIPTION -Most functionality is provided by L, see -that module for details. +Most functionality is provided by +L, see that driver for details. To build the ODBC driver for Firebird on Linux for unixODBC, see: L -=cut - -# XXX seemingly no equivalent to ib_time_all in DBD::InterBase via ODBC -sub connect_call_datetime_setup { 1 } +This driver does not suffer from the nested statement handles across commits +issue that the L or the +L based driver does. This +makes it more suitable for long running processes such as under L. -# from MSSQL +=cut -sub build_datetime_parser { +# batch operations in DBD::ODBC 1.35 do not work with the official ODBC driver +sub _run_connection_actions { my $self = shift; - my $type = "DateTime::Format::Strptime"; - eval "use ${type}"; - $self->throw_exception("Couldn't load ${type}: $@") if $@; - return $type->new( - pattern => '%Y-%m-%d %H:%M:%S', # %F %T - on_error => 'croak', - ); -} - -# we don't need DBD::InterBase-specific initialization -sub _init { 1 } - -# ODBC uses dialect 3 by default, good -sub _set_sql_dialect { 1 } - -1; - -=head1 CAVEATS -=over 4 + if ($self->_dbh_get_info('SQL_DRIVER_NAME') eq 'OdbcFb') { + $self->_disable_odbc_array_ops; + } -=item * - -This driver (unlike L) does not currently support reading or -writing C values with sub-second precision. + return $self->next::method(@_); +} -=back +# releasing savepoints doesn't work for some reason, but that shouldn't matter +sub _exec_svp_release { 1 } + +sub _exec_svp_rollback { + my ($self, $name) = @_; + + try { + $self->_dbh->do("ROLLBACK TO SAVEPOINT $name") + } + catch { + # Firebird ODBC driver bug, ignore + if (not /Unable to fetch information about the error/) { + $self->throw_exception($_); + } + }; +} =head1 AUTHOR @@ -65,3 +68,6 @@ See L and L. You may distribute this code under the same terms as Perl itself. =cut +# vim:sts=2 sw=2: + +1;