Страницы справочника OS X

Эта страница руководства для  версии 10.9 Mac OS X

Читать страницы руководства

DBIx::Class::Storage::DBI::SQLAnywhere(3) Contributed Perl Documentation:Class::Storage::DBI::SQLAnywhere(3)



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

DESCRIPTION
       This class implements autoincrements for SQL Anywhere and provides
       DBIx::Class::InflateColumn::DateTime support and support for the "uniqueidentifier" type (via
       DBIx::Class::Storage::DBI::SQLAnywhere::Cursor.)

       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 settings:

         on_connect_call => 'datetime_setup'

METHODS
   connect_call_datetime_setup
       Used as:

           on_connect_call => 'datetime_setup'

       In connect_info 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.

MAXIMUM CURSORS
       A DBIx::Class application can use a lot of cursors, due to the usage of prepare_cached.

       The default cursor maximum is 50, which can be a bit too low. This limit can be turned off (or
       increased) by the DBA by executing:

         set option max_statement_count = 0
         set option max_cursor_count    = 0

       Highly recommended.

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

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



perl v5.12.5                                     2011-07-26        DBIx::Class::Storage::DBI::SQLAnywhere(3)