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=a5280453bd7fc86157fb4a84a451bddc2c408bf7;hp=2b91058204957f68ddec420140d8a6a1673e5bc9;hpb=8f0a1e0782630d46ecee17e04dbe2ab9d6525f61;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 2b91058..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,38 +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 } - -sub _populate_server_info { - goto &DBIx::Class::Storage::DBI::_populate_server_info + 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 @@ -52,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 { @@ -77,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. @@ -97,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: