X-Git-Url: http://git.shadowcat.co.uk/gitweb/gitweb.cgi?a=blobdiff_plain;f=lib%2FDBIx%2FClass%2FStorage%2FDBI%2FODBC%2FFirebird.pm;h=6f6acdfdec5a0faa4d9d90fc4ac1f2ea4a5ddd36;hb=1db83fb9ce3e15d68e2384720ed06af6de5edbac;hp=58a36758dd3d5a3293f36d5c9eec1f9d20627afe;hpb=32323fc22fa9fb54fc1a4702358450ce5a38b803;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 58a3675..6f6acdf 100644 --- a/lib/DBIx/Class/Storage/DBI/ODBC/Firebird.pm +++ b/lib/DBIx/Class/Storage/DBI/ODBC/Firebird.pm @@ -10,7 +10,7 @@ use mro 'c3'; 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. @@ -19,31 +19,71 @@ 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. + =cut -# XXX seemingly no equivalent to ib_time_all in DBD::InterBase via ODBC +# XXX seemingly no equivalent to ib_time_all from DBD::InterBase via ODBC sub connect_call_datetime_setup { 1 } -# from MSSQL +# we don't need DBD::InterBase-specific initialization +sub _init { 1 } + +# ODBC uses dialect 3 by default, good +sub _set_sql_dialect { 1 } + +# releasing savepoints doesn't work, but that shouldn't matter +sub _svp_release { 1 } + +sub datetime_parser_type { + 'DBIx::Class::Storage::DBI::ODBC::Firebird::DateTime::Format' +} + +package # hide from PAUSE + DBIx::Class::Storage::DBI::ODBC::Firebird::DateTime::Format; + +# 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_parser; -sub build_datetime_parser { - 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 +sub parse_datetime { + shift; + require DateTime::Format::Strptime; + $timestamp_parser ||= DateTime::Format::Strptime->new( + pattern => $timestamp_format, on_error => 'croak', ); + return $timestamp_parser->parse_datetime(shift); +} + +sub format_datetime { + shift; + require DateTime::Format::Strptime; + $timestamp_parser ||= DateTime::Format::Strptime->new( + pattern => $timestamp_format, + on_error => 'croak', + ); + return $timestamp_parser->format_datetime(shift); } 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.