X-Git-Url: http://git.shadowcat.co.uk/gitweb/gitweb.cgi?a=blobdiff_plain;f=lib%2FDBIx%2FClass%2FStorage%2FDBI%2FODBC%2FFirebird.pm;h=ac0afbbef7583e69a514aa8cf1eec413d14af406;hb=2b6d7e87bdf3f09e79cc19d209e52e78000f0578;hp=6f6acdfdec5a0faa4d9d90fc4ac1f2ea4a5ddd36;hpb=d1fc96c751817183519e91eac61129ec3629a325;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 6f6acdf..ac0afbb 100644 --- a/lib/DBIx/Class/Storage/DBI/ODBC/Firebird.pm +++ b/lib/DBIx/Class/Storage/DBI/ODBC/Firebird.pm @@ -2,8 +2,13 @@ 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 @@ -12,34 +17,48 @@ through ODBC =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 This driver does not suffer from the nested statement handles across commits -issue that the L based -driver does. This makes it more suitable for long running processes such as -under L. +issue that the L or the +L based driver does. This +makes it more suitable for long running processes such as under L. =cut -# XXX seemingly no equivalent to ib_time_all from DBD::InterBase via ODBC -sub connect_call_datetime_setup { 1 } +__PACKAGE__->datetime_parser_type ('DBIx::Class::Storage::DBI::ODBC::Firebird::DateTime::Format'); -# we don't need DBD::InterBase-specific initialization -sub _init { 1 } +# batch operations in DBD::ODBC 1.35 do not work with the official ODBC driver +sub _run_connection_actions { + my $self = shift; -# ODBC uses dialect 3 by default, good -sub _set_sql_dialect { 1 } + if ($self->_dbh_get_info('SQL_DRIVER_NAME') eq 'OdbcFb') { + $self->_disable_odbc_array_ops; + } -# releasing savepoints doesn't work, but that shouldn't matter -sub _svp_release { 1 } + return $self->next::method(@_); +} -sub datetime_parser_type { - 'DBIx::Class::Storage::DBI::ODBC::Firebird::DateTime::Format' +# 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($_); + } + }; } package # hide from PAUSE @@ -48,7 +67,7 @@ package # hide from PAUSE # inherit parse/format date our @ISA = 'DBIx::Class::Storage::DBI::InterBase::DateTime::Format'; -my $timestamp_format = '%Y-%m-%d %H:%M:%S'; # %F %T, no fractional part +my $timestamp_format = '%Y-%m-%d %H:%M:%S.%4N'; # %F %T my $timestamp_parser; sub parse_datetime { @@ -73,17 +92,6 @@ sub format_datetime { 1; -=head1 CAVEATS - -=over 4 - -=item * - -This driver (unlike L) does not currently support reading or -writing C values with sub-second precision. - -=back - =head1 AUTHOR See L and L. @@ -93,3 +101,4 @@ See L and L. You may distribute this code under the same terms as Perl itself. =cut +# vim:sts=2 sw=2: