DBIx::SQLEngine::Driver::AnyData - Extends SQLEngine for DBMS Idiosyncrasies
my $sqldb = DBIx::SQLEngine->new( 'dbi:AnyData:test' ); $hash_ary = $sqldb->fetch_select( table => 'students' limit => 5, offset => 10 );
This package provides a subclass of DBIx::SQLEngine which compensates for DBD::AnyData's idiosyncrasies.
Special handling for simple functions.
Adds support for SQL select limit clause.
TODO: Needs workaround to support offset.
$sqldb->do_insert_with_sequence( $sequence_name, %sql_clauses ) : $row_count
Implemented using DBIx::SQLEngine::Mixin::SeqTable.
$sqldb->detect_any ( ) : $boolean
Returns 1, as we presume that the requisite driver modules are available or we wouldn't have reached this point.
$sqldb->sql_detect_table ( $tablename ) : %sql_select_clauses
Implemented using AnyData's "select * from $tablename limit 1".
$sqldb->dbms_create_column_types () : %column_type_codes
Implemented using AnyData's varchar and int types.
$sqldb->dbms_create_column_text_long_type () : $col_type_str
Implemented as varchar(16384).
$ds->ad_catalog( $table_name, $any_data_format, $file_name );
Uses AnyData's 'ad_catalog' function to map in a new data file.
$sqldb->recoverable_query_exceptions() : @common_error_messages
Provides a list of error messages which represent common communication failures or other incidental errors.
See DBIx::SQLEngine for the overall interface and developer documentation.
See DBIx::SQLEngine::Docs::ReadMe for general information about this distribution, including installation and license information.
To install DBIx::SQLEngine, copy and paste the appropriate command in to your terminal.
cpanm
cpanm DBIx::SQLEngine
CPAN shell
perl -MCPAN -e shell install DBIx::SQLEngine
For more information on module installation, please visit the detailed CPAN module installation guide.