++ed by:
EMAZEP MELO DBOEHMER FIBO PLU

107 PAUSE users
105 non-PAUSE users.

Peter Rabbitson 🐟‍👂
and 1 contributors

NAME

DBIx::Class::Storage::DBI::SQLAnywhere - Driver for Sybase SQL Anywhere

DESCRIPTION

This class implements autoincrements for Sybase SQL Anywhere, selects the RowNumberOver limit implementation and provides DBIx::Class::InflateColumn::DateTime support.

You need the DBD::SQLAnywhere driver that comes with the SQL Anywhere distribution, NOT the one on CPAN. It is usually under a path such as:

  /opt/sqlanywhere11/sdk/perl

Recommended "connect_info" in DBIx::Class::Storage::DBI settings:

  on_connect_call => 'datetime_setup'

METHODS

connect_call_datetime_setup

Used as:

    on_connect_call => 'datetime_setup'

In "connect_info" in DBIx::Class::Storage::DBI to set the date and timestamp formats (as temporary options for the session) for use with DBIx::Class::InflateColumn::DateTime.

The TIMESTAMP data type supports up to 6 digits after the decimal point for second precision. The full precision is used.

The DATE data type supposedly stores hours and minutes too, according to the documentation, but I could not get that to work. It seems to only store the date.

You will need the DateTime::Format::Strptime module for inflation to work.

AUTHOR

See "AUTHOR" in DBIx::Class and "CONTRIBUTORS" in DBIx::Class.

LICENSE

You may distribute this code under the same terms as Perl itself.