DBIx::SQLEngine::Driver::Pg - Extends SQLEngine for DBMS Idiosyncrasies
my $sqldb = DBIx::SQLEngine->new( 'dbi:pg:test' ); $hash_ary = $sqldb->fetch_select( table => 'students' limit => 5, offset => 10 );
This package provides a subclass of DBIx::SQLEngine which compensates for Postgres's idiosyncrasies.
$sqldb->sql_limit( $limit, $offset, $sql, @params ) : $sql, @params
Adds support for SQL select limit clause.
$sqldb->do_insert_with_sequence( $sequence_name, %sql_clauses ) : $row_count
Implemented using _seq_do_insert_preinc and seq_increment.
$sqldb->seq_increment( $table, $field ) : $new_value
Increments the sequence, and returns the newly allocated value.
# $rows = $self->do_insert_with_sequence( $sequence, %clauses ); sub do_insert_with_sequence { (shift)->_seq_do_insert_preinc( @_ ) }
# $current_id = $sqldb->seq_increment( $table, $field ); sub seq_increment { my ($self, $table, $field) = @_; $self->fetch_one_value( sql => "SELECT nextval('${table}_${field}_seq')" ); }
########################################################################
$sqldb->dbms_create_column_types () : %column_type_codes
Implemented using Pg's bytea and serial types.
$sqldb->dbms_create_column_text_long_type () : $col_type_str
Implemented using Pg's text type.
$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.
1 POD Error
The following errors were encountered while parsing the POD:
=back without =over
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.