DBIx::Class::Storage::DBI::SQLAnywhere - Driver for Sybase SQL Anywhere
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 settings:
on_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.
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.
DESTROY, auto_savepoint, bind_attribute_by_data_type, columns_info_for, connect_call_do_sql, connect_info, connected, create_ddl_dir, datetime_parser, datetime_parser_type, dbh, dbh_do, delete, deploy, deployment_statements, disable_sth_caching, disconnect, disconnect_call_do_sql, ensure_connected, get_dbms_capability, get_use_dbms_capability, insert_bulk, is_datatype_numeric, is_replicating, lag_behind_master, new, on_connect_call, on_connect_do, on_disconnect_call, on_disconnect_do, relname_to_table_alias, savepoints, select, select_single, set_dbms_capability, set_use_dbms_capability, source_bind_attributes, sql_maker, sql_maker_class, sqlt_type, sth, svp_begin, svp_release, svp_rollback, transaction_depth, txn_begin, txn_commit, txn_do, txn_rollback, unsafe, update, with_deferred_fk_checks
cursor, cursor_class, debug, debugcb, debugfh, debugobj, schema, set_schema, throw_exception, txn_scope_guard
MODIFY_CODE_ATTRIBUTES, component_base_class, mk_classaccessor, mk_classdata
inject_base
ensure_class_found, ensure_class_loaded, load_components, load_optional_class, load_optional_components, load_own_components
get_component_class, get_inherited, get_simple, get_super_paths, make_group_accessor, make_group_ro_accessor, make_group_wo_accessor, mk_group_accessors, mk_group_ro_accessors, mk_group_wo_accessors, set_component_class, set_inherited, set_simple
DESTROY, auto_savepoint, bind_attribute_by_data_type, columns_info_for, connect_call_do_sql, connect_info, connected, create_ddl_dir, datetime_parser, datetime_parser_type, dbh, dbh_do, delete, deploy, deployment_statements, disable_sth_caching, disconnect, disconnect_call_do_sql, ensure_connected, get_dbms_capability, get_use_dbms_capability, insert_bulk, is_datatype_numeric, is_replicating, lag_behind_master, new, on_connect_call, on_connect_do, on_disconnect_call, on_disconnect_do, relname_to_table_alias, savepoints, select, select_single, set_dbms_capability, set_use_dbms_capability, source_bind_attributes, sql_maker, sql_maker_class, sqlt_type, sth, svp_begin, svp_release, svp_rollback, transaction_depth, txn_begin, txn_commit, txn_do, txn_rollback, unsafe, update, with_deferred_fk_checks
cursor, cursor_class, debug, debugcb, debugfh, debugobj, schema, set_schema, throw_exception, txn_scope_guard
MODIFY_CODE_ATTRIBUTES, component_base_class, mk_classaccessor, mk_classdata
inject_base
ensure_class_found, ensure_class_loaded, load_components, load_optional_class, load_optional_components, load_own_components
get_component_class, get_inherited, get_simple, get_super_paths, make_group_accessor, make_group_ro_accessor, make_group_wo_accessor, mk_group_accessors, mk_group_ro_accessors, mk_group_wo_accessors, set_component_class, set_inherited, set_simple
See "AUTHOR" in DBIx::Class and "CONTRIBUTORS" in DBIx::Class.
You may distribute this code under the same terms as Perl itself.