Claus Färber > DateTime-Format-DBI-0.041 > DateTime::Format::DBI

Download:
DateTime-Format-DBI-0.041.tar.gz

Dependencies

Annotate this POD

CPAN RT

Open  0
View/Report Bugs
Module Version: 0.041   Source  

NAME ^

DateTime::Format::DBI - Find a parser class for a database connection.

SYNOPSIS ^

  use DBI;
  use DateTime;
  use DateTime::Format::DBI;

  my $db = DBI->connect('dbi:...');
  my $db_parser = DateTime::Format::DBI->new($dbh);
  my $dt = DateTime->now();

  $db->do("UPDATE table SET dt=? WHERE foo='bar'",undef,
    $db_parser->format_datetime($dt);

DESCRIPTION ^

This module finds a DateTime::Format::* class that is suitable for the use with a given DBI connection (and DBD::* driver).

It currently supports the following format modules: IBM DB2 (DB2), Microsoft SQL (MSSQL), MySQL, Oracle, PostgreSQL (Pg), SQLite, and Sybase.

NOTE: This module provides a quick method to find the correct parser and formatter class. However, this is usually not sufficient for full database abstraction. You will also have to cater for differences in the syntax and semantics of SQL datetime functions (and other SQL commands).

CLASS METHODS ^

This module provides a single factory method:

PARSER/FORMATTER INTERFACE ^

DateTime::Format::DBI is just a front-end class factory that will return one of the format classes based on the nature of your $dbh.

For information on the interface of the returned parser object, please see the documentation for the class pertaining to your particular $dbh.

In general, parser classes for databases will implement the following methods. For more information on the exact behaviour of these methods, see the documentation of the parser class.

Parser/formatter classes may additionally define methods like parse_type or format_type (where type is derived from the SQL type); please see the documentation of the individual format class for more information.

SUPPORT ^

Please report bugs and other requests to the rt tracker: https://rt.cpan.org/Public/Dist/Display.html?Name=DateTime-Format-DBI.

AUTHOR ^

Claus Färber <CFAERBER@cpan.org>

LICENSE ^

Copyright 2003-2013 Claus Färber. All rights reserved.

This program is free software; you can redistribute it and/or modify it under the same terms as Perl itself.

The full text of the license can be found in the LICENSE file included with this module.

SEE ALSO ^

DateTime, DBI

datetime@perl.org mailing list

http://datetime.perl.org/

syntax highlighting: