debian man page for alzabo::runtime::inserthandle

Query: alzabo::runtime::inserthandle

OS: debian

Section: 3pm

Format: Original Unix Latex Style Formatted with HTML and a Horizontal Scroll Bar

Alzabo::Runtime::InsertHandle(3pm)			User Contributed Perl Documentation			Alzabo::Runtime::InsertHandle(3pm)

NAME
Alzabo::Runtime::InsertHandle - A handle representing an insert
SYNOPSIS
my $handle = $table->insert_handle ( columns => [ $table->columns( 'name', 'job' ) ] ); my $faye_row = $handle->insert( values => { name => 'Faye', job => 'HK Pop Chanteuse' } ); my $guesch_row = $handle->insert( values => { name => 'Guesch', job => 'French Chanteuse and Dancer' } );
DESCRIPTION
This object is analogous to a DBI statement handle, and can be used to insert multiple rows into a table more efficiently than repeatedly calling "Alzabo::Runtime::Table->insert()".
METHODS
Objects of this class provide one public method: insert This method is used to insert a new row into a table. It accepts the following parameters: * values This should be a hash reference containing the values to be inserted into the table. If no value is given for a primary key column and the column is "sequenced" then the primary key will be auto-generated. If values are not provided for other columns which were given when "Alzabo::Runtime::Table->insert_handle" was called, this method first checks to see if a value was provided for the column when "Alzabo::Runtime::Table->insert_handle" was called. If none was pro- vided, then the column's default value is used. If column values were passed to "Alzabo::Runtime::Table->insert_handle", then these can be overridden by values passed to this method. It is not possible to override column values that were given as SQL functions when "Alzabo::Runtime::Table->insert_handle" was called. This method returns a new "Alzabo::Runtime::Row" object. Throws: "Alzabo::Exception::Logic", "Alzabo::Exception::Params" perl v5.8.8 2007-12-23 Alzabo::Runtime::InsertHandle(3pm)
Related Man Pages
alzabo::create::column(3pm) - debian
alzabo::create::index(3pm) - debian
alzabo::create::table(3pm) - debian
alzabo::runtime::joincursor(3pm) - debian
alzabo::table(3pm) - debian
Similar Topics in the Unix Linux Community
help me to to insert data
How to insert alternative columns and sort text from first column to second?
Read parameter file in a shell script to unload a DB2 Table???
Reorder and insert column using awk
Another method for this snippet